From: Andreas Kretschmer <akretschmer@spamfence.net>
To: pgsql-sql@postgresql.org
Subject: Re: Multi-column index not used, new flipped column index is
Date: Thu, 11 May 2006 18:13:33 +0200
Message-ID: <20060511161333.GA7577@KanotixBox> (raw)
In-Reply-To: <20060510235424.40005.qmail@web50301.mail.yahoo.com>
References: <20060510183235.GB18485@KanotixBox>
<20060510235424.40005.qmail@web50301.mail.yahoo.com>
ogjunk-pgjedan@yahoo.com <ogjunk-pgjedan@yahoo.com> 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 create
> Bitmap indices, but couldn't find any information. Are the indices
> created the same old CREATE INDEX .... ON Table(column(s)) way and it
> is just PG that can choose to use them in this "Bitmap index-way"?
Yes, you create indexes on the old way.
You have a table with many columns, say, a,b,c,d. On a and b you have a
index.
Now you have select a,b,c,d from table where a=N and b=M;
Prior, PG use one index first and then the other. Now, since 8.1, it
combines both indexes in memory first and need only one bitmap index
scan on the table. If you have many indexes, and suitable selects, you
get a high performance boost.
Read http://www.postgresql.org/docs/8.1/static/release-8-1.html, 2nd
point.
HTH, 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°
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: akretschmer@spamfence.net
Subject: Re: Multi-column index not used, new flipped column index is
In-Reply-To: <20060511161333.GA7577@KanotixBox>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox