pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: dforum <dforums@vieonet.com>
To: Merlin Moncure <mmoncure@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Plz Heeeelp! performance settings
Date: Thu, 07 Aug 2008 09:35:17 +0200
Message-ID: <489AA5B5.9080109@vieonet.com> (raw)
In-Reply-To: <b42b73150808061916j74fd5334y318ef3819fa49ea8@mail.gmail.com>
References: <35FABCF85D99464FB00BC5123DC2A70A051D0FB8@s228130hz1ew09.apptix-01.savvis.net>
	<276541.4189.qm@web25805.mail.ukl.yahoo.com>
	<35FABCF85D99464FB00BC5123DC2A70A051D11E1@s228130hz1ew09.apptix-01.savvis.net>
	<48908988.7020204@emolecules.com>
	<Pine.LNX.4.64.0807301656020.4250@aragorn.flymine.org>
	<1217436578.6288.44.camel@localhost>
	<1240.1217440309@sss.pgh.pa.us>
	<1217441061.6288.47.camel@localhost>
	<489A21C2.8060801@vieonet.com>
	<b42b73150808061916j74fd5334y318ef3819fa49ea8@mail.gmail.com>

Tx for your reply.

You mean that RAID use fsync method for keeping data's copy.

So you invite me to desactivate fsync to increase the performance ?

Desactivating fsync. my second disk will not be uptodate, so if the 
machine crash, I wont be able to get the server working quickly??? But 
if I use a second machine to replicate the database, I escape this 
problem isn't it ?

If I understand right, could you tell me how to do desactivate fsync 
please ?

Best regards

David

Merlin Moncure a écrit :
> On Wed, Aug 6, 2008 at 6:12 PM, dforum <dforums@vieonet.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
>
>   




view thread (10+ messages)  latest in thread

Message-ID: <489AA5B5.9080109@vieonet.com>
Permalink:  ../489AA5B5.9080109@vieonet.com/
Also on:    postgresql.org/message-id/489AA5B5.9080109@vieonet.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: dforums@vieonet.com, mmoncure@gmail.com
  Subject: Re: Plz Heeeelp! performance settings
  In-Reply-To: <489AA5B5.9080109@vieonet.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox