Re: understanding postgres issues/bottlenecks

From: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
To: "Stefano Nichele" <stefano(dot)nichele(at)gmail(dot)com>
Cc: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: understanding postgres issues/bottlenecks
Date: 2009-01-08 20:28:44
Message-ID: b42b73150901081228j92495b2t5d550e8cc85f2b2d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, Jan 8, 2009 at 9:42 AM, Stefano Nichele
<stefano(dot)nichele(at)gmail(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Ron 2009-01-10 12:40:37 Re: understanding postgres issues/bottlenecks
Previous Message Scott Carey 2009-01-08 17:52:23 Re: understanding postgres issues/bottlenecks