On Mon, Jul 5, 2010 at 5:36 AM, Jens Hoffrichter <jens.hoffrich...@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) -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
