Re: Planner matching constants across tables in a join

From: Greg Stark <gsstark(at)mit(dot)edu>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: Greg Stark <gsstark(at)mit(dot)edu>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Planner matching constants across tables in a join
Date: 2003-03-05 15:02:17
Message-ID: 87llzt97ra.fsf@stark.dyndns.tv
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Richard Huxton <dev(at)archonet(dot)com> writes:

> Filter: ((line_id)::text = '0912345 0004'::text)

So I think this means that line_id is being casted to "text". Though I'm not
clear why it would be choosing "text" for the constant if line_id wasn't text
to begin with.

In any case my plans here look like:
> Filter: (aa = 'x'::text)

so it looks like there's something extra going on in your plan.

what does your table definition look like?

--
greg

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2003-03-05 15:08:38 Re: Planner matching constants across tables in a join
Previous Message Richard Huxton 2003-03-05 14:24:12 Re: Planner matching constants across tables in a join