Re: Add SKIP LOCKED to VACUUM and ANALYZE - Mailing list pgsql-hackers

From Bossart, Nathan
Subject Re: Add SKIP LOCKED to VACUUM and ANALYZE
Date
Msg-id EF446C09-9059-44C7-9DE5-40F327AE2329@amazon.com
Whole thread Raw
In response to Re: Add SKIP LOCKED to VACUUM and ANALYZE  (Michael Paquier <michael@paquier.xyz>)
List pgsql-hackers
On 10/3/18, 7:10 PM, "Michael Paquier" <michael@paquier.xyz> wrote:
> Thanks, I have committed the patch, after minor tweaks to the docs.

Thanks!

> Mainly, in the VACUUM page, I have added a mention that VACUUM ANALYZE
> can block for row sampling.  I have also removed for now the set of
> recommendations the patch added, as we still gather statistics on the
> partitioned tables from the row samples gathered from the partitions, so
> recommending to list only the leaves is not completely correct either
> all the time.

Good catch.  The committed version of the documentation looks good to
me.

> We could perhaps add something about such recommendations.  A separate
> section covering more general things may be interesting.

Agreed, this could be a good addition to the "Notes" sections.

Nathan


pgsql-hackers by date:

Previous
From: "Iwata, Aya"
Date:
Subject: RE: Function for listing archive_status directory
Next
From: Amit Kapila
Date:
Subject: Re: SerializeParamList vs machines with strict alignment