Re: table as hashtable - Mailing list pgsql-general

From Richard Huxton
Subject Re: table as hashtable
Date
Msg-id 443E6444.1060608@archonet.com
Whole thread Raw
In response to table as hashtable  ("Anton Andreev" <Anton.Andreev@fmi.uni-sofia.bg>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: corrupted item pointer:???
Next
From: Tom Lane
Date:
Subject: Re: corrupted item pointer:???