PostgreSQL Caching: What It Does and What to Add
Postgres has no query cache, but it caches more than you think. What shared_buffers, plans, and the OS cache do, and which result cache to add.
Read more →Tagged: performance
3 posts with this tag.
Why Your 99% Cache Hit Ratio Is Still Crushing Your Postgres CPU
Caching results is not the same as caching data. It's also harder. PgCache makes it easy.
Read more →PostgreSQL Query Optimizations
Examining how PostgreSQL's query optimizer has evolved from version 9.6 to 18.0, looking at three key SQL transformations.
Read more →