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

Re: pgsql: Apply a band-aid fix for the problem that 8.2 and up completely

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Gregory Stark <stark(at)enterprisedb(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: pgsql: Apply a band-aid fix for the problem that 8.2 and up completely
Date: 2007-09-01 00:32:10
Message-ID: 5028.1188606730@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-committerspgsql-hackers
Gregory Stark <stark(at)enterprisedb(dot)com> writes:
> "Tom Lane" <tgl(at)postgresql(dot)org> writes:
>> Log Message:
>> -----------
>> Apply a band-aid fix for the problem that 8.2 and up completely misestimate
>> the number of rows likely to be produced by a query such as
>> SELECT * FROM t1 LEFT JOIN t2 USING (key) WHERE t2.key IS NULL;

> I'm a little wary of backpatching planner logic changes like this and another
> instance in the past.

I probably wouldn't have even made this patch if 8.2's behavior weren't
so completely broken on an important class of query.  For a significant
number of people, this is a bug fix.

In any case, there have been planner changes much larger than this
committed into the 8.2 branch since release --- both the outer join
rearrangement logic and choose_bitmap_and have needed significant
surgery.

			regards, tom lane

In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2007-09-01 00:46:01
Subject: Re: [PATCH] Lazy xid assingment V2
Previous:From: Gregory StarkDate: 2007-09-01 00:23:59
Subject: Re: pgsql: Apply a band-aid fix for the problem that 8.2 and up completely

pgsql-committers by date

Next:From: User H-saitoDate: 2007-09-01 00:53:55
Subject: psqlodbc - psqlodbc: Some changes.
Previous:From: Gregory StarkDate: 2007-09-01 00:23:59
Subject: Re: pgsql: Apply a band-aid fix for the problem that 8.2 and up completely

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