Re: How to analyze a slowdown in 9.3.5?

Поиск
Список
Период
Сортировка
От Michael Nolan
Тема Re: How to analyze a slowdown in 9.3.5?
Дата
Msg-id CAOzAquK=0L94mHO-LbzmereTYGn9SC_1pXe_VCPaGc4+ViPBSg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How to analyze a slowdown in 9.3.5?  (Melvin Davidson <melvin6925@gmail.com>)
Ответы Re: How to analyze a slowdown in 9.3.5?  (Melvin Davidson <melvin6925@gmail.com>)
Re: How to analyze a slowdown in 9.3.5?  (Joe Van Dyk <joe@tanga.com>)
Список pgsql-general


On Sat, Jan 10, 2015 at 8:54 PM, Melvin Davidson <melvin6925@gmail.com> wrote:
Just curious. Have you checked that the tables are being vacuum/analyzed periodically and that the statistics are up to date? Try running the following query to verify:


A vacuum analyze runs every night and there would not have been many inserts or updates to the tables used by the lookup function since the latest vacuum analyze.  I think I may have even done a vacuum analyze on the two largest tables after the first DB shutdown.   
--
Mike Nolan

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

Предыдущее
От: Ravi Kiran
Дата:
Сообщение: Hash Function
Следующее
От: Melvin Davidson
Дата:
Сообщение: Re: How to analyze a slowdown in 9.3.5?