Merlin Moncure wrote:
On Thu, Jan 8, 2009 at 3:36 AM, Stefano Nichele <stefano.nichele@xxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
