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
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
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: [email protected]
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 a
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