Re: access time performance problem - Mailing list pgsql-general

From scott.marlowe
Subject Re: access time performance problem
Date
Msg-id Pine.LNX.4.33.0210100929590.30553-100000@css120.ihs.com
Whole thread Raw
In response to Re: access time performance problem  ("Louis-Marie Croisez" <louis-marie.croisez@etca.alcatel.be>)
List pgsql-general
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.


pgsql-general by date:

Previous
From: Michael Kichanov
Date:
Subject: Re: connection watchdog
Next
From: Patrick Welche
Date:
Subject: trivial sql help