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].
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
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,
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