| From: | tv(at)fuzzy(dot)cz |
|---|---|
| To: | "Henry C(dot)" <henka(at)cityweb(dot)co(dot)za> |
| Cc: | tv(at)fuzzy(dot)cz, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Interpreting EXPLAIN ANALYSE |
| Date: | 2011-06-03 18:32:39 |
| Message-ID: | 3e82c37a83dc6e23bd2930460c779b01.squirrel@sq.gransy.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> On Fri, June 3, 2011 13:57, tv(at)fuzzy(dot)cz wrote:
>> There's something very wrong with snames - the planner expects 22 rows
>> but
>> gets 164147851. Which probably causes a bad plan choice or something
>> like that.
>> Try to analyze the snames table (and maybe increase the statistics
>> target on the columns).
>
> ANALYZE is your friend indeed, like a nice cold beer... from over 500k ms
> to
> 1 ms.
>
> I was running ANALYZE on one of the tables in the join, but not the
> others...
> <sigh>
So you have turned off autovacuum (that should handle this automatically)
or you're running an old version (autovacuum was enabled by default in 8.3
IIRC).
regards
Tomas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | bubba postgres | 2011-06-03 21:15:52 | Why are IDLE connections using cpu according to TOP. |
| Previous Message | Henry C. | 2011-06-03 18:13:53 | Re: Interpreting EXPLAIN ANALYSE |