Re: Queries 15 times slower on 8.1 beta 2 than on 8.0

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-performance(at)postgresql(dot)org, Jean-Pierre Pelletier <pelletier_32(at)sympatico(dot)ca>, John Arbash Meinel <john(at)arbash-meinel(dot)com>
Subject: Re: Queries 15 times slower on 8.1 beta 2 than on 8.0
Date: 2005-09-22 23:12:14
Message-ID: 16903.1127430734@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Michael Fuhr <mike(at)fuhr(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Josh Berkus 2005-09-22 23:16:25 Re: Queries 15 times slower on 8.1 beta 2 than on 8.0
Previous Message Jean-Pierre Pelletier 2005-09-22 23:10:25 Re: Queries 15 times slower on 8.1 beta 2 than on 8.0