Home > mailing lists

Mailing lists [pgsql-performance]

1 July 2021

19:29 Re: slow performance with cursor Ayub Khan
19:32 Re: slow performance with cursor Justin Pryzby
23:25 Re: slow performance with cursor Ayub Khan
23:49 Re: Planning performance problem (67626.278ms) Manuel Weitzman

2 July 2021

12:55 Re: Planning performance problem (67626.278ms) David Rowley
17:30 Re: slow performance with cursor Tomas Vondra

8 July 2021

00:42 Re: hint in determining effective_io_concurrency Merlin Moncure
02:00 ETL - sql orchestrator is stuck when there is not sleep() between queries Allan Barrielle
09:50 Re: hint in determining effective_io_concurrency Luca Ferrari
11:14 Strange execution plan Joel Frid
11:26 Strange execution plan Joel Frid
15:33 Re: ETL - sql orchestrator is stuck when there is not sleep() between queries Justin Pryzby
16:47 Re: ETL - sql orchestrator is stuck when there is not sleep() between queries Imre Samu
16:49 Re: ETL - sql orchestrator is stuck when there is not sleep() between queries Allan Barrielle
16:51 Re: ETL - sql orchestrator is stuck when there is not sleep() between queries Allan Barrielle
17:06 Re: ETL - sql orchestrator is stuck when there is not sleep() between queries Justin Pryzby
17:12 Re: ETL - sql orchestrator is stuck when there is not sleep() between queries Allan Barrielle

9 July 2021

00:01 ERROR: there is no unique or exclusion constraint matching the ON CONFLICT specification Nagaraj Raj
00:13 Re: Strange execution plan Manuel Weitzman
00:19 Re: Strange execution plan Manuel Weitzman
00:22 temporary file log lines MichaelDBA
01:17 Re: Partition column should be part of PK Justin Pryzby
01:28 Re: Partition column should be part of PK Alvaro Herrera
02:12 RE: Partition column should be part of PK Mike Sofen
05:00 Re: Strange execution plan Manuel Weitzman
06:32 Re: Partition column should be part of PK Nagaraj Raj
06:52 Re: Partition column should be part of PK Christophe Pettus

12 July 2021

03:36 Re: Partition column should be part of PK Nagaraj Raj
03:47 Re: Partition column should be part of PK Christophe Pettus
03:57 Re: Partition column should be part of PK David Rowley
09:00 Re: Partition column should be part of PK Thomas Kellerer
12:56 RE: Partition column should be part of PK Michel SALAIS
15:01 Re: temporary file log lines Laurenz Albe
15:13 Re: temporary file log lines MichaelDBA

13 July 2021

10:29 Re: temporary file log lines Guillaume Lelarge
21:01 Re: temporary file log lines Tomas Vondra

17 July 2021

00:27 Linear slow-down while inserting into a table with an ON INSERT trigger ? Tobias Gierke
07:40 Re: Linear slow-down while inserting into a table with an ON INSERT trigger ? Justin Pryzby
09:48 Re: Linear slow-down while inserting into a table with an ON INSERT trigger ? Benjamin Scherrey
10:02 Re: Linear slow-down while inserting into a table with an ON INSERT trigger ? David Rowley
17:33 Re: Linear slow-down while inserting into a table with an ON INSERT trigger ? Tom Lane

18 July 2021

09:52 Re: Linear slow-down while inserting into a table with an ON INSERT trigger ? Ninad Shah
10:19 Re: Linear slow-down while inserting into a table with an ON INSERT trigger ? Tobias Gierke
10:25 Re: Linear slow-down while inserting into a table with an ON INSERT trigger ? Tobias Gierke
10:36 Re: Linear slow-down while inserting into a table with an ON INSERT trigger ? Tobias Gierke

19 July 2021

08:45 Re: Linear slow-down while inserting into a table with an ON INSERT trigger ? Laurenz Albe
13:09 Performance benchmark of PG Manish Lad
14:04 Re: Performance benchmark of PG Laurenz Albe
14:09 Re: Performance benchmark of PG Manish Lad
14:17 Re: Performance benchmark of PG Hüseyin Demir
14:19 Re: Performance benchmark of PG Thomas Kellerer
14:23 Re: Performance benchmark of PG Manish Lad
19:48 Re: Performance benchmark of PG Ninad Shah

20 July 2021

10:56 Re: Performance benchmark of PG Manish Lad

21 July 2021

20:13 Query Performance Dirschel, Steve
21:03 Re: Query Performance Tom Lane
21:50 Big performance slowdown from 11.2 to 13.3 ldh@laurent-hasson.com
22:15 Re: Big performance slowdown from 11.2 to 13.3 Justin Pryzby

22 July 2021

01:12 Re: Big performance slowdown from 11.2 to 13.3 Michael Lewis
02:19 RE: Big performance slowdown from 11.2 to 13.3 ldh@laurent-hasson.com
02:31 RE: Big performance slowdown from 11.2 to 13.3 ldh@laurent-hasson.com
02:33 Re: Big performance slowdown from 11.2 to 13.3 Peter Geoghegan
02:35 Re: Big performance slowdown from 11.2 to 13.3 Tom Lane
02:37 RE: Big performance slowdown from 11.2 to 13.3 ldh@laurent-hasson.com
02:43 Re: Big performance slowdown from 11.2 to 13.3 Tom Lane
02:44 RE: Big performance slowdown from 11.2 to 13.3 ldh@laurent-hasson.com
02:45 RE: Big performance slowdown from 11.2 to 13.3 ldh@laurent-hasson.com
07:37 RE: Big performance slowdown from 11.2 to 13.3 ldh@laurent-hasson.com
07:43 Re: Big performance slowdown from 11.2 to 13.3 David Rowley
14:32 Partitioned table statistics vs autoanalyze Kamil Frydel
15:15 Re: Partitioned table statistics vs autoanalyze Justin Pryzby
16:37 RE: Big performance slowdown from 11.2 to 13.3 ldh@laurent-hasson.com
16:54 Performance Issue on a table Manoj Kumar
17:20 Re: Partitioned table statistics vs autoanalyze Kamil Frydel
18:00 RE: Big performance slowdown from 11.2 to 13.3 ldh@laurent-hasson.com
18:45 Re: Big performance slowdown from 11.2 to 13.3 Tom Lane
18:56 Re: Big performance slowdown from 11.2 to 13.3 Tom Lane
19:04 Re: Big performance slowdown from 11.2 to 13.3 David Rowley
19:14 Re: Big performance slowdown from 11.2 to 13.3 Peter Geoghegan
19:16 RE: Big performance slowdown from 11.2 to 13.3 ldh@laurent-hasson.com
19:17 Re: Big performance slowdown from 11.2 to 13.3 David Rowley
19:18 RE: Big performance slowdown from 11.2 to 13.3 ldh@laurent-hasson.com
19:21 Re: Big performance slowdown from 11.2 to 13.3 Tom Lane
19:22 Re: Big performance slowdown from 11.2 to 13.3 Justin Pryzby
19:24 RE: Big performance slowdown from 11.2 to 13.3 ldh@laurent-hasson.com
19:26 Re: Big performance slowdown from 11.2 to 13.3 Tom Lane
19:30 RE: Big performance slowdown from 11.2 to 13.3 ldh@laurent-hasson.com
19:35 Re: Big performance slowdown from 11.2 to 13.3 Justin Pryzby
19:36 Re: Big performance slowdown from 11.2 to 13.3 Peter Geoghegan
19:41 Re: Big performance slowdown from 11.2 to 13.3 Justin Pryzby
19:42 Re: Big performance slowdown from 11.2 to 13.3 Tom Lane
19:53 Re: Big performance slowdown from 11.2 to 13.3 Peter Geoghegan
19:56 Re: Big performance slowdown from 11.2 to 13.3 Tom Lane
20:04 Re: Big performance slowdown from 11.2 to 13.3 Peter Geoghegan
20:11 Re: Big performance slowdown from 11.2 to 13.3 Tom Lane
20:16 RE: Big performance slowdown from 11.2 to 13.3 ldh@laurent-hasson.com
20:26 RE: Big performance slowdown from 11.2 to 13.3 ldh@laurent-hasson.com
20:26 RE: Big performance slowdown from 11.2 to 13.3 ldh@laurent-hasson.com
20:27 Re: Big performance slowdown from 11.2 to 13.3 Peter Geoghegan
20:28 Re: Big performance slowdown from 11.2 to 13.3 Justin Pryzby
20:33 RE: Big performance slowdown from 11.2 to 13.3 ldh@laurent-hasson.com
20:35 Re: Big performance slowdown from 11.2 to 13.3 Tom Lane
20:36 Re: Big performance slowdown from 11.2 to 13.3 Peter Geoghegan
20:40 RE: Big performance slowdown from 11.2 to 13.3 ldh@laurent-hasson.com
20:41 Re: Big performance slowdown from 11.2 to 13.3 Peter Geoghegan
20:56 Re: Big performance slowdown from 11.2 to 13.3 Ranier Vilela
20:56 Re: Big performance slowdown from 11.2 to 13.3 Alvaro Herrera
23:31 Re: Big performance slowdown from 11.2 to 13.3 Vijaykumar Jain

23 July 2021

00:36 RE: Big performance slowdown from 11.2 to 13.3 ldh@laurent-hasson.com
17:45 Re: Big performance slowdown from 11.2 to 13.3 Vijaykumar Jain
20:17 RE: Big performance slowdown from 11.2 to 13.3 ldh@laurent-hasson.com
21:18 Re: Performance Issue on a table Justin Pryzby

25 July 2021

21:08 Re: Big performance slowdown from 11.2 to 13.3 Tom Lane

26 July 2021

08:12 RE: Big performance slowdown from 11.2 to 13.3 ldh@laurent-hasson.com
16:56 Performance of lateral join Simen Andreas Andreassen Lønsethagen
21:17 Re: Performance of lateral join Justin Pryzby

27 July 2021

12:08 Re: Performance of lateral join Simen Andreas Andreassen Lønsethagen
20:14 Query performance ! kenny a
20:18 Re: Query performance ! Bruce Momjian

28 July 2021

05:27 Re: Performance of lateral join Justin Pryzby
05:57 RE: Big performance slowdown from 11.2 to 13.3 ldh@laurent-hasson.com
06:06 Re: Big performance slowdown from 11.2 to 13.3 David G. Johnston
06:15 Re: Big performance slowdown from 11.2 to 13.3 Tom Lane
06:31 Re: Big performance slowdown from 11.2 to 13.3 Tom Lane
23:12 RE: Big performance slowdown from 11.2 to 13.3 ldh@laurent-hasson.com

29 July 2021

18:10 Re: Query performance ! Justin Pryzby

30 July 2021

10:12 Performance issue with thousands of calls to procedures and functions? Daniel Westermann (DWE)
11:01 Re: Performance issue with thousands of calls to procedures and functions? Imre Samu
11:04 Re: Performance issue with thousands of calls to procedures and functions? Pavel Stehule
11:07 Re: Performance issue with thousands of calls to procedures and functions? Pavel Stehule
11:11 Re: Performance issue with thousands of calls to procedures and functions? Pavel Stehule
11:12 Re: Performance issue with thousands of calls to procedures and functions? Daniel Westermann (DWE)
11:21 Re: Performance issue with thousands of calls to procedures and functions? Pavel Stehule
14:15 Re: Performance issue with thousands of calls to procedures and functions? Daniel Westermann (DWE)