Re: Planner matching constants across tables in a join - Mailing list pgsql-performance

From Greg Stark
Subject Re: Planner matching constants across tables in a join
Date
Msg-id 87llzt97ra.fsf@stark.dyndns.tv
Whole thread Raw
In response to Re: Planner matching constants across tables in a join  (Richard Huxton <dev@archonet.com>)
Responses Re: Planner matching constants across tables in a join  (Richard Huxton <dev@archonet.com>)
List pgsql-performance
Richard Huxton <dev@archonet.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

pgsql-performance by date:

Previous
From: Rod Taylor
Date:
Subject: Re: OIDs as keys
Next
From: Tom Lane
Date:
Subject: Re: Planner matching constants across tables in a join