Hacker News new | past | comments | ask | show | jobs | submit login
PgFincore – A set of functions to manage pages in memory from PostgreSQL (github.com)
37 points by turrini 6 days ago | hide | past | web | favorite | 3 comments





I wonder if there's any effort to use information like this in planning/query costing.

Not really. One of the major complications is that considering an index uncached might become a self fulfilling prophecy. Not using an index because it isn't cached leads to the index never becoming cached, even if long term it would be the better choice. In other cases the cached fraction might be tiny, but it is the option being actively used.

> Not using an index because it isn't cached ...

I'm more saying the opposite-- perhaps the real cost favors scanning the table if it is already resident while the normal costing would heavily vote against it based on the amount of disk access.




Guidelines | FAQ | Support | API | Security | Lists | Bookmarklet | Legal | Apply to YC | Contact

Search: