Postgres Pro
Downloads
Home   >   mailing lists

Re: Using bitmap index scans-more efficient - Mailing list pgsql-sql

From Florian Weimer
Subject Re: Using bitmap index scans-more efficient
Date
Msg-id 82mza77rch.fsf@mid.bfk.de
Whole thread Raw
In response to Using bitmap index scans-more efficient  (Kyle Bateman <kyle@actarg.com>)
Responses Re: Using bitmap index scans-more efficient
List pgsql-sql
Tree view 
* Kyle Bateman:

> Any ideas about whether/how this can be done?

If the project tree is fairly consistent, it's convenient to encode it
using intervals instead of parent/child intervals.  IIRC, Celko's "SQL
for smarties" explains how to do this, and Kristian Koehntopp has
written some PHP code to implement it.

-- 
Florian Weimer                <fweimer@bfk.de>
BFK edv-consulting GmbH       http://www.bfk.de/
Durlacher Allee 47            tel: +49-721-96201-1
D-76131 Karlsruhe             fax: +49-721-96201-99

pgsql-sql by date:

Previous
From: Kyle Bateman
Date:
Subject: Using bitmap index scans-more efficient
Next
From: Emi Lu
Date:
Subject: SQLMAP IBATIS insert values from web forms to a money type column