X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 9AF47D1B8A4 for ; Tue, 26 Aug 2003 14:20:21 -0300 (ADT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 70215-06 for ; Tue, 26 Aug 2003 14:19:50 -0300 (ADT) Received: from snoopy.oit.edu (snoopy.OIT.EDU [140.211.135.12]) by svr1.postgresql.org (Postfix) with ESMTP id 3B0E5D1B8AD for ; Tue, 26 Aug 2003 14:19:49 -0300 (ADT) Received: from fireserve.net (purvine-141-62.oit.edu [140.211.141.62]) by snoopy.oit.edu (8.12.9/8.12.9/OIT-4.0) with ESMTP id h7QHJmWD018332; Tue, 26 Aug 2003 10:19:48 -0700 Message-ID: <3F4B9808.1080804@fireserve.net> Date: Tue, 26 Aug 2003 10:25:28 -0700 From: Dennis Gearon User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4) Gecko/20030624 X-Accept-Language: en-us, ru, es-mx MIME-Version: 1.0 To: Ron Johnson Cc: PgSQL General ML Subject: Re: [PERFORM] Best tweak for fast results.. ? References: <200308262142.52521.jerome@gmanmi.tv> <1061917901.18108.109.camel@haggis> In-Reply-To: <1061917901.18108.109.camel@haggis> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/1387 X-Sequence-Number: 47803 actually, isin't 1000 tps pretty good? Ron Johnson wrote: >On Tue, 2003-08-26 at 08:42, JM wrote: > > >>need input on parameter values on confs... >> >>our database is getting 1000 transactions/sec on peak periods.. >> >>sitting on RH 7.3 >>2.4.7-10smp >>RAM: 1028400 >>SWAP: 2040244 >> >>queries are just simple select statements based on timestamps, varchars... >>less on joins... on a 300K rows.. >> >> > >Could it be that 1000tps is as good as your h/w can do? You didn't >mention what kind and speed of CPU(s), SCSI-or-IDE controller(s) and >type/speed of disk(s) you have. > > >