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 E503AD1B8BD for ; Thu, 4 Sep 2003 02:01:38 +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 77654-02 for ; Wed, 3 Sep 2003 23:01:11 -0300 (ADT) Received: from bob.samurai.com (bob.samurai.com [205.207.28.75]) by svr1.postgresql.org (Postfix) with ESMTP id 7B50CD1B8B1 for ; Wed, 3 Sep 2003 23:01:07 -0300 (ADT) Received: from 6-allhosts (d226-85-166.home.cgocable.net [24.226.85.166]) by bob.samurai.com (Postfix) with ESMTP id 8C6171E13; Wed, 3 Sep 2003 22:01:11 -0400 (EDT) Subject: Re: Query on Postgresql performance From: Neil Conway To: Naveen Palavalli Cc: PostgreSQL Performance In-Reply-To: <001a01c37252$24f69390$8000000a@usc1mk75s5t1b6> References: <001a01c37252$24f69390$8000000a@usc1mk75s5t1b6> Content-Type: text/plain Message-Id: <1062640870.14624.13.camel@tokyo> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.4 Date: Wed, 03 Sep 2003 22:01:10 -0400 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/44 X-Sequence-Number: 3410 On Wed, 2003-09-03 at 15:32, Naveen Palavalli wrote: > shared_buffers = 200 If you're using a relatively modern machine, this is probably on the low side. > 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 , the Add > Rates (rate at which my server can add entries to the Postgresql > database ) drops from around 200 Adds/second in the 1st trial to > around 100 Adds/second in the 10th trial . But when I do a Vaccuum , > Immediately I get back the Add Rates to around 200 Adds/Second . Well, there's nothing wrong with vacuuming frequently (since it won't block concurrent database operations, and the more often you vacuum, the less time each vacuum takes). > 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 Can you reproduce the 7.3.3 crash? (BTW, in the future, it would be appreciated if you could report these kinds of bugs to the dev team). -Neil