From: | Dustin Sallings <dustin(at)spy(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | strange query plans, won't use index |
Date: | 1998-11-11 17:35:38 |
Message-ID: | Pine.SGI.3.95.981111093506.16940A-100000@bleu.west.spy.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Does anybody know where there is a difference here:
photo=> explain select cat from wwwacl where userid=getwwwuser('dustin');
NOTICE: QUERY PLAN:
Seq Scan on wwwacl (cost=2.65 size=5 width=4)
EXPLAIN
photo=> explain select cat from wwwacl where userid=6;
NOTICE: QUERY PLAN:
Index Scan using acl_byid on wwwacl (cost=2.24 size=5 width=4)
EXPLAIN
getwwwuser('dustin') returns 6 here.
--
SA, beyond.com My girlfriend asked me which one I like better.
pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin(at)spy(dot)net>
| Key fingerprint = 87 02 57 08 02 D0 DA D6 C8 0F 3E 65 51 98 D8 BE
L_______________________ I hope the answer won't upset her. ____________
From | Date | Subject | |
---|---|---|---|
Next Message | Ulf Mehlig | 1998-11-12 07:05:19 | fmgr.h not found |
Previous Message | Gene Selkov Jr. | 1998-11-11 16:56:16 | Re: [INTERFACES] need information about storing methods |