Received: from gnumed.dhs.org (modem59.malleenet.net.au [203.143.67.123] (may be forged)) by postgresql.org (8.11.3/8.11.4) with SMTP id fBF65Om69085 for ; Sat, 15 Dec 2001 01:05:24 -0500 (EST) (envelope-from hherb@malleenet.net.au) Received: (qmail 22536 invoked by uid 8); 15 Dec 2001 06:05:20 -0000 Message-ID: <20011215060520.22535.qmail@gnumed.dhs.org> Received: from pc-00071.e-smith.gnumed.dhs.org (192.168.1.71, claiming to be "there") by bifrost.e-smith.gnumed.dhs.org with SMTP id smtpd3Kzaii; Sat, 15 Dec 2001 17:05:10 EST Content-Type: text/plain; charset="iso-8859-1" From: Horst Herb To: pgsql-sql@postgresql.org Subject: Re: queries per second Date: Sat, 15 Dec 2001 17:11:33 +1100 X-Mailer: KMail [version 1.3.2] References: <1094754255.20011215102352@sarkor.com> In-Reply-To: <1094754255.20011215102352@sarkor.com> MIME-Version: 1.0 Content-Transfer-Encoding: 8bit X-Archive-Number: 200112/154 X-Sequence-Number: 5977 On Saturday 15 December 2001 16:23, Timur V. Irmatov wrote: > 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. You will probably get the most accurate answer to your question by simply trying it out yourself on your machine (while verying performance sensitive parameters such as buffer allocation). Will probably take you less time than reading answers on this list. Horst