Re: Poor performance on SCSI machines, good on IDE?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Poor performance on SCSI machines, good on IDE?
Дата
Msg-id 26240.1005926776@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Poor performance on SCSI machines, good on IDE?  (Eric Crampton <eric@atdesk.com>)
Список pgsql-general
Eric Crampton <eric@atdesk.com> writes:
> Incidently, if I turn fsync off on the SCSI machines, the performance
> absolutely soars. Of course, I don't really want to do this in
> production.

Have you tried experimenting with the WAL_SYNC_METHOD parameter?
On some kernels that can make a big difference.  Not sure why
the apparent correlation to disk drive type, though.

            regards, tom lane

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

Предыдущее
От: wsheldah@lexmark.com
Дата:
Сообщение: Re: Idle in transaction ????
Следующее
От: Gabriel Fernandez
Дата:
Сообщение: Re: Precision problems with float8