Request a Demo
Home   >   mailing lists

Don't treat virtual generated columns as missing statistics in vacuumdb --missing-stats-only - Mailing list pgsql-hackers

From Yugo Nagata
Subject Don't treat virtual generated columns as missing statistics in vacuumdb --missing-stats-only
Date
Msg-id 20250820104226.8ba51e43164cd590b863ce41@sraoss.co.jp
Whole thread Raw
Responses Re: Don't treat virtual generated columns as missing statistics in vacuumdb --missing-stats-only
List pgsql-hackers
Tree view 
Hi,

I found that "vacuumdb --missing-stats-only" always performs ANALYZE
on tables with a virtual generated column, since such columns currently
never have statistics. This seems like an obvious waste, so I've attached
a patch to fix it, ensuring that virtual generated columns are not
regarded as missing statistics.

Regards,
Yugo Nagata

-- 
Yugo Nagata <nagata@sraoss.co.jp>
Attachment

pgsql-hackers by date:

Previous
From: Japin Li
Date:
Subject: Re: Standardize LSN-based filename
Next
From: Xuneng Zhou
Date:
Subject: Re: memory leak in logical WAL sender with pgoutput's cachectx