| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Norbert Zoltan Toth <Norbert(dot)Zoltan(dot)Toth(at)cern(dot)ch> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: query not using index |
| Date: | 2001-09-03 17:33:01 |
| Message-ID: | Pine.LNX.4.30.0109031931500.4304-100000@peter.localdomain |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Norbert Zoltan Toth writes:
> I have created the following test table:
> create table history (event_id int8 not null, event_type int, event_name
> char(10), event_ts timestamp, user_data_ref int8);
> When I issue the following query, it takes about 6 minutes:
> select event_id from history where event_id = 1;
This is a bit of a PostgreSQL bug. See
http://www.de.postgresql.org/devel-corner/docs/postgres/datatype.html#DATATYPE-INT
Read the "Note:".
--
Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Bergmann | 2001-09-03 17:37:30 | SHOW |
| Previous Message | Stephan Szabo | 2001-09-03 17:31:17 | Re: Adding a Foreign Key |