On Thu, Jan 8, 2009 at 9:42 AM, Stefano Nichele
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
>
If it is PowerEdge 1800 with a low end non-write cache controller, then 100
iops per SATA drive isn't too far off from what you should expect.
Contrary to what others are saying, I don't think that turning fsync off is
killing you, you might get 25% more throughput at best.
The iostat output wo
Merlin Moncure wrote:
On Thu, Jan 8, 2009 at 3:36 AM, Stefano Nichele
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
Glyn Astill wrote:
--- On Thu, 8/1/09, Stefano Nichele wrote:
From: Stefano Nichele
Subject: Re: [PERFORM] understanding postgres issues/bottlenecks
To: "Scott Marlowe"
Cc: pgsql-performance@postgresql.org
Date: Thursday, 8 January, 2009, 8:36 AM
Find !
Dell CERC SATA RAID 2 PCI SATA 6ch
--- On Thu, 8/1/09, Stefano Nichele wrote:
> From: Stefano Nichele
> Subject: Re: [PERFORM] understanding postgres issues/bottlenecks
> To: "Scott Marlowe"
> Cc: pgsql-performance@postgresql.org
> Date: Thursday, 8 January, 2009, 8:36 AM
> Find !
>
> Dell CERC SATA RAID 2 PCI SATA 6ch
>
> Ru
On Thu, Jan 8, 2009 at 3:36 AM, Stefano Nichele
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
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)
Flags: bus master, 66MHz, slow devsel, latency 32, IRQ 209
Memory at f800 (32-bit, prefetchab
