Re: table as hashtable

From: Richard Huxton <dev(at)archonet(dot)com>
To: fn30762(at)fmi(dot)uni-sofia(dot)bg
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: table as hashtable
Date: 2006-04-13 14:46:28
Message-ID: 443E6444.1060608@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-04-13 14:47:19 Re: corrupted item pointer:???
Previous Message Richard Huxton 2006-04-13 14:44:06 Re: corrupted item pointer:???