should check interrupts in BuildRelationExtStatistics ? - Mailing list pgsql-hackers

From Justin Pryzby
Subject should check interrupts in BuildRelationExtStatistics ?
Date
Msg-id 20220509000108.GQ28830@telsasoft.com
Whole thread Raw
Responses Re: should check interrupts in BuildRelationExtStatistics ?
List pgsql-hackers
Restarting a large instance took twice as long as I expected due to not
checking interrupts in (at least) statext_ndistinct_build.  Long enough that I
attached (and was able to attach) a debugger to verify, which I think is too
long.  I think it could cause issues for an high-availability cluster or other
script if it takes too long to shut down.

The tables being auto-analyzed have 9 exteneded stats objects, each with stats
target=10.  7 of those are (ndistinct) stats on 4 simple columns plus 1
expression (5 total).  And the other 2 stats objects are expressional stats
(necessarily on a single expression).



pgsql-hackers by date:

Previous
From: Thomas Munro
Date:
Subject: Re: wrong fds used for refilenodes after pg_upgrade relfilenode changes Reply-To:
Next
From: Michael Paquier
Date:
Subject: Re: Possible corruption by CreateRestartPoint at promotion