X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 7D571D1B4F0 for ; Tue, 26 Aug 2003 10:22:18 -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 07346-06 for ; Tue, 26 Aug 2003 10:21:50 -0300 (ADT) Received: from gatekeeper.gmanetwork.com (unknown [202.61.78.68]) by svr1.postgresql.org (Postfix) with ESMTP id 0A681D1D153 for ; Tue, 26 Aug 2003 10:21:43 -0300 (ADT) Received: from gmanewmedia.com (mailhost.gmanmi.tv [192.168.6.3]) by gatekeeper.gmanetwork.com (8.11.0/8.11.0) with ESMTP id h7QDLei10926 for ; Tue, 26 Aug 2003 21:21:40 +0800 Received: from 192.168.6.40 ([192.168.6.40]) by gmanewmedia.com (8.11.1/) with ESMTP id h7QD2qo49233 for ; Tue, 26 Aug 2003 21:03:00 +0800 (PHT) (envelope-from jerome@gmanmi.tv) X-RAV-AntiVirus: This e-mail has been scanned for viruses on host: gmanewmedia.com From: JM Reply-To: jerome@gmanmi.tv Organization: GMANMI To: PgSQL Performance ML Subject: Best tweak for fast results.. ? Date: Tue, 26 Aug 2003 21:42:52 +0800 User-Agent: KMail/1.5 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200308262142.52521.jerome@gmanmi.tv> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/335 X-Sequence-Number: 3151 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.. TIA