Re: Question about indexes - Mailing list pgsql-hackers

From
Subject Re: Question about indexes
Date
Msg-id 0A5B2E3C3A64CA4AB14F76DBCA76DDA44EF9B2@seifur.hnit.is
Whole thread Raw
In response to Question about indexes  (Greg Stark <gsstark@mit.edu>)
Responses Re: Question about indexes  (Greg Stark <gsstark@mit.edu>)
List pgsql-hackers
A small comment on Oracle's implementation of persistent bitmap indexes:

Oracle's bitmap index is concurently locked by DML, i.e. it suites for OLAP
(basically read only data warehouses) but in no way for OLTP.

IMHO,
Laimis

> Maybe the lack of heap/btree consistent ordering in Oracle
> and their subsequent design choice of persistent bitmap
> indices is an indication for PostgreSQL too?



pgsql-hackers by date:

Previous
From: Claudio Natoli
Date:
Subject: Proposed dirmod.c fix for Win32
Next
From: Christoph Haller
Date:
Subject: Re: Disaster!