| From: | tv(at)fuzzy(dot)cz |
|---|---|
| To: | "Davenport, Julie" <JDavenport(at)ctcd(dot)edu> |
| Cc: | "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-16 16:48:43 |
| Message-ID: | b433c09f2838fb84cc58e059e1a48abc.squirrel@sq.gransy.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> When I run the following query in Postgres 8.0, it runs in 61,509.372 ms
>
> When I run it in Postgres 8.4, it runs in 397,857.472 ms
As Andrew already pointed out, we need to se EXPLAIN ANALYZE output from
both machines to see why this happens. Are you running both queries on the
same data, or is there much more data in 8.4? Have you analyzed the tables
recently (or is autovacuum running)?
BTW I see two possible issues with this query:
1) There's not a suitable index on course_begin_date, i.e. there's no
index at all or the index is not on the expression used in the query.
2) There's not a suitable index on course_delivery (it needs to use the
proper operator class).
regards
Tomas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vlad Romascanu | 2011-03-16 17:00:18 | Re: converting E'C:\\something' to bytea |
| Previous Message | Andrew Sullivan | 2011-03-16 16:34:41 | Re: query taking much longer since Postgres 8.4 upgrade |