From: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: OUTER JOIN performance regression remains in 8.3beta4 |
Date: | 2008-01-04 23:29:30 |
Message-ID: | 477E6CF9.EE98.0025.0@wicourts.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
>>> On Fri, Jan 4, 2008 at 4:46 PM, in message <24033(dot)1199486819(at)sss(dot)pgh(dot)pa(dot)us>,
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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 | character varying(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
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2008-01-04 23:45:21 | Re: OUTER JOIN performance regression remains in 8.3beta4 |
Previous Message | Kevin Grittner | 2008-01-04 22:51:27 | Re: OUTER JOIN performance regression remains in 8.3beta4 |
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2008-01-04 23:45:21 | Re: OUTER JOIN performance regression remains in 8.3beta4 |
Previous Message | Kevin Grittner | 2008-01-04 22:51:27 | Re: OUTER JOIN performance regression remains in 8.3beta4 |