Horton

Re: GROUP BY ROLLUP queries on views trigger full table scans (index usage not optimized)

Richard Guo <guofenglinux@gmail.com>

View thread
From: Richard Guo <guofenglinux@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Haowu Ge <gehaowu@bitmoe.com>, pgsql-bugs <pgsql-bugs@lists.postgresql.org>
Date: 2025-12-30T03:47:51Z
Lists: pgsql-bugs 
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