Updating large tables without dead tuples

Hello I work with a large and wide table (about 300 million rows, about 50 columns), and from time to time, we get business requirements to make some modifications. But sometimes, it's just some plain mistake. This has happened to us a few weeks ago where someone made a mistake and we had to

RE: Zero throughput on a query on a very large table.

> -Original Message- > From: Andreas Kretschmer > Sent: Friday, January 25, 2019 00:55 > To: pgsql-performance@lists.postgresql.org > Subject: Re: Zero throughput on a query on a very large table. > > > > Am 25.01.19 um 06:20 schrieb l...@laurent-hasson.com

Re: Zero throughput on a query on a very large table.

_ From: Tom Lane Sent: Friday, January 25, 2019 1:24:45 AM To: l...@laurent-hasson.com Cc: pgsql-performa...@postgresql.org Subject: Re: Zero throughput on a query on a very large table. "l...@laurent-hasson.com" writes: > Query: > select * from tmp_outpatient_rev o

Re: Zero throughput on a query on a very large table.

Sorry :) When i look at the "SQL" tab in PGAdmin when i select the index in the schema browser. But you are right that /d doesn't show that. From: Tom Lane Sent: Friday, January 25, 2019 1:34:01 PM To: l...@laurent-hasson.com Cc: pgsql-performa...@post

Re: Zero throughput on a query on a very large table.

that Postgres now gives when looking at the indices. Collation for the DB is "en_US.UTF-8" and that's used for the defaults i suspect? From: Tom Lane Sent: Friday, January 25, 2019 1:10:55 PM To: l...@laurent-hasson.com Cc: pgsql-performa...@postgresql.org S

Re: Zero throughput on a query on a very large table.

the schema browser. But you are right that /d doesn't show that. From: Tom Lane Sent: Friday, January 25, 2019 1:34:01 PM To: l...@laurent-hasson.com Cc: pgsql-performa...@postgresql.org Subject: Re: Zero throughput on a query on a very large table. "l...@lauren

Re: Zero throughput on a query on a very large table.

? Thank you, Laurent. From: l...@laurent-hasson.com Sent: Friday, January 25, 2019 2:06:54 PM To: Tom Lane Cc: pgsql-performa...@postgresql.org Subject: Re: Zero throughput on a query on a very large table. OK... I think we may have cracked this. First, do you

RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4

> -Original Message- > From: Tom Lane > Sent: Sunday, August 22, 2021 13:51 > To: Justin Pryzby > Cc: Ranier Vilela ; l...@laurent-hasson.com; > pgsql-performa...@postgresql.org > Subject: Re: Big Performance drop of Exceptions

RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4

> -Original Message- > From: l...@laurent-hasson.com > Sent: Sunday, August 22, 2021 14:37 > To: Tom Lane ; Justin Pryzby > > Cc: Ranier Vilela ; pgsql- > performa...@postgresql.org > Subject: RE: Big Performance drop of Exceptio

RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4

> -Original Message- > From: Andrew Dunstan > Sent: Sunday, August 22, 2021 17:27 > To: Tom Lane ; l...@laurent-hasson.com > Cc: Justin Pryzby ; Ranier Vilela > ; pgsql-performa...@postgresql.org > Subject: Re: Big Performance drop

RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4

> -Original Message- > From: Justin Pryzby > Sent: Sunday, August 22, 2021 20:43 > To: Ranier Vilela > Cc: l...@laurent-hasson.com; Tom Lane ; pgsql- > performa...@postgresql.org > Subject: Re: Big Performance drop of Exceptions

RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4

> -Original Message- > From: l...@laurent-hasson.com > Sent: Sunday, August 22, 2021 15:29 > To: Tom Lane > Cc: Justin Pryzby ; Ranier Vilela > ; pgsql-performa...@postgresql.org > Subject: RE: Big Performance drop of Exceptions

RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4

> -Original Message- > From: Tom Lane > Sent: Sunday, August 22, 2021 16:11 > To: l...@laurent-hasson.com > Cc: Justin Pryzby ; Ranier Vilela > ; pgsql-performa...@postgresql.org > Subject: Re: Big Performance drop of Exceptions

RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4

> -Original Message- > From: Tom Lane > Sent: Sunday, August 22, 2021 15:24 > To: l...@laurent-hasson.com > Cc: Justin Pryzby ; Ranier Vilela > ; pgsql-performa...@postgresql.org > Subject: Re: Big Performance drop of Exceptions

RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4

> -Original Message- > From: Justin Pryzby > Sent: Sunday, August 22, 2021 11:48 > To: Ranier Vilela > Cc: l...@laurent-hasson.com; Tom Lane ; pgsql- > performa...@postgresql.org > Subject: Re: Big Performance drop of Exceptions

RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4

> -Original Message- > From: Andrew Dunstan > Sent: Thursday, August 26, 2021 12:39 > To: l...@laurent-hasson.com; Justin Pryzby ; > Ranier Vilela > Cc: Tom Lane ; pgsql-performa...@postgresql.org > Subject: Re: Big Performance drop

RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4

> -Original Message- > From: Andrew Dunstan > Sent: Tuesday, August 31, 2021 09:40 > To: l...@laurent-hasson.com; Julien Rouhaud > Cc: Tom Lane ; Ranier Vilela ; > Justin Pryzby ; pgsql- > performa...@postgresql.org > Subject:

RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4

> -Original Message- > From: Tom Lane > Sent: Friday, August 27, 2021 13:43 > To: l...@laurent-hasson.com > Cc: Justin Pryzby ; Ranier Vilela > ; pgsql-performa...@postgresql.org > Subject: Re: Big Performance drop of Exceptions

RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4

> -Original Message- > From: Tom Lane > Sent: Friday, August 27, 2021 13:43 > To: l...@laurent-hasson.com > Cc: Justin Pryzby ; Ranier Vilela > ; pgsql-performa...@postgresql.org > Subject: Re: Big Performance drop of Exceptions

RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4

Hello all, Any update on this issue? Thank you! Laurent. > -Original Message- > From: l...@laurent-hasson.com > Sent: Sunday, August 22, 2021 23:23 > To: Justin Pryzby ; Ranier Vilela > > Cc: Tom Lane ; pgsql-performa...@postgresql.org &

RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4

> -Original Message- > From: Tom Lane > Sent: Saturday, August 28, 2021 15:51 > To: l...@laurent-hasson.com > Cc: Andrew Dunstan ; Justin Pryzby > ; Ranier Vilela ; pgsql- > performa...@postgresql.org > Subject: Re: Big Perfor

RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4

>Sure, there's no question that message translation will have *some* cost. >But on my machine it is an incremental tens-of-percent kind of cost, >and that is the result you're getting as well.  So it's not very clear >where these factor-of-several-hundred differences are coming from. >A hypothesis

RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4

> -Original Message- > From: Tom Lane > Sent: Sunday, August 29, 2021 12:19 > To: l...@laurent-hasson.com > Cc: Ranier Vilela ; Andrew Dunstan > ; Justin Pryzby ; pgsql- > performa...@postgresql.org > Subject: Re: Big Perfor

RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4

From: Ranier Vilela Sent: Sunday, August 29, 2021 14:20 To: l...@laurent-hasson.com Cc: Tom Lane ; Andrew Dunstan ; Justin Pryzby ; pgsql-performa...@postgresql.org Subject: Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Em dom., 29 de ago. de 2021 às 13:03, mailto:l

RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 (workarounds)

> -Original Message- > From: Justin Pryzby > Sent: Sunday, August 29, 2021 23:17 > To: Pavel Stehule > Cc: l...@laurent-hasson.com; Tom Lane ; Ranier > Vilela ; Andrew Dunstan > ; pgsql-performa...@postgresql.org > Subject:

RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4

> I see on https://www.postgresql.org/download/ that there is a different > installer from 2ndQuadrant. I am going to try that one and see what I > come up with. Are there any other "standard" distros of Postgres that I > could try out? > > I found out I could download

RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4

etween 11.2 and 13.4, the no-exceptions scenario "b" performs 30x slower (26.6s vs 774.1s). Thank you! Laurent Hasson. From: l...@laurent-hasson.com Sent: Saturday, August 21, 2021 03:57 To: pgsql-performa...@postgresql.org Subject: Big Performance drop of Exceptions in UDFs be

Big Performance drop of Exceptions in UDFs between V11.2 and 13.4

Hello all, I think I have identified a major performance issue between V11.2 and 13.4 with respect to exception handling in UDFs. I have the following simplified query that pivots data and makes use of a UDF to convert data to a specific type, in this case, float: select "iccqa_iccassmt_fk"

RE: Big performance slowdown from 11.2 to 13.3

","RESPONSE TO PAIN INTERVENTIONS",SHAPE,"SIGNS AND SYMPTOMS OF INFECTION","SKIN COLOR SURROUNDING WOUND",STATE,"SURFACE AREA (SQ CM)","TOTAL NECROTIC TISSUE ESCHAR","TOTAL NECROTIC TISSUE SLOUGH",TUNNELING,"TUNNELING SIZE(CM)/LOCAT

RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4

-Original Message- From: Tom Lane Sent: Saturday, August 21, 2021 11:05 To: l...@laurent-hasson.com Cc: pgsql-performa...@postgresql.org Subject: Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 "l...@laurent-hasson.com" writes: > OK... I apologize

RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4

> -Original Message- > From: Tom Lane > Sent: Saturday, August 21, 2021 14:05 > To: Mladen Gogala > Cc: pgsql-performance@lists.postgresql.org > Subject: Re: Big Performance drop of Exceptions in UDFs between V11.2 > and 13.4 > > Mladen Gogala

RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4

> -Original Message- > From: Justin Pryzby > Sent: Saturday, August 21, 2021 15:20 > To: Tom Lane > Cc: l...@laurent-hasson.com; pgsql-performa...@postgresql.org > Subject: Re: Big Performance drop of Exceptions in UDFs between V1

RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4

> -Original Message- > From: Justin Pryzby > Sent: Saturday, August 21, 2021 18:17 > To: l...@laurent-hasson.com > Cc: Tom Lane ; pgsql-performa...@postgresql.org > Subject: Re: Big Performance drop of Exceptions in UDFs between V1

RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4

> -Original Message- > From: l...@laurent-hasson.com > Sent: Saturday, August 21, 2021 19:02 > To: Justin Pryzby > Cc: Tom Lane ; pgsql-performa...@postgresql.org > Subject: RE: Big Performance drop of Exceptions in UDFs between V1

RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4

> -Original Message- > From: Andrew Dunstan > Sent: Thursday, September 2, 2021 13:00 > To: Julien Rouhaud > Cc: l...@laurent-hasson.com; Tom Lane ; Ranier > Vilela ; Justin Pryzby ; > pgsql-performa...@postgresql.org > Subject:

RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4

> -Original Message- > From: Andrew Dunstan > Sent: Monday, September 13, 2021 11:36 > To: l...@laurent-hasson.com; Julien Rouhaud > Cc: Tom Lane ; Ranier Vilela ; > Justin Pryzby ; pgsql- > performa...@postgresql.org > Subject:

Better performance no-throw conversion?

Hello, Some databases such as SQLServer (try_cast) or BigQuery (safe.cast) offer not-throw conversion. In general, these tend to perform better than custom UDFs that catch exceptions and are also simpler to use. For example, in Postgres, I have a function that does the following: CREATE OR

RE: Better performance no-throw conversion?

> From: Michael Lewis > Sent: Wednesday, September 8, 2021 13:40 > To: Tom Lane > Cc: l...@laurent-hasson.com; pgsql-performa...@postgresql.org > Subject: Re: Better performance no-throw conversion? > > On Wed, Sep 8, 2021 at 11:33 AM Tom Lane <mailto:t...@sss.pgh.p

RE: Better performance no-throw conversion?

> -Original Message- > From: Andrew Dunstan > Sent: Wednesday, September 8, 2021 13:31 > To: l...@laurent-hasson.com; pgsql-performa...@postgresql.org > Subject: Re: Better performance no-throw conversion? > > > On 9/8/

RE: Big performance slowdown from 11.2 to 13.3

-Original Message- From: Tom Lane Sent: Tuesday, July 27, 2021 23:31 To: l...@laurent-hasson.com Cc: Peter Geoghegan ; David Rowley ; Justin Pryzby ; pgsql-performa...@postgresql.org Subject: Re: Big performance slowdown from 11.2 to 13.3 I wrote: > Yeah, I wouldn't sweat o

RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4

> -Original Message- > From: Andrew Dunstan > Sent: Friday, September 24, 2021 16:57 > To: l...@laurent-hasson.com; Julien Rouhaud > Cc: Tom Lane ; Ranier Vilela ; > Justin Pryzby ; pgsql-performa...@postgresql.org > Subject: Re: Big Performance drop of Exceptions

RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4

From: tushar Sent: Monday, September 27, 2021 11:50 To: Andrew Dunstan ; l...@laurent-hasson.com; Julien Rouhaud Cc: Tom Lane ; Ranier Vilela ; Justin Pryzby ; pgsql-performa...@postgresql.org Subject: Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 On 9/27/21 6:55 PM

RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4

> > EDB has now published new installers for versions later than release > > 11, containing Postgres built with an earlier version of gettext that > > does not exhibit the problem. Please verify that these fix the issue. > > If you already have Postgres installed from our

RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4

From: tushar Sent: Monday, September 27, 2021 11:50 To: Andrew Dunstan ; l...@laurent-hasson.com; Julien Rouhaud Cc: Tom Lane ; Ranier Vilela ; Justin Pryzby ; pgsql-performa...@postgresql.org Subject: Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 On 9/27/21 6:55 PM

RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4

> I tried this scenario using edb's 13.3 x64 install: > > postgres=# select version(); >version > > PostgreSQL 13.3, compiled by Visual C++ build 1914, 64-bit > (1 row) >

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

Hello, I hope this email finds you all well! 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 for the past couple of months. I have been getting the error "An I/O error occurred while sending to the backend" quite

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

> -Original Message- > From: Justin Pryzby > Sent: Saturday, December 4, 2021 12:59 > To: l...@laurent-hasson.com > Cc: pgsql-performa...@postgresql.org > Subject: Re: An I/O error occurred while sending to the backend (PG > 13.4) >

Big performance slowdown from 11.2 to 13.3

Hello, We have a data warehouse working on Postgres V11.2. We have a query that is pretty beefy that has been taking under 5mn to run consistently every day for about 2 years as part of a data warehouse ETL process. It's a pivot over 55 values on a table with some 15M rows. The total table

RE: Big performance slowdown from 11.2 to 13.3

-Original Message- From: Peter Geoghegan Sent: Wednesday, July 21, 2021 19:34 To: l...@laurent-hasson.com Cc: Justin Pryzby ; pgsql-performa...@postgresql.org Subject: Re: Big performance slowdown from 11.2 to 13.3 On Wed, Jul 21, 2021 at 4:19 PM l...@laurent-hasson.com wrote

RE: Big performance slowdown from 11.2 to 13.3

-Original Message- From: Tom Lane Sent: Wednesday, July 21, 2021 19:43 To: l...@laurent-hasson.com Cc: Peter Geoghegan ; Justin Pryzby ; pgsql-performa...@postgresql.org Subject: Re: Big performance slowdown from 11.2 to 13.3 "l...@laurent-hasson.com" writes: >

RE: Big performance slowdown from 11.2 to 13.3

-Original Message- From: Justin Pryzby Sent: Wednesday, July 21, 2021 15:15 To: l...@laurent-hasson.com Cc: pgsql-performa...@postgresql.org Subject: Re: Big performance slowdown from 11.2 to 13.3 On Wed, Jul 21, 2021 at 06:50:58PM +, l...@laurent-hasson.com wrote: > The pl

RE: Big performance slowdown from 11.2 to 13.3

From: Michael Lewis Sent: Wednesday, July 21, 2021 18:12 To: l...@laurent-hasson.com Cc: pgsql-performa...@postgresql.org Subject: Re: Big performance slowdown from 11.2 to 13.3 I'm not seeing the valueof the CTE. Why not access assessmenticcqa_raw directly in the main query and only do GROUP

RE: Big performance slowdown from 11.2 to 13.3

-Original Message- From: Tom Lane Sent: Wednesday, July 21, 2021 19:36 To: l...@laurent-hasson.com Cc: Justin Pryzby ; pgsql-performa...@postgresql.org Subject: Re: Big performance slowdown from 11.2 to 13.3 "l...@laurent-hasson.com" writes: > My apologies... I thought

RE: Big performance slowdown from 11.2 to 13.3

-Original Message- From: l...@laurent-hasson.com Sent: Wednesday, July 21, 2021 19:46 To: Tom Lane Cc: Peter Geoghegan ; Justin Pryzby ; pgsql-performa...@postgresql.org Subject: RE: Big performance slowdown from 11.2 to 13.3 -Original Message- From: Tom Lane Sent

RE: Big performance slowdown from 11.2 to 13.3

will unlock this 2GB limit. From: Vijaykumar Jain Sent: Thursday, July 22, 2021 16:32 To: l...@laurent-hasson.com Cc: Justin Pryzby ; pgsql-performa...@postgresql.org Subject: Re: Big performance slowdown from 11.2 to 13.3 Just asking, I may be completely wrong. is this query parallel safe? can we force

RE: Big performance slowdown from 11.2 to 13.3

-Original Message- From: l...@laurent-hasson.com Sent: Thursday, July 22, 2021 09:37 To: David Rowley Cc: Tom Lane ; Peter Geoghegan ; Justin Pryzby ; pgsql-performa...@postgresql.org Subject: RE: Big performance slowdown from 11.2 to 13.3 OK. Will do another round of testing

RE: Big performance slowdown from 11.2 to 13.3

OK. Will do another round of testing. -Original Message- From: David Rowley Sent: Thursday, July 22, 2021 00:44 To: l...@laurent-hasson.com Cc: Tom Lane ; Peter Geoghegan ; Justin Pryzby ; pgsql-performa...@postgresql.org Subject: Re: Big performance slowdown from 11.2 to 13.3 On Thu

RE: Big performance slowdown from 11.2 to 13.3

-Original Message- From: Justin Pryzby Sent: Thursday, July 22, 2021 12:23 To: l...@laurent-hasson.com Cc: Tom Lane ; David Rowley ; Peter Geoghegan ; pgsql-performa...@postgresql.org Subject: Re: Big performance slowdown from 11.2 to 13.3 On Thu, Jul 22, 2021 at 04:16:34PM +, l

RE: Big performance slowdown from 11.2 to 13.3

-Original Message- From: Peter Geoghegan Sent: Thursday, July 22, 2021 13:36 To: l...@laurent-hasson.com Cc: Justin Pryzby ; Tom Lane ; David Rowley ; pgsql-performa...@postgresql.org Subject: Re: Big performance slowdown from 11.2 to 13.3 On Thu, Jul 22, 2021 at 10:33 AM l

RE: Big performance slowdown from 11.2 to 13.3

-Original Message- From: David Rowley Sent: Thursday, July 22, 2021 12:18 To: Peter Geoghegan Cc: Tom Lane ; Jeff Davis ; l...@laurent-hasson.com; Justin Pryzby ; pgsql-performa...@postgresql.org Subject: Re: Big performance slowdown from 11.2 to 13.3 On Fri, 23 Jul 2021 at 04:14

RE: Big performance slowdown from 11.2 to 13.3

-Original Message- From: Tom Lane Sent: Thursday, July 22, 2021 11:57 To: l...@laurent-hasson.com Cc: David Rowley ; Peter Geoghegan ; Justin Pryzby ; pgsql-performa...@postgresql.org Subject: Re: Big performance slowdown from 11.2 to 13.3 I wrote: > "l...@laurent-ha

RE: Big performance slowdown from 11.2 to 13.3

D PAIN LEVEL, WHERE 0 = \"NO PAIN\" AND 10 = \"WORST POSSIBLE PAIN\""}'::text[])) Rows Removed by Filter: 171680 Buffers: shared read=169851 Settings: effective_cache_size = '52GB', from_collapse_limit = '24', hash_mem_multiplier = '16', jit = 'off', jit_

RE: Big performance slowdown from 11.2 to 13.3

-Original Message- From: Tom Lane Sent: Thursday, July 22, 2021 12:42 To: Peter Geoghegan Cc: David Rowley ; l...@laurent-hasson.com; Justin Pryzby ; pgsql-performa...@postgresql.org Subject: Re: Big performance slowdown from 11.2 to 13.3 Peter Geoghegan writes: > On Thu, Jul

RE: Big performance slowdown from 11.2 to 13.3

-Original Message- From: Peter Geoghegan Sent: Thursday, July 22, 2021 12:14 To: Tom Lane Cc: Jeff Davis ; l...@laurent-hasson.com; David Rowley ; Justin Pryzby ; pgsql-performa...@postgresql.org Subject: Re: Big performance slowdown from 11.2 to 13.3 On Thu, Jul 22, 2021 at 8:45 AM

RE: Big performance slowdown from 11.2 to 13.3

-Original Message- From: Justin Pryzby Sent: Thursday, July 22, 2021 13:29 To: l...@laurent-hasson.com Cc: Tom Lane ; David Rowley ; Peter Geoghegan ; pgsql-performa...@postgresql.org Subject: Re: Big performance slowdown from 11.2 to 13.3 On Thu, Jul 22, 2021 at 05:26:26PM +, l

RE: Big performance slowdown from 11.2 to 13.3

From: Vijaykumar Jain Sent: Friday, July 23, 2021 10:45 To: l...@laurent-hasson.com Cc: Justin Pryzby ; pgsql-performa...@postgresql.org Subject: Re: Big performance slowdown from 11.2 to 13.3 On Fri, 23 Jul 2021 at 03:06, l...@laurent-hasson.com<mailto:l...@laurent-hasson.com> ma

RE: Big performance slowdown from 11.2 to 13.3

to 8 and should be OK. This doesn't mean that every query will consume 4GB of memory. Thank you, Laurent. -Original Message- From: Tom Lane Sent: Sunday, July 25, 2021 14:08 To: l...@laurent-hasson.com Cc: Peter Geoghegan ; David Rowley ; Justin Pryzby ; pgsql-performa...@postgresql.org

RE: Big performance slowdown from 11.2 to 13.3

-Original Message- From: Tom Lane Sent: Sunday, July 25, 2021 14:08 To: l...@laurent-hasson.com Cc: Peter Geoghegan ; David Rowley ; Justin Pryzby ; pgsql-performa...@postgresql.org Subject: Re: Big performance slowdown from 11.2 to 13.3 "l...@laurent-hasson.com" writes: &

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

> -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 th

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

>From: Ranier Vilela >Sent: Thursday, February 24, 2022 08:46 >To: Justin Pryzby >Cc: l...@laurent-hasson.com; pgsql-performa...@postgresql.org >Subject: Re: An I/O error occurred while sending to the backend (PG 13.4) > >Em qui., 24 de fev. de 2022 às 09:59, Justin

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

> -Original Message- > From: Justin Pryzby > Sent: Friday, February 25, 2022 08:02 > To: l...@laurent-hasson.com > Cc: pgsql-performa...@postgresql.org > Subject: Re: An I/O error occurred while sending to the backend (PG 13.4) > &g

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

> -Original Message- > From: Justin Pryzby > Sent: Monday, February 28, 2022 17:05 > To: l...@laurent-hasson.com > Cc: pgsql-performa...@postgresql.org > Subject: Re: An I/O error occurred while sending to the backend (PG 13.4) > &g

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

> -Original Message- > From: Justin Pryzby > Sent: Tuesday, March 1, 2022 14:27 > To: l...@laurent-hasson.com > Cc: pgsql-performa...@postgresql.org > Subject: Re: An I/O error occurred while sending to the backend (PG 13.4) > &g

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

and working out with it on some plan. Thank you, Laurent. From: Ranier Vilela Sent: Thursday, March 3, 2022 11:57 To: Justin Pryzby Cc: l...@laurent-hasson.com; pgsql-performa...@postgresql.org Subject: Re: An I/O error occurred while sending to the backend (PG 13.4) Em qui., 3 de mar. de 2022

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

>From: Ranier Vilela ranier...@gmail.com >Sent: Thursday, March 03, 2022 13:22 > > >You are welcome. > >regards, >Ranier Vilela Hello all, After a lot of back and forth, someone in IT informed us that the database VM is under a backup schedule using Veeam.