Carlos Henrique Reimer <carlos.rei...@opendb.com.br> wrote: > I`m trying to figure out why a query runs in 755ms in the morning > and 20054ms (26x) in the evening.
I would make autovacuum settings much more aggressive, or schedule periodic VACUUM and/or ANALYZE runs during the day. > database size is 40GB and memory 64GB If you haven't already done so, I would use settings something like this in postgresql.conf: effective_cache_size = 32GB seq_page_cost = 0.1 random_page_cost = 0.1 cpu_tuple_cost = 0.03 -- Kevin Grittner EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
