table as hashtable
Started by Anton Andreevalmost 20 years ago2 messagesgeneral
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
Re: table as hashtable
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