Re: Help tuning postgres

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: Help tuning postgres
Дата
Msg-id 6EE64EF3AB31D5448D0007DD34EEB3417DD595@Herge.rcsinc.local
обсуждение исходный текст
Ответ на Help tuning postgres  (Csaba Nagy <nagy@ecircle-ag.com>)
Список pgsql-performance
> The disk used for the data is an external raid array, I don't know
much
> about that right now except I think is some relatively fast IDE stuff.
> In any case the operations should be cache friendly, we don't scan
over
> and over the big tables...

Maybe you are I/O bound.  Do you know if your RAID array is caching your
writes?  Easy way to check is to run fsync off and look for obvious
performance differences.  Maybe playing with sync method could help
here.

Merlin


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

Предыдущее
От: Emil Briggs
Дата:
Сообщение: Re: Help tuning postgres
Следующее
От: Matthew Nuzum
Дата:
Сообщение: Re: Help tuning postgres