PostgresSQL 9.5.21 very slow to connect and perform basic queries

From: bruno da silva <brunogiovs(at)gmail(dot)com>
To: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: PostgresSQL 9.5.21 very slow to connect and perform basic queries
Date: 2022-07-21 18:37:35
Message-ID: CAB+Nuk93fL1Q9eLOCotvLP07g7RAv4vbdrkm0cVQohDVMpAb9A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Justin Pryzby 2022-07-21 19:33:27 Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries
Previous Message Rory Campbell-Lange 2022-07-18 14:23:13 Re: data consolidation: logical replication design considerations