Cluster configuration PostgreSQL

• Is autovacuum enabled for all tables by default?

• What are the default LC_COLLATE and LC_CTYPE values for databases?

• Can I change the LC_COLLATE and LC_CTYPE values?

• Can I change the database owner?

Is 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 the PostgreSQL documentation.

Which LC_COLLATE and LC_CTYPE values are set for databases by default?Which LC_COLLATE and LC_CTYPE values are set for databases by default?

As databases are created, LC_CTYPE=C and LC_COLLATE=C are set by default. You can't change these settings for the database you create with clusters. However, you can create a new database and set the values you need for it.

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

You cannot change locale settings after you create a database. You can:

• Create a new database with the desired settings.
• Set a sorting locale (LC_COLLATE) for elements of an existing database:
  • When calling a function:

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

  • When creating and updating a table:

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

Can I change the DB owner?Can I change the DB owner?

Once you create a DB, you cannot change its owner. If you create a DB via Terraform and then change its owner in the owner parameter, this will recreate the DB and its data will be lost.