Re: Gigantic load average spikes

Поиск
Список
Период
Сортировка
От Michel Pelletier
Тема Re: Gigantic load average spikes
Дата
Msg-id CACxu=vKyhWUDsh-xdtaJTr66SaQ7chfyuDFW0RDxyZMEPuMDUg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Gigantic load average spikes  (David Rowley <david.rowley@2ndquadrant.com>)
Ответы Re: Gigantic load average spikes  (rihad <rihad@mail.ru>)
Список pgsql-general


On Sun, Mar 31, 2019 at 10:49 PM David Rowley <david.rowley@2ndquadrant.com> wrote:

Perhaps a bunch of processes waiting on the access exclusive lock on
the materialized view being released?

log_lock_waits might help you if the MV takes more than a second to
refresh, otherwise, you might need to have a look at ungranted locks
in pg_locks and see if the number of locks spikes during the refresh.

I think David's got the right idea here.  Like he said, investigate pg_locks, if it is the refresh materialized view, you can avoid the problem by doing 'REFRESH MATERIALIZED VIEW CONCURRENTLY'.  You will need at least one unique index on the table.


--
 David Rowley                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services


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

Предыдущее
От: Foo Bar
Дата:
Сообщение: Re: WAL Archive Cleanup?
Следующее
От: rihad
Дата:
Сообщение: Re: Gigantic load average spikes