Re: [GENERAL] Tuning / performance questions

2012-11-06 Thread Craig Ringer
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

Re: [GENERAL] Tuning / performance questions

2012-11-06 Thread Bryan Montgomery
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. On Tue, Nov 6, 2012 at 8:54 PM, Craig Ringer wrote: > Thanks for including your configuration and version; it

Re: [GENERAL] Tuning / performance questions

2012-11-06 Thread Craig Ringer
Thanks for including your configuration and version; it makes things much easier. Reply follows inline. On 11/06/2012 09:04 PM, Bryan Montgomery wrote: > I'm wondering what general ways there are to monitor and improve > performance? We look at pgadmin's server status but that only sees the > fun

Re: [GENERAL] Tuning / performance questions

2012-11-06 Thread Kevin Grittner
Bryan Montgomery wrote: > We have a system, that due to recent events is getting a lot > heavier use. The application makes extensive use of functions. > These functions would typically run sub-second but now can take > several seconds. > The server is running on suse 11.4 with 8 vcpu and 32Gb ra

[GENERAL] Tuning / performance questions

2012-11-06 Thread Bryan Montgomery
Hello experts! (and other like me). ** We have a system, that due to recent events is getting a lot heavier use. The application makes extensive use of functions. These functions would typically run sub-second but now can take several seconds. I'm wondering what general ways there are to monitor