From: "Joshua D. Your message is accepted. The reference number is. March 16, , It only takes a minute to sign up. Connect and share knowledge within a single location that is structured and easy to search. I have PostgreSQL 9. I realize that these values vary a lot between Linux and Windows so any help for best practices would be greatly appreciated! Again a lot of this is very workload specific.
I would probably start with a max connections of 20 unless you have a lot of idle connections as the norm. Always run test queries twice and discard the first one just to ensure comparable caching. However assuming you aren't running anything else that is a memory hog on the machine, I would start with default values and see how far those get you. Sign up to join this community. The best answers are voted up and rise to the top.
Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Learn more. Active Oldest Votes. Improve this answer. Magnus Hagander Magnus Hagander 2, 12 12 silver badges 7 7 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Stack Gives Back Safety in numbers: crowdsourcing data on nefarious IP addresses.
Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Linked Related 0.
0コメント