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 [EMAIL PROTECTED] 2004-04-07 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org