Re: query slowness caused by table alias

From: Peter Eisentraut <e99re41(at)DoCS(dot)UU(dot)SE>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Chi Fan <chifungfan(at)yahoo(dot)com>, bugs(at)postgresql(dot)org
Subject: Re: query slowness caused by table alias
Date: 2000-05-05 09:41:19
Message-ID: Pine.GSO.4.02A.10005051140150.18780-100000@Gepard.DoCS.UU.SE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Thomas Swan 2000-05-09 07:52:22 Error in pgaccess (parse error at or near """) on create new user with password
Previous Message Roland Roberts 2000-05-05 04:39:18 Re: Need some help: attlen is pg_attributes gives a negative value.. .