Rép. : Re: access time performance problem

Just to be sure:

Could it be a checkpoint?
Checkpoint is supposed to flush all data to disks at regular intervals, isn't it?

-------------------------------------------------------------------------------
Erwan DUROSELLE    //    SEAFRANCE DSI
Responsable Bases de Données  //  Databases Manager
Tel: +33 (0)1 55 31 59 70    //    Fax: +33 (0)1 55 31 85 28
email: eduroselle@seafrance.fr
-------------------------------------------------------------------------------


>>> "scott.marlowe" <scott.marlowe@ihs.com> 10/10/2002 17:34 >>>
On Thu, 10 Oct 2002, Louis-Marie Croisez wrote:

> Sorry, bad url:
> use this instead:
> http://louis.croisez.free.fr/capture1.jpg

I'm gonna make a guess here that it's WAL activity, or log activity.

So first off, are you saving postgresql's output to a log?  if so, try
logging to a different drive than your data drive or turning off logging
for a quick test.

If it's WAL writes that are causing the problem, you can either try to
change the settings for commit_delay and commit_siblings or symlinking the
pg_xlog directory somewhere else.  If you aren't sure how to do that,
don't learn how to on a live production server with real data.


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)