Re: Plz Heeeelp! performance settings

From: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
To: dforum <dforums(at)vieonet(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Plz Heeeelp! performance settings
Date: 2008-08-07 02:16:29
Message-ID: b42b73150808061916j74fd5334y318ef3819fa49ea8@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, Aug 6, 2008 at 6:12 PM, dforum <dforums(at)vieonet(dot)com> wrote:
> Hello to all,
>
>
> I have a Linux 2.6.24.2-xxxx-std-ipv4-64 #3 SMP Tue Feb 12 12:27:47 CET 2008
> x86_64 Intel(R) Xeon(R) CPU X5355 @ 2.66GHz GenuineIntel GNU/Linux
> with 8Gb of memory. Using sata II disk in RAID 1 (I known that is bad, but
<snip>

this is likely your problem...with fsync on (as you have it), you will
be lucky to get a couple of hundred transactions/sec out of the
database. you are probably just exceeding your operational
capabilities of the hardware so you probably need to upgrade or turn
off fsync (which means data corruption in event of hard crash).

merlin

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Craig Ringer 2008-08-07 02:47:22 Re: query planner not using the correct index
Previous Message Mark Kirkwood 2008-08-07 00:01:57 Re: file system and raid performance