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

From Merlin Moncure
Subject Re: understanding postgres issues/bottlenecks
Date
Msg-id b42b73150901081228j92495b2t5d550e8cc85f2b2d@mail.gmail.com
Whole thread Raw
In response to Re: understanding postgres issues/bottlenecks  (Stefano Nichele <stefano.nichele@gmail.com>)
List pgsql-performance
On Thu, Jan 8, 2009 at 9:42 AM, Stefano Nichele
<stefano.nichele@gmail.com> 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

pgsql-performance by date:

Previous
From: Scott Carey
Date:
Subject: Re: understanding postgres issues/bottlenecks
Next
From: Ron
Date:
Subject: Re: understanding postgres issues/bottlenecks