Skip to content

array_agg() performance #23715

Description

@fred1268

Describe the bug

The array_agg() function (used in queries like SELECT array_agg(DISTINCT col)) is slow due to per-row memory allocation

To Reproduce

Run any flavor of array_agg() like SELECT array_agg(DISTINCT col)

Expected behavior

array_agg() should not make per-row allocation

Additional context

No response

Metadata

Metadata

Assignees

Labels

bugSomething isn't working

Type

Fields

No fields configured for Bug.

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions