Horton

Re: good pc but bad performance,why?

huang yaqin <hyq@gthome.com>

View thread
From: huang yaqin <hyq@gthome.com>
To: Richard Huxton <dev@archonet.com>
Cc: "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Date: 2004-04-07T08:56:56Z
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@gthome.com
　　　　　　　　　　2004-04-07