On 3/13/20 10:32 AM, Fabio Ugo Venchiarutti wrote:
On 13/03/2020 15:15, Ron wrote:
This is why I'd VACUUM FULL in a planned manner, one or two tables at a time, and *locally* from crontab.
That's not really viable on any remotely busy system: VACUUM FULL claims exclusive table locks, causing queries to hang (https://www.postgresql.org/docs/current/sql-vacuum.html#NOTES mentions this too).
This is of course
if I were to ever do a VACUUM FULL... :)
The point is that your mother's rule about not sticking a giant fork-full of food into your mouth is also an excellent rule in IT.
--
Angular momentum makes the world go 'round.
