
pg_stat_statements
Postgres FM
The Overhead of Having Bigger Numbers in Post-Gus
PGS statements max having at most 10,000. But when I go to edit on a cloud provider, for example, it says the max value is much higher than that. Of course, cloud providers can restrict additionally. For example, they allow you to set share buffers, not more than 60% of memory. And effective cache size,. not more than 70 or 80%. Sometimes I want more than 100% because I want the full post-gus to make planar work as on different size machine.
00:00
Transcript
Play full episode
Remember Everything You Learn from Podcasts
Save insights instantly, chat with episodes, and build lasting knowledge - all powered by AI.