Postgres Pro
Downloads
Home   >   mailing lists

Re: good pc but bad performance,why? - Mailing list pgsql-performance

From huang yaqin
Subject Re: good pc but bad performance,why?
Date
Msg-id 0HVS00F9Q906F7@mail.gthome.com
Whole thread Raw
In response to good pc but bad performance,why?  (huang yaqin <hyq@gthome.com>)
Responses Re: good pc but bad performance,why?  (Richard Huxton <dev@archonet.com>)
List pgsql-performance
Tree view 
hello！

    Thanks, you are right.
     I use "postmaster -o "-F" " to start my PG，and performance improved greatly.

           Best   regards,
             huang yaqin

>huang yaqin <hyq@gthome.com> 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
　　　　　　　　hyq@gthome.com
　　　　　　　　　　2004-04-07

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: possible improvement between G4 and G5
Next
From: "Heiko Kehlenbrink"
Date:
Subject: Re: performance comparission postgresql/ms-sql server