Re: SeqScans on boolen values / How to speed this up?

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Jens Hoffrichter <jens(dot)hoffrichter(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: SeqScans on boolen values / How to speed this up?
Date: 2010-07-06 03:19:44
Message-ID: AANLkTil6G8I4qFrBqQOYq9ep1SI_3YKwaxIBrbRpvVsw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, Jul 5, 2010 at 5:36 AM, Jens Hoffrichter
<jens(dot)hoffrichter(at)gmail(dot)com> wrote:
> Hello everyone,
>
> We've recently finished developing a bigger webapplication, and we are
> about to put it online.

If you're checking for bools, and 99.99% of the result is just true or
just false, look at creating partial indexes on the .01% part.

create index .... (boolfield) where boolfield is true

(or is false)

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message damien hostin 2010-07-06 12:48:04 Re: Slow query with planner row strange estimation
Previous Message Craig Ringer 2010-07-06 02:42:36 Re: SeqScans on boolen values / How to speed this up?