Re: query slowness caused by table alias - Mailing list pgsql-bugs

From Peter Eisentraut
Subject Re: query slowness caused by table alias
Date
Msg-id Pine.GSO.4.02A.10005051140150.18780-100000@Gepard.DoCS.UU.SE
Whole thread Raw
In response to Re: query slowness caused by table alias  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
On Thu, 4 May 2000, Tom Lane wrote:

> > EXPLAIN
> > SELECT *
> > FROM part p              -- let p alias to part
> > WHERE part.part_id = 42; -- but don't use p
>
> > Nested Loop  (cost=0.00..2429.30 rows=50735 width=219)
> >   -> Index Scan using part_pkey on part (cost=0.00..3.60 rows=1 width=4)
> >   -> Seq Scan on part p  (cost=0.00..1918.35 rows=50735 width=215)
>
> This is correct behavior.

Isn't it time we disable this by default or at least provide an option for
it? It seems this comes up every week.

--
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden

pgsql-bugs by date:

Previous
From: Roland Roberts
Date:
Subject: Re: Need some help: attlen is pg_attributes gives a negative value.. .
Next
From: Thomas Swan
Date:
Subject: Error in pgaccess (parse error at or near """) on create new user with password