Postgresql Tuning

From: "Juan Alvarez Ferrando" <juan(at)suzuki(dot)es>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Postgresql Tuning
Date: 1999-01-09 20:34:44
Message-ID: 01be3c0f$7dce4a40$1e64a8c0@SG10.suzuki.es
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-admin by date

  From Date Subject
Next Message Gregg Berkholtz 1999-01-09 21:20:29 Re: [ADMIN] Re: Help with PostgreSQL startup
Previous Message Shane Wilson 1999-01-09 03:59:50 MSaccess97 instert & memo