4 ms·
I would have said, check your shared buffers memory and concurrency are configured right for the environment you are running on. The defaults are wrong for most
by zmmmmm 5y ago
I would have said, check your shared buffers memory and concurrency are configured right for the environment you are running on. The defaults are wrong for most production environments and the right values are highly server dependent. If you haven't specifically tuned them for your production server, chances are they are wrong and you are leaving substantial memory and / or concurrency on the table.
- nicoburns 5y agoHow would one go about determining the right values for these settings?
- zmmmmm 5y agoLooks like crunchdata has blog posts for that too! https://blog.crunchydata.com/blog/optimize-postgresql-server-performance https://blog.crunchydata.com/blog/optimize-postgresql-server...
- GordonS 5y agoI don't have links right now, but if you search for something like "online postgres config tool", you should find two different pages that do the same thing - you enter some data about your environment, and it spits out recommended settings.