Re: Tuning 7.2? Different than 7.1.3?

vacuum (not vacuum analyze) is run every night... Just ran vacuum analyze
and it showed some tables with very high "UnUsed", though I don't know what
that means.

Explain shows that it is indeed using the indexes I created...

Is there a way to see which, if any, queries are taking a long time to
execute?

In postgresql.conf:

max_connections = 200
shared_buffers = 400

Any other parameters in there that could affect this?

Thanks,
Hunter

> From: Stephan Szabo 
> Date: Tue, 12 Mar 2002 12:57:15 -0800 (PST)
> To: Hunter Hillegas 
> Cc: PostgreSQL 
> Subject: Re: [GENERAL] Tuning 7.2? Different than 7.1.3?
> 
> 
> On Tue, 12 Mar 2002, Hunter Hillegas wrote:
> 
>> I recently moved from 7.1.3 to 7.2. I am running on a Dual PIII900 Red Hat
>> 7.1 server accessing Postgres exclusively through JDBC (JBoss app server is
>> on the same machine).
>> 
>> Since moving to 7.2, performance on part of my app really sucks. I'm sure it
>> is some setting or index that I'm missing...
>> 
>> [...]
>> 
>>> From this info, can anyone see why performance would really SUCK so bad? It
>> can take up to a minute for this to return...
>> 
>> product has 63 rows, product_line_item has 131 and product_group has 4.
>> 
>> Any help is appreciated.
> 
> Have you run vacuum analyze, and what does explain show for the
> queries? Also, what do you have the settings in postgresql.conf
> (shared_buffers, etc)
> 
>