DBA Hub

📋Steps in this guide1/1

Modify autovacuum setting of table/index

-- Disable autovacuum for a table:

postgresql configurationintermediate
by PostgreSQL
14 views
1

Modify autovacuum setting of table/index

-- Disable autovacuum for a table: -- Enable autovacuum for a table

Code/Command (click line numbers to comment):

1
2
3
4
postgres=#
alter table test2 set( autovacuum_enabled = off);
postgres=#
alter table test2 set( autovacuum_enabled = on);

Comments (0)

Please to add comments

No comments yet. Be the first to comment!