| 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.
| 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 |