option "--routine-vacuum"

dataegret / pgcompacttable

BSD 3-Clause "New" or "Revised" License

314 stars 48 forks source link

option "--routine-vacuum" #39

Closed glushakov closed 3 years ago

glushakov commented 3 years ago

Hi. Can you explain more detailed option: --routine-vacuum Turn on the routine vacuum. By default all the vacuums are off.

I did not find any ALTER about disabling VACUUM on tables in code Thanks

Melkij commented 3 years ago

Hello It's not about disabling vacuum in any way. With this option we perform additional vacuum while moving rows in a table. By default for each table:

vacuum
calculate bloat
move tuples from end table to beginning
vacuum

With --routine-vacuum we call additional vacuum few times while moving the tuples.

Can be used if the auto vacuum is too slow, for example. Or to return space to OS earlier from the tail of the table.

glushakov commented 3 years ago

Ok, thanks for explanation