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. ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly