Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group