Skip site navigation (1) Skip section navigation (2)

Impact of checkpoint_segments under continual load conditions

From: Christopher Petrilli <petrilli(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Impact of checkpoint_segments under continual load conditions
Date: 2005-07-17 17:08:34
Message-ID: 59d991c4050717100874c08a86@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
I have a unique scenerio.  My DB is under "continual load", meaning
that I am constantly using COPY to insert new data into the DB.  There
is no "quiet period" for the database, at least not for hours on end. 
Normally, checkpoint_segments can help absorb some of that, but my
experience is that if I crank the number up, it simply delays the
impact, and when it occurs, it takes a VERY long time (minutes) to
clear.

Thoughts?
Chris
-- 
| Christopher Petrilli
| petrilli(at)gmail(dot)com

Responses

pgsql-performance by date

Next:From: Tom LaneDate: 2005-07-17 18:15:54
Subject: Re: Impact of checkpoint_segments under continual load conditions
Previous:From: Tom LaneDate: 2005-07-17 04:44:53
Subject: Re: Questions about temporary tables and performance

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group