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 <sszabo(at)megazone23(dot)bigpanda(dot)com>
> Date: Tue, 12 Mar 2002 12:57:15 -0800 (PST)
> To: Hunter Hillegas <lists(at)lastonepicked(dot)com>
> Cc: PostgreSQL <pgsql-general(at)postgresql(dot)org>
> 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)
>
>