From: | postgresql(at)fruru(dot)com |
---|---|
To: | "Zhang, Anna" <azhang(at)verisign(dot)com> |
Cc: | "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: seq scan on indexed column |
Date: | 2002-03-14 22:28:35 |
Message-ID: | Pine.LNX.4.44.0203142326180.24047-100000@perycles.unix.be.EU.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Thu, 14 Mar 2002, Zhang, Anna wrote:
> gtld_analysis=# explain SELECT NETBLOCK_START
> gtld_analysis-# FROM GTLD_OWNER
> gtld_analysis-# WHERE NETBLOCK_START = -2147483648;
You might want to try the same query but with the constant integer
enclosed in single quotes. I find that (at least for int8) this changes
the behaviour wrt index usage -- most probably due to automatic
typecasting in the postgresql SQL parser.
Hope this helps...
Tycho
--
Tycho Fruru tycho(dot)fruru(at)conostix(dot)com
Users' impressions of different operating systems, expressed as emoticons:
Linux: :)
Windows: XP
From | Date | Subject | |
---|---|---|---|
Next Message | Mike Schiraldi | 2002-03-14 22:52:20 | Index scans, seq scans |
Previous Message | Gill, Jeffrey L | 2002-03-14 21:28:12 | separating out database files |