Re: Queries 15 times slower on 8.1 beta 2 than on 8.0 - Mailing list pgsql-performance

From Tom Lane
Subject Re: Queries 15 times slower on 8.1 beta 2 than on 8.0
Date
Msg-id 16903.1127430734@sss.pgh.pa.us
Whole thread Raw
In response to Re: Queries 15 times slower on 8.1 beta 2 than on 8.0  (Michael Fuhr <mike@fuhr.org>)
List pgsql-performance
Michael Fuhr <mike@fuhr.org> writes:
> I've created a simplified, self-contained test case for this:

I see the problem --- I broke best_inner_indexscan() for some cases
where the potential indexscan clause is an outer-join ON clause.

            regards, tom lane

pgsql-performance by date:

Previous
From: "Jean-Pierre Pelletier"
Date:
Subject: Re: Queries 15 times slower on 8.1 beta 2 than on 8.0
Next
From: Josh Berkus
Date:
Subject: Re: Queries 15 times slower on 8.1 beta 2 than on 8.0