PostgresSQL 9.5.21 very slow to connect and perform basic queries

Поиск
Список
Период
Сортировка
От bruno da silva
Тема PostgresSQL 9.5.21 very slow to connect and perform basic queries
Дата
Msg-id CAB+Nuk93fL1Q9eLOCotvLP07g7RAv4vbdrkm0cVQohDVMpAb9A@mail.gmail.com
обсуждение исходный текст
Ответы Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries  (Justin Pryzby <pryzby@telsasoft.com>)
Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries  (Andrew Dunstan <andrew@dunslane.net>)
Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries  (bruno da silva <brunogiovs@gmail.com>)
Список pgsql-performance
Дерево обсуждения
Hello.

I'm investigating an issue on a PostgresSql 9.5.21 installation that becomes unusable in an intermittent way. Simple queries like "select now();" could take 20s. commits take 2s. and all gets fixed after an engine restart.

I look into the pg logs and no signs of errors. and checkpoints are always timed. The machine is well provisioned, load isn't too high, and cpu io wait is under 1%.

any suggestions on what I should check more?


Thanks in advance.
--
Bruno da Silva

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

Предыдущее
От: Rory Campbell-Lange
Дата:
Сообщение: Re: data consolidation: logical replication design considerations
Следующее
От: Justin Pryzby
Дата:
Сообщение: Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries