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 89C4DD1B914 for ; Thu, 4 Sep 2003 10:41:02 +0000 (GMT) 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 26209-03 for ; Thu, 4 Sep 2003 07:40:54 -0300 (ADT) Received: from mail.libertyrms.com (unknown [209.167.124.227]) by svr1.postgresql.org (Postfix) with ESMTP id B341DD1B8A3 for ; Thu, 4 Sep 2003 07:40:51 -0300 (ADT) Received: from [10.1.2.130] (helo=dba2) by mail.libertyrms.com with esmtp (Exim 3.22 #3 (Debian)) id 19urXq-0005n3-00 for ; Thu, 04 Sep 2003 06:40:54 -0400 Received: by dba2 (Postfix, from userid 1019) id 89AA8CF15; Thu, 4 Sep 2003 06:40:54 -0400 (EDT) Date: Thu, 4 Sep 2003 06:40:54 -0400 From: Andrew Sullivan To: pgsql-performance@postgresql.org Subject: Re: Query on Postgresql performance Message-ID: <20030904104054.GA1178@libertyrms.info> Mail-Followup-To: Andrew Sullivan , pgsql-performance@postgresql.org References: <001a01c37252$24f69390$8000000a@usc1mk75s5t1b6> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <001a01c37252$24f69390$8000000a@usc1mk75s5t1b6> User-Agent: Mutt/1.5.4i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/57 X-Sequence-Number: 3423 On Wed, Sep 03, 2003 at 12:32:42PM -0700, Naveen Palavalli wrote: > My server spawns a new connection to Postgresql foreach client. My I don't think you want to do that. You should use a pool. Back end startup is mighty expensive. > 1) Effects related to Vaccum :- I performed 10 trials of adding and > deleting entries . In each trial , 1 client adds 10,000 entries > and then deletes them . During the course of these 10 trials , You'll want to vacuum after every set of deletes, I should think. If you're woking in more than one transaction for the deletes, then fairly frequent vacuums of that table will be effective. > I was using Postgresql 7.3.3 earlier but it kept crashing the > database after a Vaccum . So I switched to a older and stabler > version 7.2.4 You don't want to use 7.3.3. It has a rare but serious bug and was replaced in something like 24 hours with 7.3.4. The 7.2 branch is no longer being maintained, so you really probably should use the 7.3 branch. I'm unaware of others having stability problems with 7.3.4, so if you see them, you should find your core dump and talk to the people on -hackers. A -- ---- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada M2P 2A8 +1 416 646 3304 x110