Re: empty string causes planner to avoid index. Makes me sad.

From: Jeff Amiel <becauseimjeff(at)yahoo(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: empty string causes planner to avoid index. Makes me sad.
Date: 2009-11-27 21:41:36
Message-ID: 341956.65581.qm@web65507.mail.ac4.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hmm...ok...planner is not using the index effectively (as effectively as when a non-empty value is passed in)

--- On Fri, 11/27/09, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> Subject: Re: [GENERAL] empty string causes planner to avoid index. Makes me sad.
> To: "Jeff Amiel" <becauseimjeff(at)yahoo(dot)com>
> Cc: pgsql-general(at)postgresql(dot)org
> Date: Friday, November 27, 2009, 3:14 PM
> Jeff Amiel <becauseimjeff(at)yahoo(dot)com>
> writes:
> > It appears that somehow the empty string is causing
> the planner to abandon the index.
>
> You didn't actually show us such a case...
>
>            
> regards, tom lane
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-11-27 22:00:26 Re: empty string causes planner to avoid index. Makes me sad.
Previous Message Pete Erickson 2009-11-27 21:34:51 Cannot allocate memory for output buffer