Re: Multi-column index not used, new flipped column index is - Mailing list pgsql-sql

From Andreas Kretschmer
Subject Re: Multi-column index not used, new flipped column index is
Date
Msg-id 20060510183235.GB18485@KanotixBox
Whole thread Raw
In response to Re: Multi-column index not used, new flipped column index is  (Markus Schaber <schabi@logix-tt.com>)
List pgsql-sql
Markus Schaber <schabi@logix-tt.com> schrieb:
> Bitmap Index Scans can be your solution, but AFAIK they were invented in
> 8.1.

Right.

> 
> For bitmap index scans, you have one index on fkColumnOne and one on
> fkColumnTwo, and the query planner knows to combine them when both
> columns are given in a WHERE clause.

Yeah! The Bitmap Index Scan is a great thing. With some selects i have a
performance-boost from 5 to 10, compared with 8.0.


Andreas
-- 
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."    (unknow)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°


pgsql-sql by date:

Previous
From:
Date:
Subject: Help with a seq scan on multi-million row table
Next
From: Bruno Wolff III
Date:
Subject: Re: Help with a seq scan on multi-million row table