Re: How to analyze a slowdown in 9.3.5?

Поиск
Список
Период
Сортировка
От Joe Van Dyk
Тема Re: How to analyze a slowdown in 9.3.5?
Дата
Msg-id CACfv+pJhPtk5GeLK0Q_Q9UpBBLDazefnZFJF5XfJONFP8rCNYw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How to analyze a slowdown in 9.3.5?  (Michael Nolan <htfoot@gmail.com>)
Список pgsql-general
Дерево обсуждения
On Sun, Jan 11, 2015 at 8:07 AM, Michael Nolan <htfoot@gmail.com> wrote:


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.    

One thing to check (I ran into this two weeks ago) -- even though vacuums were happening, a query running on a standby machine was preventing the vacuum process from removing the dead rows. You may want to check for bloat or use 'vacuum verbose' to see if there's many dead rows not being cleaned up. 

Joe

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

Предыдущее
От: Bosco Rama
Дата:
Сообщение: Re: Stuck trying to backup large database - best practice?
Следующее
От: Antony Gelberg
Дата:
Сообщение: Re: Stuck trying to backup large database - best practice?