Re: understanding postgres issues/bottlenecks - Mailing list pgsql-performance

From Merlin Moncure
Subject Re: understanding postgres issues/bottlenecks
Date
Msg-id b42b73150901080445s106b6818w8aba7955a319327a@mail.gmail.com
Whole thread Raw
In response to Re: understanding postgres issues/bottlenecks  ("Stefano Nichele" <stefano.nichele@gmail.com>)
Responses Re: understanding postgres issues/bottlenecks
List pgsql-performance
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

pgsql-performance by date:

Previous
From: "Stefano Nichele"
Date:
Subject: Re: understanding postgres issues/bottlenecks
Next
From: Glyn Astill
Date:
Subject: Re: understanding postgres issues/bottlenecks