From: huang yaqin <hyq@gthome.com>
To: Richard Huxton <dev@archonet.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: good pc but bad performance,why?
Date: Wed, 07 Apr 2004 16:56:56 +0800
Message-ID: <0HVS00G7FMQO35@mail.gthome.com> (raw)
Hello, Richard Huxton,
You said turning fsync off may cause losing data, that's terrible.
I use SCSI disk, and file system is ext3. I tune postgresql.conf and can't get any improvement. So what can I do?
Does SCSI disk and IDE disk have difference?
Regards,
Huang yaqin
======= 2004-04-07 09:33:00 =======
>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
>
>
>
>
>Powered by MessageSoft SMG
>SPAM, virus-free and secure email
>http://www.messagesoft.com
>
>.
= = = = = = = = = = = = = = = = = = = =
致
礼!
huang yaqin
hyq@gthome.com
2004-04-07
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: hyq@gthome.com, dev@archonet.com
Subject: Re: good pc but bad performance,why?
In-Reply-To: <0HVS00G7FMQO35@mail.gthome.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