Re: CREATE INDEX vs. TOAST table stats - Mailing list pgsql-hackers

From Nathan Bossart
Subject Re: CREATE INDEX vs. TOAST table stats
Date
Msg-id ant7ls0-vDPloJHX@nathan
Whole thread
In response to Re: CREATE INDEX vs. TOAST table stats  (Sami Imseih <samimseih@gmail.com>)
List pgsql-hackers
On Tue, Aug 11, 2026 at 02:25:10PM -0500, Sami Imseih wrote:
> One thing is CREATE INDEX, mentioned in the subject, never calls
> index_update_stats() on the toast relation, so the toast stats are not
> updated by it. This will only be called when the toast's own index is
> rebuilt, i.e. REINDEX, VACUUM FULL, CLUSTER, REPACK.

Sorry, I'm untangling a few different things in this area and got it mixed
up.  I think you're right, and I think I also misstated the impact.  But
IMHO the fix is still the way to go, for the two reasons I mentioned
upthread.

> +1 on backpatching to v18.

Thanks for reviewing.

-- 
nathan



pgsql-hackers by date:

Previous
From: Alexandre Felipe
Date:
Subject: Re: [PATCH] bufmgr: tighten LWLock:BufferMapping on InvalidateBuffer
Next
From: Jelte Fennema-Nio
Date:
Subject: Re: Bump soft open file limit (RLIMIT_NOFILE) to hard limit on startup