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   [EMAIL PROTECTED]   http://funkturm.homeip.net/~peter


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply via email to