Re: Window Functions & Table Partitions

2023-02-20 Thread David Rowley
On Fri, 10 Feb 2023 at 06:40, Benjamin Tingle wrote: > Thanks for the helpful response david! I'll have a shot at getting the patch > to work myself & submitting to pgsql-hackers. I took some time today for this and fixed up a few mistakes in the patch and added it to the March commitfest [1].

Re: Window Functions & Table Partitions

2023-02-09 Thread Benjamin Tingle
Thanks for the helpful response david! I'll have a shot at getting the patch to work myself & submitting to pgsql-hackers. Ben On Wed, Feb 8, 2023 at 2:36 PM David Rowley wrote: > On Thu, 9 Feb 2023 at 10:45, Benjamin Tingle wrote: > > Basically- window partition functions don't take advantage

Re: Window Functions & Table Partitions

2023-02-08 Thread David Rowley
On Thu, 9 Feb 2023 at 10:45, Benjamin Tingle wrote: > Basically- window partition functions don't take advantage of existing table > partitions. I use window functions as a more powerful GROUP BY clause that > preserves row-by-row information- super handy for a lot of things. > > In particular,

Window Functions & Table Partitions

2023-02-08 Thread Benjamin Tingle
Hell postgres people! This is not an issue report so much as a gripe. I'm on postgres 12.2, so it is entirely possible that the issue I describe is fixed in a later version. If so, it is not described in the docs or any posts I can find archived on pgsql-performance. (I am not brave enough to delv