From: Luke Lonergan <llonergan@greenplum.com>
To: Oscar Picasso <oscgoogle@yahoo.com>
To: pgsql-performance@postgresql.org
Subject: Re: Better index stategy for many fields with few
Date: Wed, 12 Apr 2006 15:38:14 -0700
Message-ID: <C062CF66.216D1%llonergan@greenplum.com> (raw)
In-Reply-To: <20060410165857.91471.qmail@web54705.mail.yahoo.com>
Oscar,
On 4/10/06 9:58 AM, "Oscar Picasso" <oscgoogle@yahoo.com> wrote:
> - My items table:
> code int -- can take one of 100 values
> property varchar(250) -- can take one of 5000 values
> param01 char(10) -- can take one of 10 values
> param02 char(10) -- can take one of 10 values
> ...
> [ 20 similar columns }
> ...
> parama20 char(10) -- can take one of 10 values
>
> - The kind of query I want to optimize:
> select * from items
> where code betwwen 5 and 22
> and param01 = 'P'
> and param02 = 'G'
> ...
> [ all the 20 paramXX columns are used in the query}
> ...
> and param20 = 'C';
Bizgres 0.9 has an on-disk bitmap index which will likely improve this query
speed by a very large amount over normal Postgres 8.1.
- Luke
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-performance@postgresql.org
Cc: llonergan@greenplum.com, oscgoogle@yahoo.com
Subject: Re: Better index stategy for many fields with few
In-Reply-To: <C062CF66.216D1%llonergan@greenplum.com>
* 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