Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0 - Mailing list pgsql-performance

From Tom Lane
Subject Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0
Date
Msg-id 11679.1133454886@sss.pgh.pa.us
Whole thread Raw
In response to Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0  ("Markus Wollny" <Markus.Wollny@computec.de>)
List pgsql-performance
"Markus Wollny" <Markus.Wollny@computec.de> writes:
>> Once you're not under deadline,
>> I'd like to investigate more closely to find out why 8.1 does
>> worse than 8.0 here.

> Please tell me what I can do to help in clearing up this issue, I'd be
> very happy to help!

The first thing to do is get 8.0's EXPLAIN ANALYZE for the same query.
After we see how that differs from 8.1, we'll know what the next
question should be ...

            regards, tom lane

pgsql-performance by date:

Previous
From: Guido Neitzer
Date:
Subject: Re: 15,000 tables
Next
From: Michael Riess
Date:
Subject: Re: 15,000 tables