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
