On Thu, Jan 8, 2009 at 9:42 AM, Stefano Nichele <stefano.nichele@xxxxxxxxx> 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 >> select only vs regular transactions on pgbench). > > I'll try next Saturday. > just be aware of the danger . hard reset (power off) class of failure when fsync = off means you are loading from backups. merlin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
