From: Andrew Sullivan <andrew@libertyrms.info>
To: pgsql-performance@postgresql.org
Subject: Re: Query on Postgresql performance
Date: Thu, 4 Sep 2003 06:40:54 -0400
Message-ID: <20030904104054.GA1178@libertyrms.info> (raw)
In-Reply-To: <001a01c37252$24f69390$8000000a@usc1mk75s5t1b6>
References: <001a01c37252$24f69390$8000000a@usc1mk75s5t1b6>
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
<andrew@libertyrms.info> M2P 2A8
+1 416 646 3304 x110
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: andrew@libertyrms.info
Subject: Re: Query on Postgresql performance
In-Reply-To: <20030904104054.GA1178@libertyrms.info>
References: <001a01c37252$24f69390$8000000a@usc1mk75s5t1b6> <20030904104054.GA1178@libertyrms.info>
* 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