Re: Intermittent errors when fetching cursor rows on PostgreSQL 16

From: Enrico Schenone <eschenone(at)cleistech(dot)it>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, Enrico Schenone <eschenone(at)cleistech(dot)it>, pgsql-general(at)lists(dot)postgresql(dot)org
Cc: Massimo Catti <mcatti(at)cleistech(dot)it>, Livio Pizzolo <lpizzolo(at)cleistech(dot)it>
Subject: Re: Intermittent errors when fetching cursor rows on PostgreSQL 16
Date: 2025-01-15 07:46:36
Message-ID: 01abb0f3-8225-480c-9ba6-397018902106@cleistech.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sri Mrudula Attili 2025-01-15 11:42:30 Re: Postgresql database terminates abruptly with too many open files error
Previous Message Adrian Klaver 2025-01-14 18:46:19 Re: Fwd: Lock in postgreSQL