Re: Tuning 7.2? Different than 7.1.3?

On Tue, 12 Mar 2002, Hunter Hillegas wrote:

> 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?

Try explain analyze

> In postgresql.conf:
>
> max_connections = 200
> shared_buffers = 400

That shared_buffer setting is pretty low for that number of connections.

> Any other parameters in there that could affect this?

I doubt sort_mem is likely to come up, but if there are sort steps in
the query, possibly.