Re: performance difference between pgsql and SQL

On Sat, 11 Oct 2003, Bill Shui wrote:

> Hi,
>
> I am using postgreSQL 7.3.4
>
> I have a single table in the databasse.
>
> mytable(id, tag, parent, label)
> all in int8.
>
> hash index is built for id and btree index for all attributes.
>

Hash indexes  are generally a bad idea in 7.3.

> select tag from mytable where id = 1;

Try: select tag from mytable where id = 1::int8;

This is a known flaw of the typing system which the community has been
discussing/attempting to fix for some time.

Gavin