Hi,
Another point to verify is idle_in_transaction_session_timeout
What is the value of this parameter?
Regards
Michel SALAIS
De : Luiz Felipph
Envoyé : lundi 7 mars 2022 22:07
À : Tomas Vondra
Cc : Pgsql Performance
Objet : Re: Optimal configuration for server
Hi Tomas
Could you enable the connections logs and share the results when it is
reproduced, please?
It generally shows the error code and message
So, you can double-confirm if it is because of KeepAlive configuration or
something else
--
Moisés López Calderón
Mobile: (+521) 477-752-22-30
Twitter: @moylo
On Mon, Mar 07, 2022 at 08:51:24AM -0300, Luiz Felipph wrote:
> My current problem:
>
> under heavyload, i'm getting "connection closed" on the application
> level(java-jdbc, jboss ds)
Could you check whether the server is crashing ?
If you run "ps -fu postgres", you can compare the start time (
Em seg., 7 de mar. de 2022 às 18:10, Luiz Felipph
escreveu:
> Hi Tomas,
>
> Thank you for your reply!
>
> Thomas,
>
>> You need to monitor shared buffers cache hit rate (from pg_stat_database
>> view) - if that's low, increase shared buffers. Then monitor and tune
>> slow queries - if a slow quer
Hi Tomas,
Thank you for your reply!
Thomas,
> You need to monitor shared buffers cache hit rate (from pg_stat_database
> view) - if that's low, increase shared buffers. Then monitor and tune
> slow queries - if a slow query benefits from higher work_mem values, do
> increase that value. It's non
On 3/7/22 12:51, Luiz Felipph wrote:
> Hi everybody!
>
> I have a big application running on premise. One of my main database
> servers has the following configuration:
>
> 72 CPUs(2 chips, 18 physical cores per chip, 2 threads) Xeon Gold 6240
> 1TB of ram or 786GB (5 servers at all)
> A huge
Em seg., 7 de mar. de 2022 às 14:18, Luiz Felipph
escreveu:
> Greatings Ranieri,
>
> Server logs I need ask to someone to get it
>
> Redhat EL 7
>
> Postgres 12
>
> Humm.. I will find out were I should put keep Alive setting
>
Are you using nested connections?
regards,
Ranier Vilela
>
Greatings Ranieri,
Server logs I need ask to someone to get it
Redhat EL 7
Postgres 12
Humm.. I will find out were I should put keep Alive setting
Em seg., 7 de mar. de 2022 13:51, Ranier Vilela
escreveu:
> Em seg., 7 de mar. de 2022 às 08:54, Luiz Felipph
> escreveu:
>
>> Hi everybody!
Em seg., 7 de mar. de 2022 às 08:54, Luiz Felipph
escreveu:
> Hi everybody!
>
> I have a big application running on premise. One of my main database
> servers has the following configuration:
>
> 72 CPUs(2 chips, 18 physical cores per chip, 2 threads) Xeon Gold 6240
> 1TB of ram or 786GB (5 serve
Hi everybody!
I have a big application running on premise. One of my main database
servers has the following configuration:
72 CPUs(2 chips, 18 physical cores per chip, 2 threads) Xeon Gold 6240
1TB of ram or 786GB (5 servers at all)
A huge storage( I don't know for sure what kind is, but is very
10 matches
Mail list logo
