Re: Impact of checkpoint_segments under continual load conditions

From: PFC <lists(at)boutiquenumerique(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Christopher Petrilli" <petrilli(at)gmail(dot)com>
Cc: "Vivek Khera" <vivek(at)khera(dot)org>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Impact of checkpoint_segments under continual load conditions
Date: 2005-07-19 16:27:21
Message-ID: op.st55bvlgth1vuj@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Christopher Petrilli 2005-07-19 16:30:34 Re: Impact of checkpoint_segments under continual load conditions
Previous Message PFC 2005-07-19 16:25:48 Re: Impact of checkpoint_segments under continual load conditions