News for hackers. Stuff that matters.
Re:How to Get the Most Out of Postgres Memory Settings by sgarland on Wednesday June 12, 2024 @05:58PM (#40663672)
> 1 bit per page

Close, it’s 2 bits/page :-)

It’s not that it bloats, it’s that the hits are scattered among many pages. My wording wasn’t great on that point.

Some tests demonstrating this are here [0].

[0]: https://www.cybertec-postgresql.com/en/unexpected-downsides-...

Re:How to Get the Most Out of Postgres Memory Settings by aidos on Wednesday June 12, 2024 @06:36PM (#40663960)
Ah nice. Thanks for the extra info. I’m weirdly fascinated by the inner workings of Postgres.
Re:How to Get the Most Out of Postgres Memory Settings by Cwizard on Thursday June 13, 2024 @02:11AM (#40666453)
You might like: ‘PostgreSQL 14 Internals’ by Egor Rogov