
Sign up to save your podcasts
Or


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/
By Hussein Nasser4.9
4040 ratings
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/

32,245 Listeners

273 Listeners

373 Listeners

12,165 Listeners

989 Listeners

8,110 Listeners

209 Listeners

1,658 Listeners

10,227 Listeners

548 Listeners

513 Listeners

5,547 Listeners

659 Listeners

1,471 Listeners

74 Listeners