- On *Thu, 6/26/08, Phillip Mills <[EMAIL PROTECTED]>* wrote:
>
> From: Phillip Mills <[EMAIL PROTECTED]>
> Subject: [GENERAL] Partial Index Too Literal?
> To: pgsql-general@postgresql.org
> Date: Thursday, June 26, 2008, 7:24 PM
>
>
> Under somewhat unusual circu
use this
explain analyze select * from result where active = 't';
--- On Thu, 6/26/08, Phillip Mills <[EMAIL PROTECTED]> wrote:
From: Phillip Mills <[EMAIL PROTECTED]>
Subject: [GENERAL] Partial Index Too Literal?
To: pgsql-general@postgresql.org
Date: Thursday, June 26
On Thu, Jun 26, 2008 at 03:24:41PM -0400, Phillip Mills wrote:
> dev=# explain analyze select * from result where active = true;
> dev=# explain analyze select * from result where active is true;
> This is version 8.2.6. Is there something I'm missing that could make these
> queries ever produce
Under somewhat unusual circumstances, rows in one of our tables have an
'active' flag with a true value. We check for these relatively often since
they represent cases that need special handling. We've found through
testing that having a partial index on that field works well. What seems
odd to
