Postgres Pro
Downloads
Home   >   mailing lists

Re: empty string causes planner to avoid index. Makes me sad. - Mailing list pgsql-general

From Tom Lane
Subject Re: empty string causes planner to avoid index. Makes me sad.
Date
Msg-id 21905.1259363431@sss.pgh.pa.us
Whole thread Raw
In response to Re: empty string causes planner to avoid index. Makes me sad.  (Jeff Amiel <becauseimjeff@yahoo.com>)
Responses Re: empty string causes planner to avoid index. Makes me sad.
List pgsql-general
Tree view 
Jeff Amiel <becauseimjeff@yahoo.com> writes:
> Ok...third try.  The cost when passing in an empty string is SIGNIFICANTLY higher than when not.

That just reflects the fact that it's expecting a lot more rows matching
that query.  I suppose this is because the statistics show you've got a
lot more rows containing the empty string than other values.

            regards, tom lane

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: empty string causes planner to avoid index. Makes me sad.
Next
From: Tom Lane
Date:
Subject: Re: Cannot allocate memory for output buffer