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

From PFC
Subject Re: Impact of checkpoint_segments under continual load conditions
Date
Msg-id op.st55bvlgth1vuj@localhost
Whole thread Raw
In response to Re: Impact of checkpoint_segments under continual load conditions  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance

> total.  If the insertion pattern is sufficiently random that the entire
> index ranges are "hot" then you might not have enough RAM.

    Try doing the test dropping some of your indexes and see if it moves the
number of iterations after which it becomes slow.

pgsql-performance by date:

Previous
From: PFC
Date:
Subject: Re: Impact of checkpoint_segments under continual load conditions
Next
From: Christopher Petrilli
Date:
Subject: Re: Impact of checkpoint_segments under continual load conditions