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

>From: Ranier Vilela [email protected] >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. Apparentl

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: [email protected]; [email protected] 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)

> -Original Message- > From: Justin Pryzby > Sent: Tuesday, March 1, 2022 14:27 > To: [email protected] > Cc: [email protected] > Subject: Re: An I/O error occurred while sending to the backend (PG 13.4) > >

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: [email protected] > Cc: [email protected] > 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: Friday, February 25, 2022 08:02 > To: [email protected] > Cc: [email protected] > 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)

>From: Ranier Vilela >Sent: Thursday, February 24, 2022 08:46 >To: Justin Pryzby >Cc: [email protected]; [email protected] >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: [email protected] > Sent: Saturday, December 4, 2021 14:18 > To: Justin Pryzby > Cc: [email protected] > 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)

> -Original Message- > From: Justin Pryzby > Sent: Saturday, December 4, 2021 12:59 > To: [email protected] > Cc: [email protected] > Subject: Re: An I/O error occurred while sending to the backend (PG > 13.4) >

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 of

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 ; [email protected]; Julien Rouhaud Cc: Tom Lane ; Ranier Vilela ; Justin Pryzby ; [email protected] 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

From: tushar Sent: Monday, September 27, 2021 11:50 To: Andrew Dunstan ; [email protected]; Julien Rouhaud Cc: Tom Lane ; Ranier Vilela ; Justin Pryzby ; [email protected] 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 installer

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: [email protected]; Julien Rouhaud > Cc: Tom Lane ; Ranier Vilela ; > Justin Pryzby ; [email protected] > 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: Monday, September 13, 2021 11:36 > To: [email protected]; Julien Rouhaud > Cc: Tom Lane ; Ranier Vilela ; > Justin Pryzby ; pgsql- > [email protected] > Subject:

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: [email protected]; Tom Lane ; Ranier > Vilela ; Justin Pryzby ; > [email protected] > Subject:

RE: Better performance no-throw conversion?

> -Original Message- > From: Andrew Dunstan > Sent: Wednesday, September 8, 2021 13:31 > To: [email protected]; [email protected] > Subject: Re: Better performance no-throw conversion? > > > On 9/8/

RE: Better performance no-throw conversion?

> From: Michael Lewis > Sent: Wednesday, September 8, 2021 13:40 > To: Tom Lane > Cc: [email protected]; [email protected] > Subject: Re: Better performance no-throw conversion? > > On Wed, Sep 8, 2021 at 11:33 AM Tom Lane <mailto:[email protected]

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 REP

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: [email protected]; Julien Rouhaud > Cc: Tom Lane ; Ranier Vilela ; > Justin Pryzby ; pgsql- > [email protected] > Subject: Re:

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 Vis

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

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: [email protected]; Tom Lane ; Ranier > Vilela ; Andrew Dunstan > ; [email protected] > Subject: Re:

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: [email protected] > Cc: Ranier Vilela ; Andrew Dunstan > ; Justin Pryzby ; pgsql- > [email protected] > Subject: Re: Big Performan

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: [email protected] Cc: Tom Lane ; Andrew Dunstan ; Justin Pryzby ; [email protected] 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

>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: Saturday, August 28, 2021 15:51 > To: [email protected] > Cc: Andrew Dunstan ; Justin Pryzby > ; Ranier Vilela ; pgsql- > [email protected] > Subject: Re: Big Performan

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: [email protected] > Cc: Justin Pryzby ; Ranier Vilela > ; [email protected] > 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: [email protected] > Cc: Justin Pryzby ; Ranier Vilela > ; [email protected] > 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: [email protected]; Justin Pryzby ; > Ranier Vilela > Cc: Tom Lane ; [email protected] > Subject: Re: Big Performance drop

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: [email protected] > Sent: Sunday, August 22, 2021 23:23 > To: Justin Pryzby ; Ranier Vilela > > Cc: Tom Lane ; [email protected] &

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: [email protected]; Tom Lane ; pgsql- > [email protected] > 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: Sunday, August 22, 2021 17:27 > To: Tom Lane ; [email protected] > Cc: Justin Pryzby ; Ranier Vilela > ; [email protected] > Subject: Re: Big Performance drop

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: [email protected] > Cc: Justin Pryzby ; Ranier Vilela > ; [email protected] > Subject: Re: Big Performance drop of Exceptions

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

> -Original Message- > From: [email protected] > Sent: Sunday, August 22, 2021 15:29 > To: Tom Lane > Cc: Justin Pryzby ; Ranier Vilela > ; [email protected] > 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: [email protected] > Cc: Justin Pryzby ; Ranier Vilela > ; [email protected] > Subject: Re: Big Performance drop of Exceptions

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

> -Original Message- > From: [email protected] > Sent: Sunday, August 22, 2021 14:37 > To: Tom Lane ; Justin Pryzby > > Cc: Ranier Vilela ; pgsql- > [email protected] > Subject: RE: Big Performance drop of Exceptio

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 ; [email protected]; > [email protected] > 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: [email protected]; Tom Lane ; pgsql- > [email protected] > Subject: Re: Big Performance drop of Exceptions

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

> -Original Message- > From: [email protected] > Sent: Saturday, August 21, 2021 19:02 > To: Justin Pryzby > Cc: Tom Lane ; [email protected] > 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: [email protected] > Cc: Tom Lane ; [email protected] > 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 15:20 > To: Tom Lane > Cc: [email protected]; [email protected] > 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: Tom Lane > Sent: Saturday, August 21, 2021 14:05 > To: Mladen Gogala > Cc: [email protected] > Subject: Re: Big Performance drop of Exceptions in UDFs between V11.2 > and 13.4 > > Mladen Gogala write

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: [email protected] Cc: [email protected] Subject: Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 "[email protected]" writes: > OK... I apologize

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

t? * Between 11.2 and 13.4, the no-exceptions scenario "b" performs 30x slower (26.6s vs 774.1s). Thank you! Laurent Hasson. From: [email protected] Sent: Saturday, August 21, 2021 03:57 To: [email protected] Subject: Big Performance drop of Exceptions in

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

uot;PAIN FREQUENCY","PAIN INTERVENTIONS","PAIN QUALITY","PERIPHERAL TISSUE EDEMA","PERIPHERAL TISSUE INDURATION","REASON MEASUREMENTS NOT TAKEN","RESPONSE TO PAIN INTERVENTIONS",SHAPE,"SIGNS AND SYMPTOMS OF INFECTION","SKI

RE: Big performance slowdown from 11.2 to 13.3

-Original Message- From: Tom Lane Sent: Tuesday, July 27, 2021 23:31 To: [email protected] Cc: Peter Geoghegan ; David Rowley ; Justin Pryzby ; [email protected] Subject: Re: Big performance slowdown from 11.2 to 13.3 I wrote: > Yeah, I wouldn't sweat

RE: Big performance slowdown from 11.2 to 13.3

er 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: [email protected] Cc: Peter Geoghegan ; David Rowley ; Justin Pryzby ; pgsql-performa...@post

RE: Big performance slowdown from 11.2 to 13.3

-Original Message- From: Tom Lane Sent: Sunday, July 25, 2021 14:08 To: [email protected] Cc: Peter Geoghegan ; David Rowley ; Justin Pryzby ; [email protected] Subject: Re: Big performance slowdown from 11.2 to 13.3 "[email protected]" writes: &

RE: Big performance slowdown from 11.2 to 13.3

From: Vijaykumar Jain Sent: Friday, July 23, 2021 10:45 To: [email protected] Cc: Justin Pryzby ; [email protected] Subject: Re: Big performance slowdown from 11.2 to 13.3 On Fri, 23 Jul 2021 at 03:06, [email protected]<mailto:[email protected]> ma

RE: Big performance slowdown from 11.2 to 13.3

unlock this 2GB limit. From: Vijaykumar Jain Sent: Thursday, July 22, 2021 16:32 To: [email protected] Cc: Justin Pryzby ; [email protected] 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: Peter Geoghegan Sent: Thursday, July 22, 2021 13:36 To: [email protected] Cc: Justin Pryzby ; Tom Lane ; David Rowley ; [email protected] 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: Justin Pryzby Sent: Thursday, July 22, 2021 13:29 To: [email protected] Cc: Tom Lane ; David Rowley ; Peter Geoghegan ; [email protected] 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

-Original Message- From: Tom Lane Sent: Thursday, July 22, 2021 12:42 To: Peter Geoghegan Cc: David Rowley ; [email protected]; Justin Pryzby ; [email protected] 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: Justin Pryzby Sent: Thursday, July 22, 2021 12:36 To: [email protected] Cc: Tom Lane ; David Rowley ; Peter Geoghegan ; [email protected] Subject: Re: Big performance slowdown from 11.2 to 13.3 On Thu, Jul 22, 2021 at 04:30:00PM +, l

RE: Big performance slowdown from 11.2 to 13.3

IZE(CM)/LOCATION - 9 - 12 O''CLOCK","WIDTH (CM)","WOUND PAIN LEVEL, WHERE 0 = \"NO PAIN\" AND 10 = \"WORST POSSIBLE PAIN\""}'::text[])) Rows Removed by Filter: 171680 Buffers: shared read=169851 Settings: effective_cache

RE: Big performance slowdown from 11.2 to 13.3

-Original Message- From: Justin Pryzby Sent: Thursday, July 22, 2021 12:23 To: [email protected] Cc: Tom Lane ; David Rowley ; Peter Geoghegan ; [email protected] 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: David Rowley Sent: Thursday, July 22, 2021 12:18 To: Peter Geoghegan Cc: Tom Lane ; Jeff Davis ; [email protected]; Justin Pryzby ; [email protected] 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: Peter Geoghegan Sent: Thursday, July 22, 2021 12:14 To: Tom Lane Cc: Jeff Davis ; [email protected]; David Rowley ; Justin Pryzby ; [email protected] 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: Tom Lane Sent: Thursday, July 22, 2021 11:57 To: [email protected] Cc: David Rowley ; Peter Geoghegan ; Justin Pryzby ; [email protected] 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

-Original Message- From: [email protected] Sent: Thursday, July 22, 2021 09:37 To: David Rowley Cc: Tom Lane ; Peter Geoghegan ; Justin Pryzby ; [email protected] 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: [email protected] Cc: Tom Lane ; Peter Geoghegan ; Justin Pryzby ; [email protected] 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: [email protected] Sent: Wednesday, July 21, 2021 19:46 To: Tom Lane Cc: Peter Geoghegan ; Justin Pryzby ; [email protected] 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

-Original Message- From: Tom Lane Sent: Wednesday, July 21, 2021 19:43 To: [email protected] Cc: Peter Geoghegan ; Justin Pryzby ; [email protected] Subject: Re: Big performance slowdown from 11.2 to 13.3 "[email protected]" writes: >

RE: Big performance slowdown from 11.2 to 13.3

-Original Message- From: Tom Lane Sent: Wednesday, July 21, 2021 19:36 To: [email protected] Cc: Justin Pryzby ; [email protected] Subject: Re: Big performance slowdown from 11.2 to 13.3 "[email protected]" writes: > My apologies... I thought

RE: Big performance slowdown from 11.2 to 13.3

-Original Message- From: Peter Geoghegan Sent: Wednesday, July 21, 2021 19:34 To: [email protected] Cc: Justin Pryzby ; [email protected] Subject: Re: Big performance slowdown from 11.2 to 13.3 On Wed, Jul 21, 2021 at 4:19 PM [email protected] wrote: >

RE: Big performance slowdown from 11.2 to 13.3

From: Michael Lewis Sent: Wednesday, July 21, 2021 18:12 To: [email protected] Cc: [email protected] 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

RE: Big performance slowdown from 11.2 to 13.3

-Original Message- From: Justin Pryzby Sent: Wednesday, July 21, 2021 15:15 To: [email protected] Cc: [email protected] Subject: Re: Big performance slowdown from 11.2 to 13.3 On Wed, Jul 21, 2021 at 06:50:58PM +, [email protected] wrote: > The plans

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 siz

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

From: Tom Lane Sent: Friday, January 25, 2019 3:04:37 PM To: [email protected] Cc: [email protected] Subject: Re: Zero throughput on a query on a very large table. "[email protected]" writes: > Second, here is what i found and what messed us up. >

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

here? Thank you, Laurent. From: [email protected] Sent: Friday, January 25, 2019 2:06:54 PM To: Tom Lane Cc: [email protected] Subject: Re: Zero throughput on a query on a very large table. OK... I think we may have cracked this. First, d

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

ery 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-hass

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: [email protected] Cc: pgsql-performa...

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

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: [email protected] Cc: pgsql-performa...@postgresql.

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

m_line_num) "i_outprev_ptclaim" btree (desy_sort_key, claim_no) So looks like the indices are file. I am pursuing some of the other recommendations you suggested before. Thank you, Laurent. From: David Rowley Sent: Friday, January 25, 2019 1:55:31 AM To: Tom L

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

(a few secs). ____ From: Tom Lane Sent: Friday, January 25, 2019 1:24:45 AM To: [email protected] Cc: [email protected] Subject: Re: Zero throughput on a query on a very large table. "[email protected]" writes: > Query: >

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

> -Original Message- > From: Andreas Kretschmer > Sent: Friday, January 25, 2019 00:55 > To: [email protected] > Subject: Re: Zero throughput on a query on a very large table. > > > > Am 25.01.19 um 06:20 schrieb [email protected]

Zero throughput on a query on a very large table.

Hello, We have been stuck for the past week on a query that simply won’t “execute”. We have a table with 1.2B rows that took around 14h to load, but a simple select takes forever and after 10h, no records are coming through still. Environment: - Table tmp_outpatient_rev with 41 VARCHA

RE: Updating large tables without dead tuples

> -Original Message- > From: Vik Fearing [mailto:[email protected]] > Sent: Friday, March 02, 2018 20:56 > To: [email protected]; [email protected] > Cc: Stephen Frost > Subject: Re: Updating large tables without dead tuples >

RE: Updating large tables without dead tuples

> -Original Message- > From: Stephen Frost [mailto:[email protected]] > Sent: Friday, February 23, 2018 19:10 > To: [email protected] > Cc: [email protected] > Subject: Re: Updating large tables without dead tuples > > Greetings, >

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 up