Re: A question on the query planner

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: Jared Carr <jared(at)89glass(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: A question on the query planner
Date: 2003-12-02 23:50:47
Message-ID: 25476.1070409047@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Greg Stark <gsstark(at)mit(dot)edu> writes:
> Huh. The following shows something strange. It seems joining on two varchars
> no longer works well. Instead the optimizer has to convert both columns to
> text.

Define "no longer works well". varchar doesn't have its own comparison
operators anymore, but AFAIK that makes no difference.

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Stark 2003-12-03 01:33:15 Re: A question on the query planner
Previous Message Neil Conway 2003-12-02 23:37:17 Re: cross table indexes or something?