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 someti

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 m

Re: Postgresql server gets stuck at low load

2020-06-09 Thread Krzysztof Olszewski
advice I'll check the results from pg_stat_statements. pt., 5 cze 2020 o 13:16 napisał(a): > > *De: *"Krzysztof Olszewski" > *Para: *[email protected] > *Enviadas: *Sexta-feira, 5 de junho de 2020 7:07:02 > *Assunto: *Postgresql server get

Postgresql server gets stuck at low load

2020-06-05 Thread Krzysztof Olszewski
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 it happens then there are problems with connect to database and even i