From: Neil Conway <neilc@samurai.com>
To: Naveen Palavalli <palavall@ISI.EDU>
Cc: PostgreSQL Performance <pgsql-performance@postgresql.org>
Subject: Re: Query on Postgresql performance
Date: Wed, 03 Sep 2003 22:01:10 -0400
Message-ID: <1062640870.14624.13.camel@tokyo> (raw)
In-Reply-To: <001a01c37252$24f69390$8000000a@usc1mk75s5t1b6>
References: <001a01c37252$24f69390$8000000a@usc1mk75s5t1b6>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: neilc@samurai.com, palavall@ISI.EDU
Subject: Re: Query on Postgresql performance
In-Reply-To: <1062640870.14624.13.camel@tokyo>
References: <001a01c37252$24f69390$8000000a@usc1mk75s5t1b6> <1062640870.14624.13.camel@tokyo>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox