From:
Robert Haas <robertmhaas(at)gmail(dot)com>
To:
Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com>
Cc:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Erik Rijkers <er(at)xs4all(dot)nl>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: review: More frame options in window functions
Date:
2010-01-22 20:09:29
Message-ID:
603c8f071001221209n52c6696re69b62ad4f99acf7@mail.gmail.com (view raw or flat )
Thread:
2009-12-31 09:49:26 from Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com>
2010-01-04 17:20:07 from Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com>
2010-01-13 12:37:43 from Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com>
2010-01-15 23:12:47 from "Erik Rijkers" <er(at)xs4all(dot)nl>
2010-01-16 08:29:49 from Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com>
2010-01-16 12:26:30 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2010-01-16 18:54:33 from "Erik Rijkers" <er(at)xs4all(dot)nl>
2010-01-16 21:26:57 from Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com>
2010-01-16 22:49:29 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-01-17 06:28:45 from Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com>
2010-01-18 19:32:20 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-01-19 00:48:32 from Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com>
2010-01-19 01:24:33 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-01-19 20:02:16 from Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com>
2010-01-20 10:06:28 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2010-01-22 20:09:29 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-01-23 07:43:27 from Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com>
2010-02-08 19:17:15 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-02-08 19:39:44 from Josh Berkus <josh(at)agliodbs(dot)com>
2010-02-08 20:43:22 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-02-09 03:37:32 from Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com>
2010-02-09 04:44:36 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-02-11 21:31:38 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-02-12 00:10:18 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-02-11 20:14:44 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2010-02-11 20:26:53 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-02-11 20:33:25 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-02-11 20:52:53 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-02-11 21:33:34 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-02-11 21:37:00 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-02-12 08:19:32 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-02-12 14:40:48 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-02-12 15:49:34 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-02-12 16:55:40 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-02-11 21:00:25 from Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
2010-02-12 01:06:16 from Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com>
2010-02-12 17:47:19 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-02-13 06:42:05 from Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com>
Lists:
pgsql-hackers
On Tue, Jan 19, 2010 at 3:02 PM, Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com> wrote:
> 2010/1/19 Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com>:
>> Yeah, that's my point, too. The planner has to distinguish "four" from
>> sort pathkeys and to teach the executor the simple information which
>> column should be used to determine frame. I was bit wrong because some
>> of current executor code isn't like it, like using ordNumCols == 0 to
>> know whether partition equals to frame, though....
>
> And here's another version to fix this problem (I hope). Now the
> planner distinguish sort column from actual significant pathkeys. I
> tested it on both of 32bit and 64bit Linux.
Would it make sense to pull some of the infrastructure bits out of
this patch and commit those bits separately, so as to reduce the size
of the main patch? In particular, the AggGetMemoryContext() stuff
looks like a good candidate for that treatment.
Why did you change BETWEEN from a TYPE_FUNC_NAME_KEYWORD to a COL_NAME_KEYWORD?
...Robert
In response to
Responses
pgsql-hackers by date
Next :From: Tom LaneDate: 2010-01-22 20:12:03
Subject : Re: Largeobject Access Controls (r2460)
Previous :From : Robert HaasDate : 2010-01-22 19:20:01
Subject : Re: quoting psql varible as identifier