Re: query not using index - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: query not using index
Date
Msg-id Pine.LNX.4.30.0109031931500.4304-100000@peter.localdomain
Whole thread Raw
In response to query not using index  ("Norbert Zoltan Toth" <Norbert.Zoltan.Toth@cern.ch>)
List 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@gmx.net   http://funkturm.homeip.net/~peter


pgsql-general by date:

Previous
From: Nigel Gilbert
Date:
Subject: European date format option
Next
From: Stephan Szabo
Date:
Subject: Re: query not using index