pgsql-performance since 2021-08-24 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)
Advanced Search

Browse Archives

Prev | Next

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 ldh@laurent-hasson.com 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 ldh@laurent-hasson.com 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 ldh@laurent-hasson.com 18:21
RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 ldh@laurent-hasson.com 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 ldh@laurent-hasson.com 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 ldh@laurent-hasson.com 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 ldh@laurent-hasson.com 00:29
RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 ldh@laurent-hasson.com 00:44
Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Ranier Vilela 01:55
Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Julien Rouhaud 02:23
Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Pavel Stehule 02:43
Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 (workarounds) Justin Pryzby 03:16
RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 (workarounds) ldh@laurent-hasson.com 04:20
RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 ldh@laurent-hasson.com 16:04
Re: pg_restore schema dump to schema with different name Nagaraj Raj 16:52

Aug. 31, 2021

Thread Author Time
RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 ldh@laurent-hasson.com 02:18
RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Michel SALAIS 06:27
Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Andrew Dunstan 13:40
RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 ldh@laurent-hasson.com 14:51
Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Julien Rouhaud 15:37
Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Andrew Dunstan 17:55

Sept. 1, 2021

Thread Author Time
Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Julien Rouhaud 05:14

Sept. 2, 2021

Thread Author Time
Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 📎 Andrew Dunstan 15:22
Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Julien Rouhaud 15:34
Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Ranier Vilela 16:39
Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Andrew Dunstan 16:59

Sept. 7, 2021

Thread Author Time
FDW join vs full join push down Marc Olivé 14:02
Foreign table as partition - Non optimal aggregation plan Stepan Yankevych 18:05

Sept. 8, 2021

Thread Author Time
Better performance no-throw conversion? ldh@laurent-hasson.com 17:17
Re: Better performance no-throw conversion? Andrew Dunstan 17:31
Re: Better performance no-throw conversion? Tom Lane 17:32
Re: Better performance no-throw conversion? Michael Lewis 17:39
RE: Better performance no-throw conversion? ldh@laurent-hasson.com 17:55
RE: Better performance no-throw conversion? ldh@laurent-hasson.com 17:57

Sept. 9, 2021

Thread Author Time
PostgreSql 9.4 Database connection failure Lionel Napoleon 07:45
Re: PostgreSql 9.4 Database connection failure Ranier Vilela 11:55
sql execution time in pg_stat_statements Michel SALAIS 18:13
RE: sql execution time in pg_stat_statements Michel SALAIS 18:49

Sept. 10, 2021

Thread Author Time
Re: sql execution time in pg_stat_statements Julien Rouhaud 05:18
Re: PostgreSql 9.4 Database connection failure Ranier Vilela 10:58
RE: sql execution time in pg_stat_statements Michel SALAIS 17:12
Re: sql execution time in pg_stat_statements Tom Lane 17:42
Re: sql execution time in pg_stat_statements Julien Rouhaud 17:43

Sept. 13, 2021

Thread Author Time
Postgres chooses slow query plan from time to time Kristjan Mustkivi 13:24
Re: Postgres chooses slow query plan from time to time Tomas Vondra 13:50
Re: Postgres chooses slow query plan from time to time Michael Lewis 14:19
Re: Postgres chooses slow query plan from time to time Justin Pryzby 14:22
RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 ldh@laurent-hasson.com 14:32
Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Andrew Dunstan 15:35
RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 ldh@laurent-hasson.com 15:53
Re: Postgres chooses slow query plan from time to time Jeff Janes 19:21
Re: Postgres chooses slow query plan from time to time Jeff Janes 19:39
Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Andrew Dunstan 20:36

Sept. 14, 2021

Thread Author Time
EnterpriseDB Mladen Gogala 02:52
Re: Postgres chooses slow query plan from time to time Kristjan Mustkivi 07:55
Re: Postgres chooses slow query plan from time to time Kristjan Mustkivi 08:03
Re: Postgres chooses slow query plan from time to time Laurenz Albe 12:11
Re: Postgres chooses slow query plan from time to time Jeff Janes 12:26
Re: Postgres chooses slow query plan from time to time Kristjan Mustkivi 12:41
Re: Postgres chooses slow query plan from time to time Tom Lane 14:15
Re: EnterpriseDB sbob 15:03
Re: Postgres chooses slow query plan from time to time Kristjan Mustkivi 15:36
Re: Postgres chooses slow query plan from time to time Tom Lane 15:47
Re: EnterpriseDB manish yadav 16:22

Sept. 15, 2021

Thread Author Time
Re: Postgres chooses slow query plan from time to time Kristjan Mustkivi 06:47
Re: Postgres chooses slow query plan from time to time Tom Lane 12:16
Re: Postgres chooses slow query plan from time to time Kristjan Mustkivi 13:01
Re: Postgres chooses slow query plan from time to time Tom Lane 14:34

Sept. 16, 2021

Thread Author Time
Re: Postgres chooses slow query plan from time to time Kristjan Mustkivi 07:09
Want function to be called only once in query Steve Pritchard 08:51
Re: Want function to be called only once in query Jim Mlodgenski 10:56
Re: Want function to be called only once in query Steve Pritchard 11:07

Sept. 19, 2021

Thread Author Time
Query executed during pg_dump leads to excessive memory usage Ulf Lohbrügge 10:05
Re: Query executed during pg_dump leads to excessive memory usage Ranier Vilela 12:05
RE: sql execution time in pg_stat_statements Michel SALAIS 15:41
Re: Query executed during pg_dump leads to excessive memory usage Ulf Lohbrügge 18:28
Re: Query executed during pg_dump leads to excessive memory usage Gogala, Mladen 19:20
Re: Query executed during pg_dump leads to excessive memory usage Tom Lane 19:21

Sept. 20, 2021

Thread Author Time
multi-tenant queries select wrong index Kirill 12:33

Sept. 21, 2021

Thread Author Time
Re: multi-tenant queries select wrong index Alexey M Boltenkov 14:00

Sept. 23, 2021

Thread Author Time
hashjoins, index loops to retrieve pk/ux constrains in pg12 Arturas Mazeika 13:00

Sept. 24, 2021

Thread Author Time
Re: hashjoins, index loops to retrieve pk/ux constrains in pg12 Michael Lewis 05:33
Performance for initial copy when using pg_logical to upgrade Postgres Westwood, Giles 14:28
Re: Performance for initial copy when using pg_logical to upgrade Postgres Justin Pryzby 14:39
Re: Performance for initial copy when using pg_logical to upgrade Postgres Westwood, Giles 15:48
Re: Performance for initial copy when using pg_logical to upgrade Postgres Andrew Dunstan 16:00
Re: Performance for initial copy when using pg_logical to upgrade Postgres Tim 16:02
Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Andrew Dunstan 20:56

Sept. 25, 2021

Thread Author Time
RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 ldh@laurent-hasson.com 00:17

Sept. 26, 2021

Thread Author Time
RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 ldh@laurent-hasson.com 01:33

Sept. 27, 2021

Thread Author Time
Re: hashjoins, index loops to retrieve pk/ux constrains in pg12 Arturas Mazeika 10:09
Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Andrew Dunstan 13:25
Re: hashjoins, index loops to retrieve pk/ux constrains in pg12 Michael Lewis 14:12
Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 tushar 15:49
RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 ldh@laurent-hasson.com 16:05
Re: hashjoins, index loops to retrieve pk/ux constrains in pg12 Arturas Mazeika 19:56
Partial index on enum type is not being used, type issue? 📎 Kim Johan Andersson 20:02
Re: Partial index on enum type is not being used, type issue? Tom Lane 20:46

Sept. 28, 2021

Thread Author Time
RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 ldh@laurent-hasson.com 04:23
Re: hashjoins, index loops to retrieve pk/ux constrains in pg12 Tom Lane 14:13
Problem with indices from 10 to 13 Daniel Diniz 15:39
Re: Problem with indices from 10 to 13 Ranier Vilela 17:27
Re: Problem with indices from 10 to 13 Tom Lane 17:45
RE: Problem with indices from 10 to 13 Daniel Diniz 19:02
RE: Problem with indices from 10 to 13 Daniel Diniz 19:05
Re: Problem with indices from 10 to 13 Alan Hodgson 19:26
Re: Problem with indices from 10 to 13 Tom Lane 22:41

Sept. 29, 2021

Thread Author Time
RE: Problem with indices from 10 to 13 Daniel Diniz 02:11
Re: Problem with indices from 10 to 13 Justin Pryzby 02:18
RE: Problem with indices from 10 to 13 Daniel Diniz 04:00
Re: Problem with indices from 10 to 13 Pavel Stehule 04:59
Re: hashjoins, index loops to retrieve pk/ux constrains in pg12 Arturas Mazeika 13:05
How to improve cockroach performance with pgbench? Fabien COELHO 13:47

Oct. 1, 2021

Thread Author Time
Query going to all paritions aditya desai 07:28
Re: Query going to all paritions Laurenz Albe 07:53
Re: Query going to all paritions 📎 aditya desai 08:54
Re: Query going to all paritions hubert depesz lubaczewski 10:33
Re: Query going to all paritions aditya desai 11:33
Better, consistent instrumentation for postgreSQL using a similar API as Oracle Jeff Holt 20:06

Oct. 4, 2021

Thread Author Time
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Laurenz Albe 06:34

Oct. 5, 2021

Thread Author Time
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Mladen Gogala 01:51
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Michaeldba@sqlexec.com 02:25
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Peter Geoghegan 03:08
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Mladen Gogala 03:30
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Mladen Gogala 04:04
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Peter Geoghegan 04:40
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Laurenz Albe 08:26
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Ranier Vilela 11:44
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Mladen Gogala 14:41
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Peter Geoghegan 20:24
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Mladen Gogala 21:27

Oct. 6, 2021

Thread Author Time
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Tim 00:02
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Mladen Gogala 02:39
Installation of PostgreSQL on fedora zVM Manish Lad 05:13
Troubleshooting a long running delete statement Dirschel, Steve 18:00
Re: Troubleshooting a long running delete statement Mladen Gogala 18:54
Re: Troubleshooting a long running delete statement Justin Pryzby 19:20
Re: Troubleshooting a long running delete statement Laurenz Albe 19:48
RE: [EXT] Re: Troubleshooting a long running delete statement Dirschel, Steve 20:26
RE: [EXT] Re: Troubleshooting a long running delete statement Dirschel, Steve 20:32

Oct. 7, 2021

Thread Author Time
Re: [EXT] Re: Troubleshooting a long running delete statement Mladen Gogala 01:25
Re: [EXT] Re: Troubleshooting a long running delete statement Mladen Gogala 01:30
Re: Troubleshooting a long running delete statement Michael Lewis 04:44
Re: [EXT] Re: Troubleshooting a long running delete statement Maciek Sakrejda 05:15
Re: [EXT] Re: Troubleshooting a long running delete statement Corey Huinker 19:30

Oct. 8, 2021

Thread Author Time
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Bruce Momjian 01:09
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Jeremy Schneider 02:15
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Bruce Momjian 02:38
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Mladen Gogala 03:35
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Jeremy Schneider 05:22
PG 12 slow selects from pg_settings Julius Tuskenis 07:01
Re: PG 12 slow selects from pg_settings Ranier Vilela 11:00
Re: PG 12 slow selects from pg_settings Julius Tuskenis 12:05
Re: PG 12 slow selects from pg_settings Ranier Vilela 12:50
Re: PG 12 slow selects from pg_settings Julius Tuskenis 13:49
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Bruce Momjian 15:12
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Bruce Momjian 15:21
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Thomas Kellerer 15:28
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Bruce Momjian 15:40
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Julien Rouhaud 15:59
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Thomas Kellerer 16:07
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Mladen Gogala 16:38

Oct. 10, 2021

Thread Author Time
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Franck Pachot 22:09

Oct. 11, 2021

Thread Author Time
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Laurenz Albe 06:54
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Bruce Momjian 19:04

Oct. 12, 2021

Thread Author Time
Lock contention high Ashkil Dighin 07:35
Re: Lock contention high Mikhail Zhilin 10:29
Re: Lock contention high Laurenz Albe 14:39
Re: Lock contention high Mladen Gogala 15:37

Oct. 13, 2021

Thread Author Time
Re: Lock contention high Justin Pryzby 16:48
Re: Lock contention high MichaelDBA 18:15
Re: Lock contention high Paul Friedman 18:57
Re: Lock contention high Peter Geoghegan 19:05

Oct. 14, 2021

Thread Author Time
Re: Lock contention high Jeremy Schneider 01:54
Re: Lock contention high Peter Geoghegan 02:11
Re: Lock contention high Ashkil Dighin 06:03
Re: Lock contention high Laurenz Albe 06:42
Re: Lock contention high Ashkil Dighin 06:45
Re: Lock contention high Ashkil Dighin 06:49
Re: Lock contention high Mikhail Zhilin 07:47

Oct. 18, 2021

Thread Author Time
Query out of memory aditya desai 16:42
Re: Query out of memory aditya desai 16:43
Re: Query out of memory Vijaykumar Jain 16:48
Re: Query out of memory aditya desai 19:03

Browse Archives

Prev | Next