Re: pgsql: Update guidance for running vacuumdb after pg_upgrade.

2025-04-22 Thread Christoph Berg
Re: Nathan Bossart > Update guidance for running vacuumdb after pg_upgrade. > > Now that pg_upgrade can carry over most optimizer statistics, we > should recommend using vacuumdb's new --missing-stats-only option > to only analyze relations that are missing statistics. I've been looking at vacuum

Re: index prefetching

2025-04-22 Thread Peter Geoghegan
On Tue, Apr 22, 2025 at 2:34 PM Tomas Vondra wrote: > Yeah, that makes sense, although I've been thinking about this a bit > differently. I haven't been trying to establish a new "component" to > manage prefetching. For me the question was what's the right layer, so > that unnecessary details don'

Re: Proposal: Filter irrelevant change before reassemble transactions during logical decoding

2025-04-22 Thread Peter Smith
Hi Ajin, Some review comments for patch v17-0002. == src/backend/replication/logical/decode.c 1. /* + * Check if filtering changes before decoding is supported and we're not suppressing filter + * changes currently. + */ +static inline bool +FilterChangeIsEnabled(LogicalDecodingContext *ctx

<    1   2