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