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

From Adrian Klaver
Subject Re: Intermittent errors when fetching cursor rows on PostgreSQL 16
Date
Msg-id 9dab3561-3b45-4dac-9522-c84192f87d52@aklaver.com
Whole thread Raw
In response to Re: Intermittent errors when fetching cursor rows on PostgreSQL 16  (Enrico Schenone <eschenone@cleistech.it>)
Responses Re: Intermittent errors when fetching cursor rows on PostgreSQL 16
List pgsql-general

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?

> I'll make more investigations on second and third environments by 
> increasing the verbosity of both DB and Application logs.
>
> *Enrico Schenone*
> Software Architect
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Postgresql database terminates abruptly with too many open files error
Next
From: Igor Korot
Date:
Subject: Fwd: Lock in postgreSQL