pgsql-performance before 2021-10-01 00:00

Discussion of PostgreSQL's performance issues. Please see Guide to reporting problems and Slow Query Questions for some tips on how to write your performance question.

Search the Archives

(enter a message-id to go directly to that message)

Browse Archives

Prev | Next

July 30, 2021

Thread Author Time
Re: Performance issue with thousands of calls to procedures and functions? Pavel Stehule 08:21
Re: Performance issue with thousands of calls to procedures and functions? Daniel Westermann (DWE) 11:15

Aug. 4, 2021

Thread Author Time
Logical Replication speed-up initial data Nikhil Shetty 15:06
Re: Logical Replication speed-up initial data Hüseyin Demir 15:24
Re: Logical Replication speed-up initial data Stefano Amoroso 15:55
Re: Logical Replication speed-up initial data Christophe Pettus 16:28

Aug. 5, 2021

Thread Author Time
Re: Logical Replication speed-up initial data Nikhil Shetty 04:56
Re: Logical Replication speed-up initial data Nikhil Shetty 04:57
Re: Logical Replication speed-up initial data Rick Otten 13:25
Re: Logical Replication speed-up initial data Vijaykumar Jain 14:27
Re: Logical Replication speed-up initial data Avinash Kumar 15:11
Re: Logical Replication speed-up initial data Nikhil Shetty 18:41
Re: Logical Replication speed-up initial data Nikhil Shetty 18:45
Re: Logical Replication speed-up initial data Vijaykumar Jain 19:20
Re: Logical Replication speed-up initial data Jeff Janes 20:03

Aug. 7, 2021

Thread Author Time
Slow query because lexeme index not used Alex 19:35

Aug. 8, 2021

Thread Author Time
Re: Slow query because lexeme index not used Justin Pryzby 00:35
Re: Slow query because lexeme index not used Alex 09:43

Aug. 10, 2021

Thread Author Time
Postgres using the wrong index index Matt Dupree 16:47

Aug. 11, 2021

Thread Author Time
Re: Postgres using the wrong index index Justin Pryzby 12:38
difference between pg_triggers and information_schema.triggers aditya desai 18:28
Re: difference between pg_triggers and information_schema.triggers David G. Johnston 18:37
Re: difference between pg_triggers and information_schema.triggers aditya desai 18:54
PostgreSQL equivalent of UTL_HTTP aditya desai 18:56
Re: PostgreSQL equivalent of UTL_HTTP Pavel Stehule 19:13
Re: Postgres using the wrong index index Matt Dupree 19:56
Re: Postgres using the wrong index index Mladen Gogala 21:45

Aug. 12, 2021

Thread Author Time
Re: Postgres using the wrong index index Justin Pryzby 03:45
Re: Postgres using the wrong index index Matt Dupree 13:38
Re: Postgres using the wrong index index Justin Pryzby 23:20

Aug. 16, 2021

Thread Author Time
Re: Postgres using the wrong index index Matt Dupree 15:22

Aug. 17, 2021

Thread Author Time
Re: Postgres using the wrong index index Justin Pryzby 18:52

Aug. 21, 2021

Thread Author Time
RE: Big performance slowdown from 11.2 to 13.3 [email protected] 05:42
Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected] 07:56
RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected] 08:55
Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Tom Lane 15:04
Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Mladen Gogala 15:29
RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected] 16:01
Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Tom Lane 18:04
Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Tom Lane 18:17
Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Justin Pryzby 19:19
Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Maciek Sakrejda 20:58
Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Justin Pryzby 21:24
RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected] 21:48
RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected] 21:56
Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Justin Pryzby 22:17
RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected] 23:01

Aug. 22, 2021

Thread Author Time
RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected] 00:14
Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 📎 Ranier Vilela 13:50
Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Justin Pryzby 15:47
Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Tom Lane 17:50
RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected] 18:32
RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected] 18:37
RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected] 19:07
Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Tom Lane 19:23
RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected] 19:28
RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected] 19:31
Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Tom Lane 20:11
RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected] 21:12
Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Andrew Dunstan 21:26
RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected] 21:59
Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Andrew Dunstan 22:11
Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 📎 Ranier Vilela 23:15
Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Ranier Vilela 23:16
Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Ranier Vilela 23:44

Aug. 23, 2021

Thread Author Time
Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Justin Pryzby 00:42
RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected] 03:22
pg_restore schema dump to schema with different name Nagaraj Raj 09:44
Re: pg_restore schema dump to schema with different name Laurenz Albe 13:19
Re: pg_restore schema dump to schema with different name Jean-Christophe Boggio 13:38
Re: pg_restore schema dump to schema with different name Nagaraj Raj 17:54

Aug. 24, 2021

Thread Author Time
Re: Postgres using the wrong index index Matt Dupree 00:53
Re: Postgres using the wrong index index Justin Pryzby 01:38
Re: pg_restore schema dump to schema with different name Laurenz Albe 09:53
Re: pg_restore schema dump to schema with different name David G. Johnston 14:55

Aug. 25, 2021

Thread Author Time
Using regexp from table has unpredictable poor performance Jack Christensen 16:47
Re: Using regexp from table has unpredictable poor performance Justin Pryzby 21:05
Re: Using regexp from table has unpredictable poor performance Jack Christensen 21:21
Re: Using regexp from table has unpredictable poor performance Vitalii Tymchyshyn 22:16

Aug. 26, 2021

Thread Author Time
RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected] 14:47
Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Andrew Dunstan 16:39

Aug. 27, 2021

Thread Author Time
RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected] 00:21
Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Tom Lane 17:43

Aug. 28, 2021

Thread Author Time
RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected] 18:21
RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected] 18:27
Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Tom Lane 19:50

Aug. 29, 2021

Thread Author Time
RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected] 01:55
Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Ranier Vilela 12:53
Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Tom Lane 13:35
Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Ranier Vilela 14:00
RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected] 16:03
Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Tom Lane 16:19
Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Ranier Vilela 18:20

Aug. 30, 2021

Thread Author Time
RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected] 00:29