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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, Jul 5, 2010 at 5:36 AM, Jens Hoffrichter
<jens.hoffrichter@xxxxxxxxx> 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)

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux