| From: | tv(at)fuzzy(dot)cz |
|---|---|
| To: | "Davenport, Julie" <JDavenport(at)ctcd(dot)edu> |
| Cc: | "Merlin Moncure" <mmoncure(at)gmail(dot)com>, "Tomas Vondra" <tv(at)fuzzy(dot)cz>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: query taking much longer since Postgres 8.4 upgrade |
| Date: | 2011-03-21 16:32:40 |
| Message-ID: | 65169dfe4c8914b7fdf5cdef8c876067.squirrel@sq.gransy.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> Incredible! Setting enable_nestloop off temporarily for the run of this
> script made it run in less than a minute (had been running in 10 or 11
> minutes). I think you have found a solution for many of my slow running
> scripts that use these same type of joins. Thanks again.
> Julie
Nice. Can you post EXPLAIN ANALYZE again, so that we can see why this plan
was evaluated as as more expensive before disabling nested loops?
regards
Tomas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2011-03-21 16:49:39 | Re: query taking much longer since Postgres 8.4 upgrade |
| Previous Message | Vick Khera | 2011-03-21 16:30:44 | Re: Fw: slony- No index found |