| From: | huang yaqin <hyq(at)gthome(dot)com> |
|---|---|
| To: | Richard Huxton <dev(at)archonet(dot)com> |
| Cc: | "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: good pc but bad performance,why? |
| Date: | 2004-04-07 08:56:56 |
| Message-ID: | 0HVS00G7FMQO35@mail.gthome.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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(at)gthome(dot)com
2004-04-07
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ken Geis | 2004-04-07 09:03:27 | Re: plan problem |
| Previous Message | Richard Huxton | 2004-04-07 08:38:11 | Re: plan problem |