Re: Insert performance, what should I expect?

Поиск
Список
Период
Сортировка
От Steinar H. Gunderson
Тема Re: Insert performance, what should I expect?
Дата
Msg-id 20041023111530.GA24976@uio.no
обсуждение исходный текст
Ответ на Re: Insert performance, what should I expect?  (Gaetano Mendola <mendola@bigfoot.com>)
Список pgsql-performance
On Sat, Oct 23, 2004 at 12:31:32PM +0200, Gaetano Mendola wrote:
>> Any comments/suggestions would be appreciated.
> Tune also the disk I/O elevator.
>
> look at this: http://www.varlena.com/varlena/GeneralBits/49.php

Mm, interesting. I've heard somewhere that the best for database-like loads
on Linux is to disable the anticipatory I/O scheduler
(http://kerneltrap.org/node/view/567), which should probably
influence the numbers for elvtune also -- anybody know whether this is true
or not for PostgreSQL?

/* Steinar */
--
Homepage: http://www.sesse.net/

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

Предыдущее
От: Gaetano Mendola
Дата:
Сообщение: Re: Insert performance, what should I expect?
Следующее
От: Gaetano Mendola
Дата:
Сообщение: Re: futex results with dbt-3