Re: SeqScans on boolen values / How to speed this up? - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: SeqScans on boolen values / How to speed this up?
Date
Msg-id AANLkTil6G8I4qFrBqQOYq9ep1SI_3YKwaxIBrbRpvVsw@mail.gmail.com
Whole thread Raw
In response to SeqScans on boolen values / How to speed this up?  (Jens Hoffrichter <jens.hoffrichter@gmail.com>)
List pgsql-performance
On Mon, Jul 5, 2010 at 5:36 AM, Jens Hoffrichter
<jens.hoffrichter@gmail.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)

pgsql-performance by date:

Previous
From: Craig Ringer
Date:
Subject: Re: SeqScans on boolen values / How to speed this up?
Next
From: damien hostin
Date:
Subject: Re: Slow query with planner row strange estimation