Slow plan choice with prepared query

2022-02-23 Thread Mark Saward
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

Re: An I/O error occurred while sending to the backend (PG 13.4)

2022-02-23 Thread Justin Pryzby
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

Re: An I/O error occurred while sending to the backend (PG 13.4)

2022-02-23 Thread Justin Pryzby
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

RE: An I/O error occurred while sending to the backend (PG 13.4)

2022-02-23 Thread l...@laurent-hasson.com
> -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