Re: OUTER JOIN performance regression remains in 8.3beta4

>>> On Fri, Jan 4, 2008 at  4:46 PM, in message <24033.1199486819@sss.pgh.pa.us>,
Tom Lane <tgl@sss.pgh.pa.us> wrote:
> nor mentions the data types involved.Schema |     Name          |     Type                | Modifier | Check
--------+-------------------+-------------------------+----------+-------public | ArrestCaseNoT     | character(12)
     |          |public | ArrestTrackingNoT | character(14)           |          |public | BookCaseNoT       |
character(12)          |          |public | CalDurationT      | numeric(6,2)            |          |public | CaseNoT
      | character(14)           |          |public | CaseTypeT         | character(2)            |          |public |
ChargeIdT        | character varying(15)   |          |public | ChargeNoT         | smallint                |
|public| ChargeSeqNoT      | smallint                |          |public | ChargeStatusCodeT | character varying(2)    |
        |public | CountyNoT         | smallint                |          |public | CtofcNoT          | character(4)
      |          |public | DateT             | date                    |          |public | DispoCodeT        |
character(5)           |          |public | EventDescrT       | character(50)           |          |public | EventTypeT
      | character(5)            |          |public | HistSeqNoT        | smallint                |          |public |
IssAgencyNoT     | smallint                |          |public | JdgmtSeqNoT       | smallint                |
|public| KeyEventSeqT      | smallint                |          |public | MoneyT            | numeric(13,2)           |
        |public | OffenseDateRangeT | character varying(100)  |          |public | PdCodeT           | character(2)
      |          |public | PleaCodeT         | character(4)            |          |public | PlntfAgencyNoT    |
smallint               |          |public | SccaCaseNoT       | character varying(14)   |          |public |
SevClsCodeT      | character(2)            |          |public | StatuteCiteT      | character(21)           |
|public| StatuteDescrT     | character varying(100)  |          |public | StatuteSevSeqNoT  | smallint                |
        |public | TagTypeT          | character(2)            |          |public | TapeCounterNoT    | character(16)
      |          |public | TapeLocT          | character(18)           |          |public | TextT             |
charactervarying(2000) |          |public | UserIdT           | character(8)            |          |public |
WcisClsCodeT     | character(5)            |          |  
We're in the process of converting all of the char to varchar, but
both the previous report and this one still have char as shown here.
-Kevin