Re: understanding postgres issues/bottlenecks

From: Stefano Nichele <stefano(dot)nichele(at)gmail(dot)com>
To: Merlin Moncure <mmoncure(at)gmail(dot)com>
Cc: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: understanding postgres issues/bottlenecks
Date: 2009-01-08 14:42:20
Message-ID: 496610CC.6040008@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Merlin Moncure wrote:
> On Thu, Jan 8, 2009 at 3:36 AM, Stefano Nichele
> <stefano(dot)nichele(at)gmail(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Carey 2009-01-08 17:52:23 Re: understanding postgres issues/bottlenecks
Previous Message Stefano Nichele 2009-01-08 14:41:21 Re: understanding postgres issues/bottlenecks