Re: A question on the query planner

From: Jared Carr <jared(at)89glass(dot)com>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: A question on the query planner
Date: 2003-12-02 20:29:18
Message-ID: 3FCCF61E.90307@89glass.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Greg Stark wrote:

>Jared Carr <jared(at)89glass(dot)com> writes:
>
>
>
>>Greg Stark wrote:
>>
>>
>>
>>>> Merge Cond: ("outer"."?column7?" = "inner"."?column5?")
>>>>
>>>>
>>>>
>>>Well it looks like you have something strange going on. What data type is
>>>car_id in each table?
>>>
>>>
>>car_id is a varchar(10) in both tables.
>>
>>
>
>Well for some reason it's being cast to a text to do the merge.
>
>What version of postgres is this btw? The analyzes look like 7.4?
>
>
>
Yes, this is 7.4.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Vivek Khera 2003-12-02 20:37:40 autovacuum daemon stops doing work after about an hour
Previous Message Greg Stark 2003-12-02 20:11:02 Re: A question on the query planner