Thanks!
-Mensaje original-
De: Gabriele Bartolini [mailto:gabriele.bartol...@2ndquadrant.it]
Enviado el: jueves, 17 de noviembre de 2011 10:14 a.m.
Para: Anibal David Acosta
CC: pgsql-general@postgresql.org
Asunto: Re: [GENERAL] checkpoints are occurring too frequently
Hi Anibal
Hi Anibal,
On Thu, 17 Nov 2011 09:48:10 -0300, "Anibal David Acosta"
wrote:
What should be a correct value for checkpoint_segments to avoid
excessive checkpoint events?
There is no golden rule or value that fits all scenarios. Usually 32 is
a good value to start with, however it might not b
increase your checkpoint segments
--
GJ
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
>> The "factory default" has never been 1; AFAIR it's always been 3,
>> and like many of the other defaults that's aimed for small-and-slow
>> machines. If you're not short of disk space, something like 30
>> is reasonable. (Note this can cost you 32M
It's been suggested in the past that we ought to document multiple sets
of parameter choices from "small test platform" to "big fast machine";
MySQL have done something of the sort for a long time.
That is probably a good idea.
regards, tom lane
--
Your PostgreSQL
The "factory default" has never been 1; AFAIR it's always been 3,
and like many of the other defaults that's aimed for small-and-slow
machines. If you're not short of disk space, something like 30
is reasonable. (Note this can cost you 32MB per increment, so a
setting of 30 means you're willin
On Tue, 2005-07-12 at 15:55, Greg Patnude wrote:
> -Original Message-
> From: Scott Marlowe [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, July 12, 2005 11:40 AM
> To: Greg Patnude
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Checkpoints are occurring too fre
"Greg Patnude" <[EMAIL PROTECTED]> writes:
> From: Scott Marlowe [mailto:[EMAIL PROTECTED]
>> So, how often is this running? Once a second, once a minute, once and
>> hour? If it's only running once an hour, then something else is wrong.
> I've been running it about 2 or 3 times a minute on ave
-Original Message-
From: Scott Marlowe [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 12, 2005 11:40 AM
To: Greg Patnude
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Checkpoints are occurring too frequently...
On Tue, 2005-07-12 at 13:29, Greg Patnude wrote:
> "Scott
> LOG: checkpoints are occurring too frequently (19 seconds apart)
> HINT: Consider increasing the configuration parameter
> "checkpoint_segments".
> LOG: checkpoints are occurring too frequently (12 seconds apart)
> HINT: Consider increasing the configuration parameter
> "checkpoint_segments
On Tue, 2005-07-12 at 13:29, Greg Patnude wrote:
> "Scott Marlowe" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
> > On Tue, 2005-07-12 at 13:04, Greg Patnude wrote:
> >> LOG: checkpoints are occurring too frequently (19 seconds apart)
> >> HINT: Consider increasing the configura
"Scott Marlowe" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> On Tue, 2005-07-12 at 13:04, Greg Patnude wrote:
>> LOG: checkpoints are occurring too frequently (19 seconds apart)
>> HINT: Consider increasing the configuration parameter
>> "checkpoint_segments".
>> LOG: checkpoi
On Tue, 2005-07-12 at 13:04, Greg Patnude wrote:
> LOG: checkpoints are occurring too frequently (19 seconds apart)
> HINT: Consider increasing the configuration parameter
> "checkpoint_segments".
> LOG: checkpoints are occurring too frequently (12 seconds apart)
> HINT: Consider increasing th
13 matches
Mail list logo
