Re: conf of postgres.cof

If you are receiving timeouts you should first check your indexes to
make sure they are set up correctly. If you believe they are then
consider creating a pg/sql script that can accept parameters, process
the data and then return just the result data to the client.

You didn't mention which client you are talking about. That may be
helpful in troubleshooting the issue.

*/Patrick Headley/*
Linx Consulting, Inc.
(303) 916-5522
pheadley(at)linxco-inc(dot)com
www.linxco-inc.com

On 6/12/21 12:31 AM, Sachin Kumar wrote:
> Hi Experts,
>
> I am using Postgres 12 and 13 in two f my server and getting timeout
> issue in frontend. after enabling the slow query i found the error.
>
> " LOG:  could not receive data from client: An existing connection was
> forcibly closed by the remote host. "
>
> and during troubleshooting, i found that it can be resolved by Setting
> both |statement_timeout| and |idle_in_transaction_session_timeout |
> But i don't know the correct way to use it.
>
> One server has 8GB RAM and other one have 32 GB RAM.
>
> Kindly help me configuring these settings.
>
> Thanks in Advance
> Sachin
>
> --
>
> Best Regards,
> Sachin Kumar