Skip to content

array_agg() performance #23715

New issue
New issue
Closed
Bug
#23716
Closed
array_agg() performance#23715
Bug
#23716
Assignees
fred1268
Labels
bugSomething isn't working

Description

@fred1268
fred1268
opened on Jul 20, 2026

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

Activity

  1. fred1268
    added
    bugSomething isn't working
    on Jul 20, 2026
  2. fred1268
    added the
    Bug
    issue type on Jul 20, 2026

  3. fred1268 commented on Jul 20, 2026

    @fred1268
    fred1268
    on Jul 20, 2026
    ContributorAuthor

    take

  4. github-actions
    assigned
    fred1268
    on Jul 20, 2026
  5. Jithendra2608
    added a commit that references this issue on Jul 21, 2026

    `array_agg()` add tests and benchmarks (apache#23740)

    1fcdef2
  6. alamb
    closed this as completedin #23716on Jul 29, 2026
  7. mkleen
    added a commit that references this issue on Jul 29, 2026

    perf: `array_agg()` performance improvements (apache#23716)

    cd28203
  8. kosiew
    added 2 commits that reference this issue on Aug 12, 2026

    `array_agg()` add tests and benchmarks (apache#23740)

    3a6883f

    perf: `array_agg()` performance improvements (apache#23716)

    c8c1521
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

bugSomething isn't working

Type

Bug

Projects

No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions