How to ensure that the autovacuum daemon is running in my PostgreSQL Docker Container?

Question

I am benchmarking my database running in a Docker container against fragmentation issues and found out that the autovacuum daemon is not running.

SELECT
    schemaname, relname,
    last_vacuum, last_autovacuum,
    vacuum_count, autovacuum_count  -- not available on 9.0 and earlier
FROM pg_stat_user_tables;

gives:

| schemaname | relname     |last_vacuum| last_autovacuum |vacuum_count| autovacuum_count |
|------------|-------------|-----------|-----------------|------------| -----------------|
| public     | mt_doc_order|   <null>  |    <null>       |      0     |         0        |

I am therefore running into fragmentation performances effects:

How can I make sure that this autovacuum daemon is running when I am starting my PostgreSQL Docker Container?

score 3 · Accepted Answer · answered May 22 '19 at 15:16

3

Run the SQL statement

ALTER SYSTEM SET autovacuum = on;

as superuser, then restart the PostgreSQL server process.

answered May 22 '19 at 15:16

Laurenz Albe

209,280
17
206
263

How to ensure that the autovacuum daemon is running in my PostgreSQL Docker Container?

1 Answers1