Обсуждение: table as hashtable

 Hi,

Can I use a Postgre table as hashtable\\?

when I do select where column='test', I want this to be done by hashtable,
not linear, not by b-tree. I do not need to sort, sum or else I just want
to get the value as fast as possible.

10x to anyone answering me

Cheers,
Anton

Anton Andreev wrote:
>
>  Hi,
>
> Can I use a Postgre table as hashtable\\?

It's PostgreSQL or Postgres, BTW

> when I do select where column='test', I want this to be done by hashtable,
> not linear, not by b-tree. I do not need to sort, sum or else I just want
> to get the value as fast as possible.

There are hash indexes. Read the docs about them though.
http://www.postgresql.org/docs/8.1/static/indexes-types.html

--
   Richard Huxton
   Archonet Ltd