Re: Fix incorrect start up costs for WindowAgg paths (bug #17862)

Tim Palmer <tim3sp@gmail.com>

From: Tim Palmer <tim3sp@gmail.com>
To: David Rowley <dgrowleyml@gmail.com>, PostgreSQL Developers <pgsql-hackers@lists.postgresql.org>
Date: 2023-08-03T18:08:28Z
Lists: pgsql-hackers
On Thu, 3 Aug 2023 at 05:50, David Rowley <dgrowleyml@gmail.com> wrote:

> I'm currently thinking it's
> a bad idea to backpatch this but I'd consider it more if someone else
> thought it was a good idea or if more people came along complaining
> about poor plan choice in plans containing WindowAggs. Currently, it
> seems better not to destabilise plans in the back branches. (CC'd Tim,
> who reported #17862, as he may have an opinion on this)
>

I agree it's better not to destabilise plans in the back branches.

Tim

Commits

  1. Minor adjustments to WindowAgg startup cost code

  2. Account for startup rows when costing WindowAggs