From:
Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc:
Dimitri Fontaine <dfontaine(at)hi-media(dot)com>,Robert Haas <robertmhaas(at)gmail(dot)com>,Martijn van Oosterhout <kleptog(at)svana(dot)org>,Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com>, 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-02-12 15:49:34
Message-ID:
20100212154934.GE3737@alvh.no-ip.org (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
Tom Lane escribió:
> Dimitri Fontaine <dfontaine(at)hi-media(dot)com> writes:
> > Searching the archives ain't helping me refresh those memories. So it
> > seems the case for an extended opclass infrastructure, or a new side
> > one, is between thin an non-existent yet?
>
> Yeah, I don't immediately see anything that would justify going to
> that level of effort. Adding +/- as support functions for btree
> seems like the thing to do.
Would it work to use a fake access method instead? If we add it to
btree, will we be able to backtrack and move that to a separate catalog
if we ever determine that it would have been better?
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
In response to
Responses
pgsql-hackers by date
Next :From: Marko KreenDate: 2010-02-12 15:50:30Subject : Re: TCP keepalive support for libpqPrevious :From : Robert HaasDate : 2010-02-12 15:49:16Subject : Re: Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb)
