Bill Moran wrote:
>
> The OP did mention that he's using autovac, which will take care of
> both vacuum and analyze for him. However, he didn't provide his
> autovac config, and it happens at times that the defaults are not
> aggressive enough to keep a table well-maintained.
>
Here are my autovac configuration parameters. I played around with them to
make autovac work frequently.
#autovacuum = on
log_autovacuum_min_duration = 0
autovacuum_max_workers = 10
autovacuum_naptime = 10s
autovacuum_vacuum_threshold = 2000
autovacuum_analyze_threshold = 2000
autovacuum_vacuum_scale_factor = 0.0005
autovacuum_analyze_scale_factor = 0.0005
#autovacuum_freeze_max_age = 200000000
#autovacuum_vacuum_cost_delay = 20
--
View this message in context:
http://www.nabble.com/query-is-taking-longer-time-after-a-while-tp25661219p25675635.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
