> -Original Message-
> From: l...@laurent-hasson.com
> Sent: Saturday, December 4, 2021 14:18
> To: Justin Pryzby
> Cc: pgsql-performa...@postgresql.org
> Subject: RE: An I/O error occurred while sending to the backend (PG 13.4)
>
>
> > -Or
On Thu, Feb 24, 2022 at 12:47:42AM +, l...@laurent-hasson.com wrote:
> On Sat, Dec 04, 2021 at 05:32:10PM +, l...@laurent-hasson.com wrote:
> > I have a data warehouse with a fairly complex ETL process that has
> > been running for years now across PG 9.6, 11.2 and now 13.4 fo
You originally mailed about an error on the client, and now you found
corresponding server logs, which suggests a veritable network issue.
Are the postgres clients and server on the same subnet ? If not, what are the
intermediate routers ? Is there any NAT happening ? Do those devices have any
Hi,
I've experienced a situation where the planner seems to make a very poor
choice with a prepared query after the first five executions. Looking
at the documentation, I think this happens because it switches from a
custom plan to a generic one, and doesn't make a good choice for the
gener
