Re: Confused by 'timing' results

Поиск
Список
Период
Сортировка
От A J
Тема Re: Confused by 'timing' results
Дата
Msg-id 555672.38356.qm@web120013.mail.ne1.yahoo.com
обсуждение исходный текст
Ответ на Re: Confused by 'timing' results  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
PostgreSQL 8.4
CentoOS 5.5
I have got WCE=0, on the drive that mounts the data directory with all its subdirectory (including pg_log)

Maybe I should try to mount pg_log to a different drive and have write cache enabled on that one.



From: Tom Lane <tgl@sss.pgh.pa.us>
To: A J <s5aly@yahoo.com>
Cc: Kevin Grittner <Kevin.Grittner@wicourts.gov>; Scott Marlowe <scott.marlowe@gmail.com>; pgsql-admin@postgresql.org
Sent: Thu, September 2, 2010 3:17:42 PM
Subject: Re: [ADMIN] Confused by 'timing' results

A J <s5aly@yahoo.com> writes:
> Do you think changing log_destination to syslog may make a difference

It's worth trying alternatives anyway.  It is odd that you are seeing
such a slowdown when using the collector --- many people push very high
log volumes through the collector without problems.  What PG version is
this exactly, and on what platform?

            regards, tom lane

В списке pgsql-admin по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Confused by 'timing' results
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Confused by 'timing' results