Re: vacuum full doubled database size
От
Ron
Тема
Re: vacuum full doubled database size
Дата
Msg-id
7c0a3bab-859e-5be4-f0bd-0e06d72f40de@gmail.com
Ответ на
Re: vacuum full doubled database size (Fabio Ugo Venchiarutti)
Список
Дерево обсуждения
vacuum full doubled database size "Zwettler Markus (OIZ)" <Markus.Zwettler@zuerich.ch>
Re: vacuum full doubled database size Ron <ronljohnsonjr@gmail.com>
Re: vacuum full doubled database size Fabio Ugo Venchiarutti <f.venchiarutti@ocado.com>
Re: vacuum full doubled database size Ron <ronljohnsonjr@gmail.com>
RE: vacuum full doubled database size Kevin Brannen <KBrannen@efji.com>
Re: vacuum full doubled database size Michael Loftis <mloftis@wgops.com>
AW: vacuum full doubled database size "Zwettler Markus (OIZ)" <Markus.Zwettler@zuerich.ch>
On 3/13/20 10:32 AM, Fabio Ugo Venchiarutti wrote:
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.
--
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.
В списке pgsql-general по дате отправления
