| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Hunter Hillegas <lists(at)lastonepicked(dot)com> |
| Cc: | PostgreSQL <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Tuning 7.2? Different than 7.1.3? |
| Date: | 2002-03-12 21:14:38 |
| Message-ID: | 20020312131236.M68852-100000@megazone23.bigpanda.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeffrey W. Baker | 2002-03-12 21:25:32 | more about pg_toast growth |
| Previous Message | Hunter Hillegas | 2002-03-12 21:06:56 | Re: Tuning 7.2? Different than 7.1.3? |