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