Re: understanding postgres issues/bottlenecks

Поиск
Список
Период
Сортировка
От Stefano Nichele
Тема Re: understanding postgres issues/bottlenecks
Дата
Msg-id 496610CC.6040008@gmail.com
обсуждение исходный текст
Ответ на Re: understanding postgres issues/bottlenecks  ("Merlin Moncure" <mmoncure@gmail.com>)
Ответы Re: understanding postgres issues/bottlenecks
Список pgsql-performance
Merlin Moncure wrote:
> On Thu, Jan 8, 2009 at 3:36 AM, Stefano Nichele
> <stefano.nichele@gmail.com> wrote:
>
>> Find !
>>
>> Dell CERC SATA RAID 2 PCI SATA 6ch
>>
>> Running lspci -v:
>>
>> 03:09.0 RAID bus controller: Adaptec AAC-RAID (rev 01)
>>         Subsystem: Dell CERC SATA RAID 2 PCI SATA 6ch (DellCorsair)
>>
>
> 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).
>
> merlin
>
>

I'll try next Saturday.

thanks
ste

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

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