pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: huang yaqin <hyq@gthome.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: good pc but bad performance,why?
Date: Wed, 07 Apr 2004 12:00:37 +0800
Message-ID: <0HVS00F9Q906F7@mail.gthome.com> (raw)

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






view thread (23+ messages)  latest in thread

Message-ID: <0HVS00F9Q906F7@mail.gthome.com>
Permalink:  ../0HVS00F9Q906F7@mail.gthome.com/
Also on:    postgresql.org/message-id/0HVS00F9Q906F7@mail.gthome.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: hyq@gthome.com, tgl@sss.pgh.pa.us
  Subject: Re: good pc but bad performance,why?
  In-Reply-To: <0HVS00F9Q906F7@mail.gthome.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox