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 A0987D1B8AA for ; Tue, 26 Aug 2003 14:12:12 -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 69731-02 for ; Tue, 26 Aug 2003 14:11:42 -0300 (ADT) Received: from lakemtao02.cox.net (lakemtao02.cox.net [68.1.17.243]) by svr1.postgresql.org (Postfix) with ESMTP id 38AE8D1B8A9 for ; Tue, 26 Aug 2003 14:11:41 -0300 (ADT) Received: from lhosts ([68.11.66.83]) by lakemtao02.cox.net (InterMail vM.5.01.06.04 201-253-122-130-104-20030726) with ESMTP id <20030826171135.ZOSL11854.lakemtao02.cox.net@lhosts> for ; Tue, 26 Aug 2003 13:11:35 -0400 Subject: Re: [PERFORM] Best tweak for fast results.. ? From: Ron Johnson To: PgSQL General ML In-Reply-To: <200308262142.52521.jerome@gmanmi.tv> References: <200308262142.52521.jerome@gmanmi.tv> Content-Type: text/plain Message-Id: <1061917901.18108.109.camel@haggis> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.4 Date: Tue, 26 Aug 2003 12:11:41 -0500 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/1385 X-Sequence-Number: 47801 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. -- ----------------------------------------------------------------- Ron Johnson, Jr. ron.l.johnson@cox.net Jefferson, LA USA "Oh, great altar of passive entertainment, bestow upon me thy discordant images at such speed as to render linear thought impossible" Calvin, regarding TV