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 addin
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
Hi ,
I am currently using Postgresql for a Research
project . I observed some performance results of Postgresql which I would like
to discuss .
I have a server which accepts requests from
clients. It spawns a new thread for each client. The clients are trying to add
entries to a relatio
