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
