Re: understanding postgres issues/bottlenecks

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: understanding postgres issues/bottlenecks
Дата
Msg-id b42b73150901081228j92495b2t5d550e8cc85f2b2d@mail.gmail.com
обсуждение исходный текст
Ответ на Re: understanding postgres issues/bottlenecks  (Stefano Nichele <stefano.nichele@gmail.com>)
Список pgsql-performance
On Thu, Jan 8, 2009 at 9:42 AM, Stefano Nichele
<stefano.nichele@gmail.com> wrote:
> Merlin Moncure wrote:
>> IIRC that's the 'perc 6ir' card...no write caching.  You are getting
>> killed with syncs. If you can restart the database, you can test with
>> fsync=off comparing load to confirm this.  (another way is to compare
>> select only vs regular transactions on pgbench).
>
> I'll try next Saturday.
>

just be aware of the danger .  hard reset (power off) class of failure
when fsync = off means you are loading from backups.

merlin

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

Предыдущее
От: Scott Carey
Дата:
Сообщение: Re: understanding postgres issues/bottlenecks
Следующее
От: Ron
Дата:
Сообщение: Re: understanding postgres issues/bottlenecks