huge table / bitmap indexes

From: cure(at)icpnet(dot)pl
To: pgsql-admin(at)postgresql(dot)org
Subject: huge table / bitmap indexes
Date: 2003-06-19 01:24:34
Message-ID: 16562808900.20030619032434@icpnet.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello All

is in postgres any possibility to create bitmap index ? I have big
(~12 000 000 records) table where one field have limited count of
values. Many queries use this field in where section. I thing that
bitmap index will by better than BTree.
How i can optimize select on this table ?

Thanks - Cure

--
The poor player plays the opponent's game for him.
cure mailto:cure(at)icpnet(dot)pl

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tim Middleton 2003-06-19 04:45:51 Re: PostgreSQL calibration
Previous Message Michiel Lange 2003-06-18 23:10:10 Re: notifications:Urgent help needed!!