PostgreSQL cluster parameter settings

• Is autovacuum enabled for all tables by default?

• What are the default values for LC_COLLATE and LC_CTYPE database settings?

• Can I change the LC_COLLATE and LC_CTYPE values?

• Can I change the database owner?

Is autovacuum enabled for all tables by default?Is autovacuum enabled for all tables by default?

Yes, AUTOVACUUM is enabled for all tables by default.

Autovacuuming does not run at a specific time. Instead, it runs when a certain value specified in the settings is reached, for example, when the share of updated or deleted table records becomes equal to the Autovacuum vacuum scale factor.

For more information, see this PostgreSQL guide.

What are the default values for LC_COLLATE and LC_CTYPE database settings?What are the default values for LC_COLLATE and LC_CTYPE database settings?

The default settings for new databases are LC_CTYPE=C and LC_COLLATE=C. You cannot change these settings for the database created alongside the cluster. However, you can create a new database and specify the required values for it.

Can I change the LC_COLLATE and LC_CTYPE values?Can I change the LC_COLLATE and LC_CTYPE values?

Once a database is created, you cannot change its locale settings. However, you can:

• Create a new database with the required settings.
• Specify the collation locale (LC_COLLATE) for the database objects:
  • When calling a function:

    SELECT lower(t1 COLLATE "ru_RU.utf8") FROM test;
    

  • When creating or altering a table:

    CREATE TABLE test (t1 text COLLATE "ru_RU.utf8");
    

Can I change the database owner?Can I change the database owner?

Once a database is created, you cannot change its owner. An attemp to change the owner of a database created using Terraform by editing its owner setting will trigger the database recreation, resulting in data loss.