Re: doubts - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: doubts
Date
Msg-id 20070108161200.GG14193@alvh.no-ip.org
Whole thread Raw
In response to doubts  ("sangeetha k.s" <sangeethakss@gmail.com>)
List pgsql-general
sangeetha k.s wrote:
> hello,
>
>       postgresql uses bitmap indexing for indexing  in databases.
>       *Is there any technique used*
> *  used to compress the bitmap indices in postgresql*,like oracle that uses
> Byte Aligned bitmap compression to compress bitmaps.

Postgres does not support bitmap indexes yet.  What it does support is
bitmap index *scanning*.  And yes, there is a lossy compression method
that is sometimes used.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-general by date:

Previous
From: "Chad Wagner"
Date:
Subject: Re: Postgres Differential backup
Next
From: Scott Marlowe
Date:
Subject: Re: Discovering time of last database write