table as hashtable

Started by Anton Andreevalmost 20 years ago2 messagesgeneral
Jump to latest
#1Anton Andreev
anton.andreev@fmi.uni-sofia.bg

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

#2Richard Huxton
dev@archonet.com
In reply to: Anton Andreev (#1)
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