Postgres Pro
Downloads
Home   >   mailing lists

PostgresSQL 9.5.21 very slow to connect and perform basic queries - Mailing list pgsql-performance

From bruno da silva
Subject PostgresSQL 9.5.21 very slow to connect and perform basic queries
Date
Msg-id CAB+Nuk93fL1Q9eLOCotvLP07g7RAv4vbdrkm0cVQohDVMpAb9A@mail.gmail.com
Whole thread Raw
Responses 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>)
List pgsql-performance
Tree view
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 by date:

Previous
From: Rory Campbell-Lange
Date:
Subject: Re: data consolidation: logical replication design considerations
Next
From: Justin Pryzby
Date:
Subject: Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries