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.
