Re: Premature view materialization in 8.2?

"Jonathan Ellis" <jonathan@utahpython.org> writes:
> On 4/6/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Yeah, it sure is the same plan, and 8.2 seems to be a tad faster right
>> up to the hash join on user_id.  Is user_id a textual datatype?

> user_id is an int; they are both C locale.

Really!?  So much for that theory.

Is work_mem set similarly on both installations?

The only other thing I can think is that you've exposed some unfortunate
corner case in the hash join logic.  Would you be willing to send me
(off-list) the lists of user_ids being joined?  That would be the
clan_members.user_id column and the user_id column from the join of
parties and clan_participants.

            regards, tom lane