Re: A question on the query planner - Mailing list pgsql-performance

From Jared Carr
Subject Re: A question on the query planner
Date
Msg-id 3FCCF61E.90307@89glass.com
Whole thread Raw
In response to Re: A question on the query planner  (Greg Stark <gsstark@mit.edu>)
Responses Re: A question on the query planner  (Greg Stark <gsstark@mit.edu>)
List pgsql-performance
Greg Stark wrote:

>Jared Carr <jared@89glass.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.


pgsql-performance by date:

Previous
From: Greg Stark
Date:
Subject: Re: A question on the query planner
Next
From: Vivek Khera
Date:
Subject: autovacuum daemon stops doing work after about an hour