Re: Significant performance issues with array_agg() + HashAggregate plans on Postgres 17 - Mailing list pgsql-performance

From David Rowley
Subject Re: Significant performance issues with array_agg() + HashAggregate plans on Postgres 17
Date
Msg-id CAApHDvoQUwsuvdhrxVOLsMYWcXZPAMvWweyemCg-q0=dmF3h2w@mail.gmail.com
Whole thread Raw
In response to Re: Significant performance issues with array_agg() + HashAggregate plans on Postgres 17  (Scott Carey <scott.carey@algonomy.com>)
List pgsql-performance
On Wed, 1 Apr 2026 at 20:18, Scott Carey <scott.carey@algonomy.com> wrote:
> The run times are consistent enough (within a 15% range most of the time on the busy server), yet we are talking
abouta 50x performance difference, dwarfing the time variation.
 

If you're able to install the debug symbols and run perf top or perf
record and send us the perf report for one of the problem machines,
that might yield something interesting.

David



pgsql-performance by date:

Previous
From: Scott Carey
Date:
Subject: Re: Significant performance issues with array_agg() + HashAggregate plans on Postgres 17
Next
From: Cándido Antonio Martínez Descalzo
Date:
Subject: Potential partition pruning regression on PostgreSQL 18