We are on Postgres 9.5, and have been running a daily vacuum analyze on the
entire database since 8.2
The data has grown exponentially since, and we are seeing that queries are
now being significantly affected while the vacuum analyze runs. The query
database is a Slony slave.
So the question is, is this typical behavior and should we still be running
a daily vacuum analyze on the database?
Thanks!
RV
--
View this message in context: http://www.postgresql-archive.org/vacuum-analyze-affecting-query-performance-tp5970681.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.