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
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.
now, I have over 9 million tuples in the table.
The problem is when I access the database through
psql interface
