Postgresql Tuning - Mailing list pgsql-admin

From Juan Alvarez Ferrando
Subject Postgresql Tuning
Date
Msg-id 01be3c0f$7dce4a40$1e64a8c0@SG10.suzuki.es
Whole thread Raw
List pgsql-admin
Hi,
 
I've got a PostgreSql database that serves a java aplication for about 15 concurrent
users that conect over modem. Mi PSQL version is 6.3.2. and I have it installed with default parameters.
 
Is there anithing I could/should parametrize to enhace performance?
 
Also:
 
Some of the conenctions to the database, specially when there's a high load of
them, stay opened as postgres processes indefinitively, as seem to block others,
even thoug every operation is doen inside a createConecction - conecction.close
block.
 
Is there any way to block by record instead of by table?, this would avoid my users
from being blocked while some other user is performing an intensive operation.
 
Thanks in advance.
 
 
Juan Alvarez Ferrando

pgsql-admin by date:

Previous
From: Gregg Berkholtz
Date:
Subject: Re: [ADMIN] Data dir
Next
From: Jan Kim
Date:
Subject: Still no luck on Digital OSF/1 4.0