On Mon, Oct 01, 2018 at 03:37:01PM +0000, Bossart, Nathan wrote: > Good idea. This patch looks good to me.
Thanks, I have pushed this one now. > Without the find_all_inheritors() stuff, I think we would just need to > modify the ANALYZE documentation patch to say something like > > Specifies that ANALYZE should not wait for any conflicting locks > to be released: if a relation cannot be locked immediately without > waiting, the relation is skipped. Note that even with this > option, ANALYZE can still block when opening the relation's > indexes or when acquiring sample rows to prepare the statistics. > Also, while ANALYZE ordinarily processes all leaf partitions of > partitioned tables, this option will cause ANALYZE to skip all > leaf partitions if there is a conflicting lock on the partitioned > table. Yes, I think that we could live with something like that. I could give this whole thing a shot, but this will have to wait until the commit fest is closed as there are still many patches to classify. If you can send a patch that's of course always helpful.. -- Michael
signature.asc
Description: PGP signature
