Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

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.


How would one go about determining the right values for these settings?


Looks like crunchdata has blog posts for that too!

https://blog.crunchydata.com/blog/optimize-postgresql-server...


I 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.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: