, Geoffrey M.
Cc: Tom Lane; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Problem with index not being chosen inside PL/PgSQL
function...
On Dec 18, 2007 10:54 AM, Weber, Geoffrey M.
<[EMAIL PROTECTED]> wrote:
> Tom,
>
> Yes, the distribution must be what's doing it.
On Dec 18, 2007 10:54 AM, Weber, Geoffrey M.
<[EMAIL PROTECTED]> wrote:
> Tom,
>
> Yes, the distribution must be what's doing it. I guess I knew that
> subconciously, but was looking for something like hints to force the planner
> to do what I wanted. Instead it looks like I'll have to do a bit
From: Tom Lane [EMAIL PROTECTED]
Sent: Tuesday, December 18, 2007 10:36 AM
To: Weber, Geoffrey M.
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Problem with index not being chosen inside PL/PgSQL
function...
"Weber, Geoffrey M." <[EMAIL PROTECTED]> writes:
>
"Weber, Geoffrey M." <[EMAIL PROTECTED]> writes:
> Hmm - good question! However, it is - both the id and
> not_displayed_id are INTEGERs.
Well, in that case it must be a statistics issue --- does the indexed
column have a badly skewed distribution?
You could investigate how many rows the planner
he suggestion though!
From: Tom Lane [EMAIL PROTECTED]
Sent: Tuesday, December 18, 2007 10:11 AM
To: Weber, Geoffrey M.
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Problem with index not being chosen inside PL/PgSQL
function...
"Weber, Geoff
"Weber, Geoffrey M." <[EMAIL PROTECTED]> writes:
> The problem I'm having is in one particular spot where I'm trying to
> run a "parametized" query inside a PL/PgSQL function.
I wonder whether the parameter is actually of the same datatype as the
indexed column.
regards, t
Hi all,
Thanks to those on this list who contribute their knowledge for our
consumption! I have another question:
The problem I'm having is in one particular spot where I'm trying to run a
"parametized" query inside a PL/PgSQL function. When I run the query directly,
the planner correctly ch