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
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
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
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
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
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
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