Re: [PERFORM] Checkpoints and slow queries

2014-04-27 Thread Elanchezhiyan Elango
> > The problem is that while this makes the checkpoints less frequent, it > accumulates more changes that need to be written to disk during the > checkpoint. Which means the impact more severe. True. But the checkpoints finish in approximately 5-10 minutes every time (even with checkpoint_complet

Re: [PERFORM] Checkpoints and slow queries

2014-04-27 Thread Tomas Vondra
On 27.4.2014 23:01, Elanchezhiyan Elango wrote: > (I am resending this question after waiting for several hours because > my previous mail got stalled probably because I didn't confirm my > email address after subscribing. So resending the mail. Sorry if this > is causing a double post.) > > *Pro

[PERFORM] Checkpoints and slow queries

2014-04-27 Thread Elanchezhiyan Elango
(I am resending this question after waiting for several hours because my previous mail got stalled probably because I didn't confirm my email address after subscribing. So resending the mail. Sorry if this is causing a double post.) *Problem description:* After a few days of running in my test env

Re: [PERFORM] pl/pgsql performance

2014-04-27 Thread Michael Paquier
On Fri, Apr 25, 2014 at 5:53 PM, Pavel Stehule wrote: > 2014-04-25 10:48 GMT+02:00 Mehdi Ravanbakhsh : >> 2- how i can chose max connection number for pgsql server based on cpu >> core and RAM capacity that have maximum Efficiency? > usually max performance is about 10 x CPU connections. But it hi