Re: Question about indexes

From: <lnd(at)hnit(dot)is>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Question about indexes
Date: 2004-01-29 09:17:11
Message-ID: 0A5B2E3C3A64CA4AB14F76DBCA76DDA44EF9B2@seifur.hnit.is
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jan Wieck 2004-01-29 15:31:40 Re: Getting the results columns before execution
Previous Message Claudio Natoli 2004-01-29 09:11:20 Proposed dirmod.c fix for Win32