Skip site navigation (1) Skip section navigation (2)

Re: OUTER JOIN performance regression remains in8.3beta4

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 in8.3beta4
Date: 2008-01-04 23:29:30
Message-ID: 477E6CF9.EE98.0025.0@wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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
 


In response to

pgsql-hackers by date

Next:From: Kevin GrittnerDate: 2008-01-04 23:45:21
Subject: Re: OUTER JOIN performance regression remains in8.3beta4
Previous:From: Kevin GrittnerDate: 2008-01-04 22:51:27
Subject: Re: OUTER JOIN performance regression remains in8.3beta4

pgsql-patches by date

Next:From: Kevin GrittnerDate: 2008-01-04 23:45:21
Subject: Re: OUTER JOIN performance regression remains in8.3beta4
Previous:From: Kevin GrittnerDate: 2008-01-04 22:51:27
Subject: Re: OUTER JOIN performance regression remains in8.3beta4

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group