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 in 8.3beta4 |
Date: | 2008-01-04 23:45:21 |
Message-ID: | 477E70B1.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: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
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2008-01-05 00:01:12 | Re: OUTER JOIN performance regression remains in 8.3beta4 |
Previous Message | Kevin Grittner | 2008-01-04 23:29:30 | Re: OUTER JOIN performance regression remains in 8.3beta4 |
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2008-01-05 00:01:12 | Re: OUTER JOIN performance regression remains in 8.3beta4 |
Previous Message | Kevin Grittner | 2008-01-04 23:29:30 | Re: OUTER JOIN performance regression remains in 8.3beta4 |