[EMAIL PROTECTED] <[EMAIL PROTECTED]> schrieb:
> Hi Andreas and Markus,
>
> Bitmap indices sound like a good reason to go from 8.0 to 8.1. Is 8.2
> around the corner, by any chance?
IIRC in autumn/winter. If it is finish ;-)
>
> I searched PG docs to see if I need to do something special to c
Markus Schaber <[EMAIL PROTECTED]> 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 i
Hi, Otis,
[EMAIL PROTECTED] wrote:
> I'm using PG 8.0.3 and recently spotted a query that was not using a
> multi-column index I had created. The index looks like:
>
> CREATE INDEX . ON FooTable(fkColumnOne, fkColumnTwo);
>
> The query that was not using the index was using:
>
> SELECT ...
Hi,
I'm using PG 8.0.3 and recently spotted a query that was not using a
multi-column index I had created.
The index looks like:
CREATE INDEX . ON FooTable(fkColumnOne, fkColumnTwo);
The query that was not using the index was using:
SELECT a bunch of columns and joins WHERE F
