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>,"Kevin Grittner" <Kgrittn(dot)CCAP(dot)Courts(at)wicourts(dot)gov>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: OUTER JOIN performance regression remains in8.3beta4
Date: 2008-01-04 23:45:21
Message-ID: 477E70B1.EE98.0025.0@wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
>>> On Fri, Jan 4, 2008 at  4:51 PM, in message
<477E640F(dot)EE98(dot)0025(dot)0(at)wicourts(dot)gov>, "Kevin Grittner"
<Kevin(dot)Grittner(at)wicourts(dot)gov> wrote: 

>  keyEventSeqNo  | integer       |

>         COALESCE(
>         CASE
>             WHEN d."eventType" IS NOT NULL THEN d."keyEventSeqNo"::smallint
>             ELSE b."keyEventSeqNo"::smallint
>         END::integer, 0) AS "keyEventSeqNo",
 
That seems like a potential problem.  I should probably be casting
the literal of zero to "HistSeqNoT".
 
-Kevin
 



In response to

Responses

pgsql-hackers by date

Next:From: Kevin GrittnerDate: 2008-01-05 00:01:12
Subject: Re: OUTER JOIN performance regression remains in8.3beta4
Previous:From: Kevin GrittnerDate: 2008-01-04 23:29:30
Subject: Re: OUTER JOIN performance regression remains in8.3beta4

pgsql-patches by date

Next:From: Kevin GrittnerDate: 2008-01-05 00:01:12
Subject: Re: OUTER JOIN performance regression remains in8.3beta4
Previous:From: Kevin GrittnerDate: 2008-01-04 23:29:30
Subject: Re: OUTER JOIN performance regression remains in8.3beta4

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