Got Bit by A Docker Default on my Postgres Container, Interesting Story, let us discuss! - podcast episode cover

Got Bit by A Docker Default on my Postgres Container, Interesting Story, let us discuss!

Jan 03, 20216 min
--:--
--:--
Download Metacast podcast app
Listen to this episode in Metacast mobile app
Don't just listen to podcasts. Learn from them with transcripts, summaries, and chapters for every episode. Skim, search, and bookmark insights. Learn more

Episode description

While working on a Postgres docker container executing some queries I noticed that my index-only scan query is hitting the heap which it shouldn't. After digging deep I found that it's the shared memory that docker allocates by default. Defaults are never enough, very interesting train of thought that I thought I’d share with you  The Blog I found that helped me find it https://blog.makandra.com/2018/11/investigating-slow-postgres-index-only-scans/

For the best experience, listen in Metacast app for iOS or Android