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:
2008-01-04 18:16:13 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2008-01-04 22:16:53 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2008-01-04 22:40:22 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-01-04 22:44:27 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2008-01-04 22:29:32 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-01-04 22:42:16 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2008-01-04 22:46:59 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-01-04 22:51:27 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2008-01-04 23:45:21 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2008-01-05 00:01:12 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2008-01-05 00:46:15 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-01-05 03:09:30 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-01-05 23:38:38 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-01-07 16:07:24 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2008-01-04 23:29:30 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2008-01-07 01:20:10 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-01-07 15:01:50 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2008-01-17 16:44:16 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2008-01-17 18:30:51 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-01-17 19:35:01 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2008-01-17 22:25:36 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2008-01-08 21:11:16 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-01-08 21:20:51 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2008-01-08 21:40:20 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-01-09 16:47:51 from Gregory Stark <stark(at)enterprisedb(dot)com>
2008-01-09 17:13:40 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-01-09 19:05:07 from Gregory Stark <stark(at)enterprisedb(dot)com>
2008-01-09 19:54:55 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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
In response to
Responses
pgsql-hackers by date
Next :From: Kevin GrittnerDate: 2008-01-05 00:01:12Subject : Re: OUTER JOIN performance regression remains in8.3beta4Previous :From : Kevin GrittnerDate : 2008-01-04 23:29:30Subject : Re: OUTER JOIN performance regression remains in8.3beta4
pgsql-patches by date
Next :From: Kevin GrittnerDate: 2008-01-05 00:01:12Subject : Re: OUTER JOIN performance regression remains in8.3beta4Previous :From : Kevin GrittnerDate : 2008-01-04 23:29:30Subject : Re: OUTER JOIN performance regression remains in8.3beta4
