Re: good pc but bad performance,why? - Mailing list pgsql-performance

From Richard Huxton
Subject Re: good pc but bad performance,why?
Date
Msg-id 200404070933.12544.dev@archonet.com
Whole thread Raw
In response to Re: good pc but bad performance,why?  (huang yaqin <hyq@gthome.com>)
List pgsql-performance
On Wednesday 07 April 2004 05:00, huang yaqin wrote:
> hello!
>
>     Thanks, you are right.
>      I use "postmaster -o "-F" " to start my PG,and performance improved
> greatly.

I don't think Tom was recommending turning fsync off. If you have a system
crash/power glitch then the database can become corrupted.

If you are happy the possibility if losing your data, write performance will
improve noticably.

--
  Richard Huxton
  Archonet Ltd

pgsql-performance by date:

Previous
From: Grega Bremec
Date:
Subject: Re: [ADMIN] Raw devices vs. Filesystems
Next
From: Richard Huxton
Date:
Subject: Re: plan problem