Postgres FM cover image

pg_stat_statements

Postgres FM

CHAPTER

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.
App store bannerPlay store banner