pgsql-performance - September 2021

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
Jump to day: 1 2 7 8 9 10 13 14 15 16 19 20 21 23 24 25 26 27 28 29

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

Browse Archives

Prev | Next
Jump to day: 1 2 7 8 9 10 13 14 15 16 19 20 21 23 24 25 26 27 28 29