Re: Intermittent errors when fetching cursor rows on PostgreSQL 16

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