Re: doc: vacuum full, fillfactor, and "extra space" - Mailing list pgsql-hackers

From Fabien COELHO
Subject Re: doc: vacuum full, fillfactor, and "extra space"
Date
Msg-id alpine.DEB.2.21.1912271150160.27864@pseudo
Whole thread Raw
In response to doc: vacuum full, fillfactor, and "extra space"  (Justin Pryzby <pryzby@telsasoft.com>)
Responses Re: doc: vacuum full, fillfactor, and "extra space"  (Justin Pryzby <pryzby@telsasoft.com>)
List pgsql-hackers
Hello Justin,

> I started writing this patch to avoid the possibly-misleading phrase: "with no
> extra space" (since it's expected to typically take ~2x space, or 1x "extra"
> space).
>
> But the original phrase "with no extra space" seems to be wrong anyway, since
> it actually follows fillfactor, so say that.  Possibly should be backpatched.

Patch applies and compiles.

Given that the paragraph begins with "Plain VACUUM (without FULL)", it is 
better to have the VACUUM FULL explanations on a separate paragraph, and 
the fillfactor precision makes it explicit about what it does, although it 
could also be material for the NOTES section below.

-- 
Fabien.



pgsql-hackers by date:

Previous
From: Julien Rouhaud
Date:
Subject: Re: Expose lock group leader pid in pg_stat_activity
Next
From: Ashutosh Sharma
Date:
Subject: Re: Calling PLpgSQL function with composite type fails with an error:"ERROR: could not open relation with OID ..."