[PERFORM] vacuum analyze affecting query performance

Поиск
Список
Период
Сортировка
От rverghese
Тема [PERFORM] vacuum analyze affecting query performance
Дата
Msg-id 1499707507430-5970681.post@n3.nabble.com
обсуждение исходный текст
Ответы Re: [PERFORM] vacuum analyze affecting query performance  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Список pgsql-performance
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.


В списке pgsql-performance по дате отправления:

Предыдущее
От: Charles Nadeau
Дата:
Сообщение: Re: [PERFORM] Very poor read performance, query independent
Следующее
От: Igor Neyman
Дата:
Сообщение: Re: [PERFORM] Very poor read performance, query independent