pgsql-performance since 2020-03-06 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

March 6, 2020

Thread Author Time
RE: proposal: schema variables DUVAL REMI 15:44
Re: proposal: schema variables 📎 Pavel Stehule 18:54

March 7, 2020

Thread Author Time
Re: proposal: schema variables 📎 Pavel Stehule 21:15

March 8, 2020

Thread Author Time
pg12 partitions show bad performance vs pg96 Mariel Cherkassky 16:05
Re: pg12 partitions show bad performance vs pg96 Mariel Cherkassky 16:14
Re: proposal: schema variables 📎 Pavel Stehule 18:12

March 9, 2020

Thread Author Time
Re: pg12 partitions show bad performance vs pg96 David Rowley 02:47
Re: pg12 partitions show bad performance vs pg96 Justin Pryzby 03:10
Re: pg12 partitions show bad performance vs pg96 Mariel Cherkassky 10:15
Re: pg12 partitions show bad performance vs pg96 Mariel Cherkassky 10:31
Re: pg12 partitions show bad performance vs pg96 Justin Pryzby 12:12
Re: pg12 partitions show bad performance vs pg96 Mariel Cherkassky 13:08
Re: pg12 partitions show bad performance vs pg96 Mariel Cherkassky 13:16
Re: pg12 partitions show bad performance vs pg96 David Rowley 21:43

March 11, 2020

Thread Author Time
Slow ext'd query via client native implementation vs. libpq & simple psql Richard Michael 19:31
Re: Slow ext'd query via client native implementation vs. libpq & simple psql Justin Pryzby 21:59
Re: Slow ext'd query via client native implementation vs. libpq & simple psql Tom Lane 22:54

March 12, 2020

Thread Author Time
Re: Slow ext'd query via client native implementation vs. libpq & simple psql Justin Pryzby 20:43

March 13, 2020

Thread Author Time
Re: proposal: schema variables 📎 Pavel Stehule 18:44

March 18, 2020

Thread Author Time
Re: proposal: schema variables 📎 Pavel Stehule 05:58

March 20, 2020

Thread Author Time
Re: proposal: schema variables 📎 Pavel Stehule 07:18
Re: proposal: schema variables 📎 Pavel Stehule 08:28

March 21, 2020

Thread Author Time
Slow planning time when public schema included (12 vs. 9.4) Anders Steinlein 12:02
Re: Slow planning time when public schema included (12 vs. 9.4) Andreas Kretschmer 13:37
Re: Slow planning time when public schema included (12 vs. 9.4) Tom Lane 14:26
Re: Slow planning time when public schema included (12 vs. 9.4) Anders Steinlein 15:45
Re: Slow planning time when public schema included (12 vs. 9.4) Anders Steinlein 15:59
Re: Slow planning time when public schema included (12 vs. 9.4) Tom Lane 19:35
Re: Slow planning time when public schema included (12 vs. 9.4) Anders Steinlein 21:13
Re: Slow planning time when public schema included (12 vs. 9.4) Tom Lane 22:55

March 22, 2020

Thread Author Time
Re: proposal: schema variables 📎 Pavel Stehule 07:40
JOIN on partitions is very slow daya airody 17:22
Re: JOIN on partitions is very slow Michael Lewis 18:08

March 23, 2020

Thread Author Time
Partitions to improve write/update speed for tables with indexes? Arya F 01:22
Re: Partitions to improve write/update speed for tables with indexes? Justin Pryzby 01:29
Partition Pruning (Hash Partitions) Support for DELETEs in PostgreSQL 11 and 12 Ronnie S 03:45
Re: Partition Pruning (Hash Partitions) Support for DELETEs in PostgreSQL 11 and 12 Justin Pryzby 04:10
Re: JOIN on partitions is very slow daya airody 07:40
Re: Partition Pruning (Hash Partitions) Support for DELETEs in PostgreSQL 11 and 12 Ronnie S 14:18
Re: JOIN on partitions is very slow Michael Lewis 16:16
Re: JOIN on partitions is very slow Thomas Kellerer 16:33

March 24, 2020

Thread Author Time
Random function Luis Roberto Weck 18:10
Re: Random function Tom Lane 18:33
Re: Random function David G. Johnston 18:33
Re: Slow planning time when public schema included (12 vs. 9.4) Anders Steinlein 22:55

March 27, 2020

Thread Author Time
Best way to delete big amount of records from big table Ekaterina Amez 14:13
Re: Best way to delete big amount of records from big table Michael Lewis 14:41
Re: Best way to delete big amount of records from big table Laurenz Albe 14:46
Re: Best way to delete big amount of records from big table Ekaterina Amez 14:55
Re: Best way to delete big amount of records from big table Ekaterina Amez 14:56
Re: Best way to delete big amount of records from big table Rick Otten 15:03
Re: Best way to delete big amount of records from big table Justin Pryzby 15:09
Re: Best way to delete big amount of records from big table Ekaterina Amez 15:15
Re: JOIN on partitions is very slow daya airody 15:24

March 28, 2020

Thread Author Time
Re: Best way to delete big amount of records from big table Laurenz Albe 04:32

March 30, 2020

Thread Author Time
Increasing work_mem slows down query, why? Silvio Moioli 06:47
Re: Increasing work_mem slows down query, why? Pavel Stehule 06:56
Re: Increasing work_mem slows down query, why? Silvio Moioli 08:12
Re: Increasing work_mem slows down query, why? Pavel Stehule 10:12
Re: Increasing work_mem slows down query, why? Silvio Moioli 13:09
Re: Increasing work_mem slows down query, why? Pavel Stehule 13:33
Re: Increasing work_mem slows down query, why? Pavel Stehule 13:40
Re: Increasing work_mem slows down query, why? Tom Lane 16:02
Re: Increasing work_mem slows down query, why? Pavel Stehule 16:18
Re: Increasing work_mem slows down query, why? Tom Lane 16:36
Re: Increasing work_mem slows down query, why? Pavel Stehule 16:49

April 2, 2020

Thread Author Time
BUG #16334: We recently upgraded PG version from 9.5 to 10.10 and system performance is not so good PG Bug reporting form 03:52
Re: BUG #16334: We recently upgraded PG version from 9.5 to 10.10 and system performance is not so good Julien Rouhaud 08:46
Re: BUG #16334: We recently upgraded PG version from 9.5 to 10.10 and system performance is not so good Tejaswini GC 10:22
Re: BUG #16334: We recently upgraded PG version from 9.5 to 10.10 and system performance is not so good Julien Rouhaud 11:04
Re: BUG #16334: We recently upgraded PG version from 9.5 to 10.10 and system performance is not so good Tejaswini GC 11:09
Could someone please help us share the procedure to troubleshoot the locks on proc issues. 📎 postgann2020 s 19:37
Re: Could someone please help us share the procedure to troubleshoot the locks on proc issues. Adrian Klaver 23:00

April 3, 2020

Thread Author Time
Re: Could someone please help us share the procedure to troubleshoot the locks on proc issues. postgann2020 s 05:11
slow query dangal 16:03
Re: slow query Justin Pryzby 16:07
Re: slow query dangal 16:18
Re: Increasing work_mem slows down query, why? Silvio Moioli 21:46

April 4, 2020

Thread Author Time
Re: BUG #16334: We recently upgraded PG version from 9.5 to 10.10 and system performance is not so good Tejaswini GC 06:27
Re: BUG #16334: We recently upgraded PG version from 9.5 to 10.10 and system performance is not so good Julien Rouhaud 07:06

April 5, 2020

Thread Author Time
Postgresql 12, 512 partition by hash. Slow select Arya F 17:48
Re: Postgresql 12, 512 partition by hash. Slow select Andreas Kretschmer 18:41
Re: Postgresql 12, 512 partition by hash. Slow select Tom Lane 18:55
Re: Postgresql 12, 512 partition by hash. Slow select Arya F 19:50
Re: Postgresql 12, 512 partition by hash. Slow select Neil 20:48

April 6, 2020

Thread Author Time
Postgres not using index on views Rick Vincent 14:19

April 7, 2020

Thread Author Time
Re: Postgres not using index on views Justin Pryzby 04:59
Re: Postgres not using index on views Tom Lane 05:09
Re: Postgres not using index on views Laurenz Albe 06:42
RE: Postgres not using index on views Rick Vincent 07:53
RE: Postgres not using index on views Rick Vincent 09:08
Re: Postgres not using index on views Thomas Kellerer 09:18
Re: Postgres not using index on views Thomas Kellerer 09:24
Re: slow query Michael Christofides 10:20
PostgreSQL DBA consulting daya airody 11:50
Re: PostgreSQL DBA consulting Justin Pryzby 11:56

April 9, 2020

Thread Author Time
High insert rate server, unstable insert latency and load peaks with buffer_content and XidGenLock LWlocks with Postgresql 12 version Maxim Boguk 14:51
Re: High insert rate server, unstable insert latency and load peaks with buffer_content and XidGenLock LWlocks with Postgresql 12 version Justin Pryzby 15:16
Re: High insert rate server, unstable insert latency and load peaks with buffer_content and XidGenLock LWlocks with Postgresql 12 version Maxim Boguk 15:29

April 10, 2020

Thread Author Time
Re: proposal: schema variables 📎 Pavel Stehule 17:30

April 13, 2020

Thread Author Time
High kswapd Don Seiler 14:34
Re: High kswapd Justin Pryzby 14:42
Re: High kswapd Don Seiler 14:46
Re: High kswapd Justin Pryzby 14:58
Re: PostgreSQL DBA consulting Amol Tarte 15:04
Re: High kswapd Don Seiler 15:08

April 15, 2020

Thread Author Time
Duplicate WHERE condition changes performance and plan singh400@gmail.com 19:55
Using unlogged tables for web sessions Stephen Carboni 22:53
Re: Duplicate WHERE condition changes performance and plan David Rowley 23:57

April 17, 2020

Thread Author Time
RE: Postgres not using index on views Rick Vincent 14:28
Postgres not using index on views David G. Johnston 14:55
RE: Postgres not using index on views Rick Vincent 15:12

April 20, 2020

Thread Author Time
Re: Duplicate WHERE condition changes performance and plan singh400@gmail.com 00:50
Re: Duplicate WHERE condition changes performance and plan Justin Pryzby 02:33
RE: Postgres not using index on views Rick Vincent 11:10

April 23, 2020

Thread Author Time
PostgreSQL does not choose my indexes well Arcadio Ortega Reinoso 11:36
Re: PostgreSQL does not choose my indexes well Thomas Kellerer 11:43
Re: PostgreSQL does not choose my indexes well David G. Johnston 13:57
Re: PostgreSQL does not choose my indexes well Tom Lane 15:29
Re: PostgreSQL does not choose my indexes well Michael Lewis 16:20
Re: PostgreSQL does not choose my indexes well Tom Lane 16:31
Re: PostgreSQL does not choose my indexes well David G. Johnston 16:50
Re: PostgreSQL does not choose my indexes well Stephen Frost 17:18
Re: PostgreSQL does not choose my indexes well Stephen Frost 17:20
Re: PostgreSQL does not choose my indexes well Tom Lane 17:56
Re: PostgreSQL does not choose my indexes well Stephen Frost 20:01
Re: PostgreSQL does not choose my indexes well Tom Lane 20:33
Re: PostgreSQL does not choose my indexes well David G. Johnston 20:36
Re: PostgreSQL does not choose my indexes well Tom Lane 20:45
Re: PostgreSQL does not choose my indexes well Arcadio Ortega Reinoso 21:01

April 24, 2020

Thread Author Time
Re: Duplicate WHERE condition changes performance and plan singh400@gmail.com 16:33
Re: PostgreSQL does not choose my indexes well Jeff Janes 18:26
Re: PostgreSQL does not choose my indexes well Stephen Frost 18:33
Re: PostgreSQL does not choose my indexes well Tom Lane 19:39
The query plan get all columns but I'm using only one column. Moises Lopez 21:11
Re: PostgreSQL does not choose my indexes well Jeff Janes 22:59

April 25, 2020

Thread Author Time
Re: PostgreSQL does not choose my indexes well Stephen Frost 12:02
Re: The query plan get all columns but I'm using only one column. Tom Lane 14:24
Re: PostgreSQL does not choose my indexes well Arcadio Ortega Reinoso 19:47
Re: The query plan get all columns but I'm using only one column. Michael Lewis 20:40

April 27, 2020

Thread Author Time
Recursive query slow on strange conditions Jean-Christophe Boggio 17:49
Re: Recursive query slow on strange conditions Justin Pryzby 18:10
Re: Recursive query slow on strange conditions Andreas Joseph Krogh 19:37
Re: Recursive query slow on strange conditions Jean-Christophe Boggio 20:22

April 29, 2020

Thread Author Time
NUMA settings Marc Rechté 06:54
Re: NUMA settings Laurenz Albe 08:50
Re: The query plan get all columns but I'm using only one column. 📎 Moises Lopez 19:21
Re: The query plan get all columns but I'm using only one column. Michael Lewis 19:36

April 30, 2020

Thread Author Time
Re: The query plan get all columns but I'm using only one column. Michael Lewis 15:52
Re: The query plan get all columns but I'm using only one column. Moises Lopez 16:26

May 2, 2020

Thread Author Time
Best partition type for billions of addresses Arya F 13:20
Re: Best partition type for billions of addresses Justin Pryzby 14:00
Re: Best partition type for billions of addresses Stephen Frost 14:01
Re: Best partition type for billions of addresses Arya F 14:33
Re: Best partition type for billions of addresses Stephen Frost 14:39

May 3, 2020

Thread Author Time
Please help! Query jumps from 1s -> 4m James Thompson 08:58
Re: Duplicate WHERE condition changes performance and plan singh400@gmail.com 11:39
Re: Please help! Query jumps from 1s -> 4m Justin Pryzby 15:38

May 4, 2020

Thread Author Time
600 million rows of data. Bad hardware or need partitioning? Arya F 03:27
Re: 600 million rows of data. Bad hardware or need partitioning? Michael Lewis 03:45
Re: 600 million rows of data. Bad hardware or need partitioning? Arya F 03:51
Re: 600 million rows of data. Bad hardware or need partitioning? David Rowley 04:44
Re: 600 million rows of data. Bad hardware or need partitioning? Justin Pryzby 09:21
Re: Recursive query slow on strange conditions Jean-Christophe Boggio 16:12
Re: Recursive query slow on strange conditions David G. Johnston 16:20
Re: NUMA settings Andres Freund 16:20
Re: Recursive query slow on strange conditions Jean-Christophe Boggio 16:25
Re: Duplicate WHERE condition changes performance and plan Michael Lewis 17:11
Re: Please help! Query jumps from 1s -> 4m Justin Pryzby 19:12
Re: Please help! Query jumps from 1s -> 4m James Thompson 19:12
Re: Please help! Query jumps from 1s -> 4m David Rowley 20:12
good book or any other resources for Postgresql Bhupendra Babu 22:45
Re: good book or any other resources for Postgresql Michael Lewis 23:41
Re: good book or any other resources for Postgresql Craig Jackson 23:45

May 5, 2020

Thread Author Time
Re: good book or any other resources for Postgresql Bhupendra Babu 03:37
Re: NUMA settings Marc Rechté 05:56
Re: NUMA settings Laurenz Albe 08:00
Re: Please help! Query jumps from 1s -> 4m Laurenz Albe 08:08
Re: NUMA settings Marc Rechté 08:11
Re: NUMA settings Laurenz Albe 08:25
Re: Please help! Query jumps from 1s -> 4m Justin Pryzby 19:28
Re: Please help! Query jumps from 1s -> 4m James Thompson 21:10
Re: Please help! Query jumps from 1s -> 4m Justin Pryzby 21:35
Re: Please help! Query jumps from 1s -> 4m Tom Lane 21:42

May 6, 2020

Thread Author Time
Re: 600 million rows of data. Bad hardware or need partitioning? Arya F 00:15
Re: 600 million rows of data. Bad hardware or need partitioning? Arya F 00:31
Re: 600 million rows of data. Bad hardware or need partitioning? Justin Pryzby 01:37
Inaccurate Rows estimate for "Bitmap And" causes Planner to choose wrong join Steve Pritchard 16:19
Re: Inaccurate Rows estimate for "Bitmap And" causes Planner to choose wrong join Justin Pryzby 16:34
Re: Inaccurate Rows estimate for "Bitmap And" causes Planner to choose wrong join Jeff Janes 18:24

May 7, 2020

Thread Author Time
Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query ) Amarendra Konda 11:19
Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query ) Adrian Klaver 14:40
Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query ) David G. Johnston 15:46
pg_attribute, pg_class, pg_depend grow huge in count and size with multiple tenants. samhitha g 17:10
Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query ) Amarendra Konda 17:36
Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query ) Amarendra Konda 17:49
Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query ) Amarendra Konda 18:07
AutoVacuum and growing transaction XID's github kran 18:23
Re: AutoVacuum and growing transaction XID's Michael Lewis 18:32
Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query ) Amarendra Konda 18:51

Browse Archives

Prev | Next