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

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 (view raw or whole thread)
Lists: pgsql-bugs
On Thu, 4 May 2000, Tom Lane wrote:

> > 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            Sweden

In response to

pgsql-bugs by date

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

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