Re: Postgresql server gets stuck at low load

2020-06-09 Thread Justin Pryzby
On Tue, Jun 09, 2020 at 01:54:21PM +0200, Krzysztof Olszewski wrote: > I had hugepage's off and on, problems still occurs, > thanx for "perf top" suggestion, > pt., 5 cze 2020 o 13:38 Pavel Stehule napisał(a): > > pá 5. 6. 2020 v 12:07 odesílatel Krzysztof Olszewski > > napsal: > > > >> I have

Re: Postgresql server gets stuck at low load

2020-06-09 Thread Krzysztof Olszewski
random_page_cost == 1.1 wt., 9 cze 2020 o 14:01 Avinash Kumar napisał(a): > Hi, > > On Fri, Jun 5, 2020 at 7:07 AM Krzysztof Olszewski > wrote: > >> I have problem with one of my Postgres production server. Server works >> fine almost always, but sometimes without any increase of transactions

Re: Postgresql server gets stuck at low load

2020-06-09 Thread Avinash Kumar
Hi, On Fri, Jun 5, 2020 at 7:07 AM Krzysztof Olszewski wrote: > I have problem with one of my Postgres production server. Server works > fine almost always, but sometimes without any increase of transactions or > statements amount, machine gets stuck. Cores goes up to 100%, load up to > 160%. Wh

Re: Postgresql server gets stuck at low load

2020-06-09 Thread Krzysztof Olszewski
I had hugepage's off and on, problems still occurs, thanx for "perf top" suggestion, Retards Kris pt., 5 cze 2020 o 13:38 Pavel Stehule napisał(a): > > > pá 5. 6. 2020 v 12:07 odesílatel Krzysztof Olszewski > napsal: > >> I have problem with one of my Postgres production server. Server work

Re: Postgresql server gets stuck at low load

2020-06-09 Thread Krzysztof Olszewski
I had log_min_duration_statement set to 0 for a short period, just before stuck and just after, so I have full list of SQL statements, next analyzed in pgBadger, there is no increase of amount of statements, and I can see, all statements are longer processed than before stuck. But following Your ad

Re: Postgresql server gets stuck at low load

2020-06-05 Thread Pavel Stehule
pá 5. 6. 2020 v 12:07 odesílatel Krzysztof Olszewski napsal: > I have problem with one of my Postgres production server. Server works > fine almost always, but sometimes without any increase of transactions or > statements amount, machine gets stuck. Cores goes up to 100%, load up to > 160%. When

Re: Postgresql server gets stuck at low load

2020-06-05 Thread luis . roberto
De: "Krzysztof Olszewski" Para: pgsql-performance@lists.postgresql.org Enviadas: Sexta-feira, 5 de junho de 2020 7:07:02 Assunto: Postgresql server gets stuck at low load BQ_BEGIN I have problem with one of my Postgres production server. Server works fine almost always, but sometime