>
> 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
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
(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
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