Re: [HACKERS] introduction of WIP window function patch

2008-07-17 Thread H . Harada
2008/7/17 David Fetter <[EMAIL PROTECTED]>: > On Sat, Jul 05, 2008 at 07:04:29PM +0900, H.Harada wrote: >> Hi, >> >> As I proposed a month before, I am working on window function. >> Although this work is at quite early step, I would like to introduce >> it since a part of it have been finished. If

Re: [HACKERS] introduction of WIP window function patch

2008-07-17 Thread David Fetter
On Sat, Jul 05, 2008 at 07:04:29PM +0900, H.Harada wrote: > Hi, > > As I proposed a month before, I am working on window function. > Although this work is at quite early step, I would like to introduce > it since a part of it have been finished. If you can afford and are > interested in it, please

Re: [HACKERS] introduction of WIP window function patch

2008-07-06 Thread H . Harada
2008/7/6 Simon Riggs <[EMAIL PROTECTED]>: > > On Sun, 2008-07-06 at 17:39 +0900, H.Harada wrote: > >> Is there security/performance issue about this? > > Performance, yes. > > If we need access to more rows than will fit within work_mem we have a > problem and will need to restart sort. Giving rand

Re: [HACKERS] introduction of WIP window function patch

2008-07-06 Thread Simon Riggs
On Sun, 2008-07-06 at 17:39 +0900, H.Harada wrote: > Is there security/performance issue about this? Performance, yes. If we need access to more rows than will fit within work_mem we have a problem and will need to restart sort. Giving random access to all tuples in the current window, whateve

Re: [HACKERS] introduction of WIP window function patch

2008-07-06 Thread H . Harada
2008/7/6 Simon Riggs <[EMAIL PROTECTED]>: >> I think there are two types of functions for windowed mode. >> - windowed aggregate >> this type of function is exactly same as normal aggregate. So we use >> functions that have been in pgsql already. Actually in my patch above, >> I didn't introduce an

Re: [HACKERS] introduction of WIP window function patch

2008-07-05 Thread Simon Riggs
On Sun, 2008-07-06 at 03:40 +0900, H.Harada wrote: > Hi, > > 2008/7/6 Simon Riggs <[EMAIL PROTECTED]>: > > > > On Sat, 2008-07-05 at 16:20 +0200, Martijn van Oosterhout wrote: > >> On Sat, Jul 05, 2008 at 07:04:29PM +0900, H.Harada wrote: > > > >> > http://umitanuki.net/pgsql/wfv01/design.html >

Re: [HACKERS] introduction of WIP window function patch

2008-07-05 Thread H . Harada
2008/7/5 Martijn van Oosterhout <[EMAIL PROTECTED]>: > On Sat, Jul 05, 2008 at 07:04:29PM +0900, H.Harada wrote: >> Hi, >> >> As I proposed a month before, I am working on window function. > > Very nice! > >> http://umitanuki.net/pgsql/wfv01/design.html >> >> The problem is, as written in the "Thin

Re: [HACKERS] introduction of WIP window function patch

2008-07-05 Thread H . Harada
Hi, 2008/7/6 Simon Riggs <[EMAIL PROTECTED]>: > > On Sat, 2008-07-05 at 16:20 +0200, Martijn van Oosterhout wrote: >> On Sat, Jul 05, 2008 at 07:04:29PM +0900, H.Harada wrote: > >> > http://umitanuki.net/pgsql/wfv01/design.html >> > >> > The problem is, as written in the "Things to discussed" sect

Re: [HACKERS] introduction of WIP window function patch

2008-07-05 Thread Simon Riggs
On Sat, 2008-07-05 at 16:20 +0200, Martijn van Oosterhout wrote: > On Sat, Jul 05, 2008 at 07:04:29PM +0900, H.Harada wrote: > > http://umitanuki.net/pgsql/wfv01/design.html > > > > The problem is, as written in the "Things to discussed" section of the > > document, how you define window functio

Re: [HACKERS] introduction of WIP window function patch

2008-07-05 Thread Martijn van Oosterhout
On Sat, Jul 05, 2008 at 07:04:29PM +0900, H.Harada wrote: > Hi, > > As I proposed a month before, I am working on window function. Very nice! > http://umitanuki.net/pgsql/wfv01/design.html > > The problem is, as written in the "Things to discussed" section of the > document, how you define wind

[HACKERS] introduction of WIP window function patch

2008-07-05 Thread H . Harada
Hi, As I proposed a month before, I am working on window function. Although this work is at quite early step, I would like to introduce it since a part of it have been finished. If you can afford and are interested in it, please review the document and patch, or compile the applied source to execu