Received: from smtp018.mail.yahoo.com (smtp018.mail.yahoo.com [216.136.174.115]) by postgresql.org (8.11.3/8.11.4) with SMTP id fBFNYCm50815 for ; Sat, 15 Dec 2001 18:34:12 -0500 (EST) (envelope-from chrup999@yahoo.com) Received: from chill-025.dfw.tx.bbnow.net (HELO ?192.168.0.6?) (24.219.2.25) by smtp.mail.vip.sc5.yahoo.com with SMTP; 15 Dec 2001 23:34:13 -0000 Mime-Version: 1.0 X-Sender: chrup999@pop.mail.yahoo.com Message-Id: In-Reply-To: <1094754255.20011215102352@sarkor.com> References: <1094754255.20011215102352@sarkor.com> Date: Sat, 15 Dec 2001 17:34:10 -0600 To: "Timur V. Irmatov" From: Chris Ruprecht Subject: Re: queries per second Cc: Postgres SQL Mailing List Content-Type: text/plain; charset="iso-8859-1" ; format="flowed" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by postgresql.org id fBFNat550901 X-Archive-Number: 200112/156 X-Sequence-Number: 5979 Hello Timur, At 10:23 +0500 12/15/2001, Timur V. Irmatov wrote: >Hello, All! > >I'd like to know the approximate number of simple queries (update a >row, select just one row) PostgreSQL is able to perform per second? >(Machine is PII-Celeron 600 with 256 RAM) >These queries will be combined by 2-3 in transactions. This is very dependent on what type of queries you are doing. You can have many queries requesting data which is already in a buffer, so that no disk read access is required or you can have reads, which actually require disk access. If you database is small and you have enough memory, you might have all the data in memory at all times - access would be very fast then, you might get 100+ queries/second. If you need to read a disk, you are dependant an you hardware. I have opted for an UltraSCSI-160 controller with UltraSCSI-160 drives, the fastest option you can get on a PC type platform. I process about 75'000 records every night (they get downloaded from another server). For each record I process, the program makes about 4 - 10 queries to put the new record into the correct 'slot'. The entire process takes about 3 minutes. I'm running this on an 850 MHz AMD Athlon machine with 768 MB of RAM. Hope this gives you a little indication about the speed. Best regards, Chris -- Chris Ruprecht Network grunt and bit pusher extraordinaíre _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com