hello! Thanks, you are right. I use "postmaster -o "-F" " to start my PG,and performance improved greatly.
Best regards, huang yaqin >huang yaqin <[EMAIL PROTECTED]> writes: >> I have some question when I use postgresql 7.4.1 on redhat adv server 2.1 . >> I use IBM335 as server, it has 4 cpus, 1G RAM. but I got very bad performance. >> I can only do about 50 inserts per sencond. Event worse than my pc(PIII 800,256M >> RAM), can anyone give me some advice? > >If the cheap machine appears to be able to commit more transactions >per second than the better one, it's very likely because the cheap >machine has a disk that lies about write completion. Is the server >using SCSI disks by any chance? To a first approximation, IDE drives >lie by default, SCSI drives don't. > > regards, tom lane > > > > >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 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])