Re: access time performance problem

Поиск
Список
Период
Сортировка
От scott.marlowe
Тема Re: access time performance problem
Дата
Msg-id Pine.LNX.4.33.0210100929590.30553-100000@css120.ihs.com
обсуждение исходный текст
Ответ на Re: access time performance problem  ("Louis-Marie Croisez" <louis-marie.croisez@etca.alcatel.be>)
Список 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 по дате отправления:

Предыдущее
От: Michael Kichanov
Дата:
Сообщение: Re: connection watchdog
Следующее
От: Patrick Welche
Дата:
Сообщение: trivial sql help