Re: Intermittent errors when fetching cursor rows on PostgreSQL 16 - Mailing list pgsql-general

From Enrico Schenone
Subject Re: Intermittent errors when fetching cursor rows on PostgreSQL 16
Date
Msg-id 01abb0f3-8225-480c-9ba6-397018902106@cleistech.it
Whole thread Raw
In response to Re: Intermittent errors when fetching cursor rows on PostgreSQL 16  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Intermittent errors when fetching cursor rows on PostgreSQL 16
List pgsql-general
Il 14/01/25 18:56, Adrian Klaver ha scritto:
>
>
> On 1/13/25 11:56 PM, Enrico Schenone wrote:
>> Il 13/01/25 18:26, Adrian Klaver ha scritto:
>
>
>
>>> In your OP you stated:
>>>
>>> "Production environments can be:
>>>
>>>  * Distinct application server and DB server on distinct subnets (no
>>>     dropped packet detected on firewall, no memory/disk/network failure
>>>     detected by "nmon" tool)
>>>   * Distinct application server and DB server on same subnet (no
>>> firewall)
>>>   * Same server for PostgreSQL and applications
>>> "
>>>
>>> In all those cases are the various servers all running completely
>>> within the providers infrastructure?
>>>
>> No, the second production environment is On Premises at the customer
>> Datacenter under the same vmware hypervisor.en
>
> Which environment did you run the recent prolonged test against?
The first one: Distinct application server and DB server on distinct
subnets.
>
>> I'll make more investigations on second and third environments by
>> increasing the verbosity of both DB and Application logs.
>>
>> *Enrico Schenone*
>> Software Architect
>>
>
*Enrico Schenone*
Software Architect



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Fwd: Lock in postgreSQL
Next
From: Sri Mrudula Attili
Date:
Subject: Re: Postgresql database terminates abruptly with too many open files error