Postgres Pro
Downloads
Home   >   mailing lists

Re: avtovacuum queue - Mailing list pgsql-admin

From Artem Tomyuk
Subject Re: avtovacuum queue
Date
Msg-id CANYYVqJUqffUYd_kCb8bYxpCnhPkzDrOrHk1V=0GXv=aLtSoUA@mail.gmail.com
Whole thread Raw
In response to Re: avtovacuum queue  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: avtovacuum queue  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-admin
Tree view
Hi, Tom, 

thanks for your reply, the problem is that our app use temp tables a lot so the pg_attribute getting "bloated", 
i've noticed that during business hours autovacuum vacuum is not being triggered on pg_attribute, 
but during night time it triggered every two hours, both vacuum and analyze, maybe you know why? 


my autovacuum conf is:

autovacuum_max_workers = 16             # max number of autovacuum subprocesses

                                        # (change requires restart)

autovacuum_naptime = 51min              # time between autovacuum runs

autovacuum_vacuum_threshold = 500       # min number of row updates before

                                        # vacuum

autovacuum_analyze_threshold = 500      # min number of row updates before

                                        # analyze

autovacuum_vacuum_scale_factor = 0.002  # fraction of table size before vacuum

autovacuum_analyze_scale_factor = 0.01  # fraction of table size before analyze


 





2018-04-02 18:18 GMT+03:00 Tom Lane <tgl@sss.pgh.pa.us>:
Artem Tomyuk <admin@leboutique.com> writes:
> Is there any "queue" in postgres where tables that marked to be vacuumed or
> analyzed can be viewed?

No, there's no queue as such.  You can look at the contents of
pg_stat_all_tables, particularly the n_dead_tup and n_mod_since_analyze
columns, to get a sense of which tables are likely to seem highest
priority to the autovacuum code.

                        regards, tom lane

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: avtovacuum queue
Next
From: "David G. Johnston"
Date:
Subject: Re: avtovacuum queue