Request a Demo
Home   >   mailing lists

Re: GROUP BY ROLLUP queries on views trigger full table scans (index usage not optimized) - Mailing list pgsql-bugs

From Richard Guo
Subject Re: GROUP BY ROLLUP queries on views trigger full table scans (index usage not optimized)
Date
Msg-id CAMbWs49hJwP92mB5GFdj06cgH553SbbSNQZR2NnLD6VG6e00rg@mail.gmail.com
Whole thread Raw
In response to Re: GROUP BY ROLLUP queries on views trigger full table scans (index usage not optimized)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
On Mon, Dec 29, 2025 at 1:51 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
> So here, I think the don't-break-things rule points towards
> back-patching.

Thanks for the confirmation.  I've pushed this patchset and
back-patched it to v18.

Thanks for the report, Haowu.  The fix will be in the next minor
release, scheduled for February.

- Richard

pgsql-bugs by date:

Previous
From: Japin Li
Date:
Subject: Re: BUG #19367: typos in backend/utils/adt/timestamp.c
Next
From: Amit Kapila
Date:
Subject: Re: BUG #19360: Bug Report: Logical Replication initial sync fails with "conflict=update_origin_differs" PG12 toPG18