Module12_Routine_Maintenance Flashcards
1
Q
what are the 3 maintenance commands
A
Analyze
vacuum
cluster
2
Q
how to analyze 1 table
A
analyze table_name;
3
Q
what does vacuum full do?
A
rewrite the entire table with only valid rows. whole table will be blocked and extra disk is used.
4
Q
how can we prevent transaction ID wraparround failures
A
by performing vacuum
5
Q
where are the visibility map stored
A
stored ar <relfilenode>_vm (visibility map)</relfilenode>
6
Q
what are the 2 actions autovacuum can’t do
A
perform a VACUUM FULL and vacuum temporary tables
7
Q
how to enable or change autovacuum for 1 table
A
alter table TABLE_NAME autovaccum_enabled;
8
Q
how to rebuild an index
A
reindex index/table/schema/database NAME;
9
Q
how to perform vacuum and analyze on database at once from OS
A
vacuumdb -az (A is for all databases and Z is for analyze)
