pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Alvaro Herrera <alvherre@surnet.cl>
To: Josh Berkus <josh@agliodbs.com>
Cc: David Parker <dparker@tazznetworks.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: checkpoint segments
Date: Mon, 16 May 2005 00:40:53 -0400
Message-ID: <20050516044053.GB9292@surnet.cl> (raw)
In-Reply-To: <200505152026.02262.josh@agliodbs.com>
References: <07FDEE0ED7455A48AC42AC2070EDFF7C74609A@corpsrv2.tazznetworks.com>
	<200505152026.02262.josh@agliodbs.com>

On Sun, May 15, 2005 at 08:26:02PM -0700, Josh Berkus wrote:
> David,
> 
> > I've seen these messages in the log before, and am aware of the need to
> > increase checkpoint_segments, but I wasn't aware that recycling a
> > transaction log could be that damaging to performance. There may have
> > been some local hiccup in this case, but I'm wondering if recycling is
> > known to be a big hit in general, and if I should strive to tune so that
> > it never happens (if that's possible)?
> 
> Yes, and yes.   Simply allocating more checkpoint segments (which can eat a 
> lot of disk space -- requirements are 16mb*(2 * segments +1) ) will prevent 
> this problem.

Hmm?  I disagree -- it will only make things worse when the checkpoint
does occur.

-- 
Alvaro Herrera (<alvherre[a]surnet.cl>)
"Lo esencial es invisible para los ojos" (A. de Saint Exúpery)



view thread (6+ messages)  latest in thread

Message-ID: <20050516044053.GB9292@surnet.cl>
Permalink:  ../20050516044053.GB9292@surnet.cl/
Also on:    postgresql.org/message-id/20050516044053.GB9292@surnet.cl

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: alvherre@surnet.cl, josh@agliodbs.com, dparker@tazznetworks.com
  Subject: Re: checkpoint segments
  In-Reply-To: <20050516044053.GB9292@surnet.cl>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox