Re: Impact of checkpoint_segments under continual load conditions - Mailing list pgsql-performance

From Christopher Petrilli
Subject Re: Impact of checkpoint_segments under continual load conditions
Date
Msg-id 59d991c405072009163b149809@mail.gmail.com
Whole thread Raw
In response to Re: Impact of checkpoint_segments under continual load conditions  (Christopher Petrilli <petrilli@gmail.com>)
List pgsql-performance
On 7/19/05, Christopher Petrilli <petrilli@gmail.com> wrote:
> It looks like the CVS HEAD is definately "better," but not by a huge
> amount.  The only difference is I wasn't run autovacuum in the
> background (default settings), but I don't think this explains it.
> Here's a graph of the differences and density of behavior:
>
> http://blog.amber.org/diagrams/pgsql_copy_803_cvs.png
>
> I can provide the raw data.  Each COPY was 500 rows.  Note that fsync
> is turned off here.  Maybe it'd be more stable with it turned on?

I've updated this with trend-lines.

Chris

--
| Christopher Petrilli
| petrilli@gmail.com

pgsql-performance by date:

Previous
From: Christopher Petrilli
Date:
Subject: Re: Impact of checkpoint_segments under continual load conditions
Next
From: Richard Huxton
Date:
Subject: Re: Optimizer seems to be way off, why?