CODEWITHSUNDEEP
postgresqlautovacuum
Cholho Lee
Cholho Lee

Reputation: 1

what is the default value in reloptions that ran autovacuum is running

I have checked table in Postgres server.

SELECT reloptions
FROM pg_class
WHERE relname = 'log_xxx_table';

I guessed that return data is "autovacuum_enabled = true" but return data is null.

This table have vacuum log ran autovacuum.

default reloptions is null but autovacuum_enabled = true?

Upvotes: 0

Views: 2193

Answers (1)

klin
klin

Reputation: 121614

The default value of reloptions is null, what means that configurable options are set to their default values. The default value of autovacuum_enabled is true. You can set it like in the example:

create table a_table(id int)
with (autovacuum_enabled = false);

select relname, reloptions
from pg_class
where relname = 'a_table';

 relname |         reloptions         
---------+----------------------------
 a_table | {autovacuum_enabled=false}
(1 row)

Upvotes: 2

Related Questions