On 11/07/2012 01:29 PM, Bryan Montgomery wrote:
Thanks for the insight. I know why some of the settings were set, but there are others that have been highlighted that now don't make sense. I'll strongly recommend adjusting those now.
Good. If you've been running with fsync=off all this time I hope you've also been keeping good backups.
BTW, I should've sent you a link to
http://wiki.postgresql.org/wiki/Number_Of_Database_Connections in my prior email, where I recommended connection pooling.
--
Craig Ringer