pgsql-performance since 2019-01-30 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

Jan. 30, 2019

Thread Author Time
Re: dsa_allocate() faliure Thomas Munro 03:13
Re: Will higher shared_buffers improve tpcb-like benchmarks? Saurabh Nanda 03:50
Re: ERROR: found xmin from before relfrozenxid Mariel Cherkassky 07:51
Re: ERROR: found xmin from before relfrozenxid Alvaro Herrera 09:13
Re: dsa_allocate() faliure Fabio Isabettini 09:53
Re: ERROR: found xmin from before relfrozenxid Mariel Cherkassky 10:35
pgstattupple vs pg_total_relation_size Mariel Cherkassky 10:41
Re: How can sort performance be so different Bob Jolliffe 11:57
Re: pgstattupple vs pg_total_relation_size Tumasgiu Rossini 13:19
Re: pgstattupple vs pg_total_relation_size Jehan-Guillaume (ioguix) de Rorthais 13:27
Re: pgstattupple vs pg_total_relation_size Mariel Cherkassky 14:32
Re: pgstattupple vs pg_total_relation_size Tom Lane 14:46
Re: [HACKERS] proposal: schema variables 📎 Pavel Stehule 16:34
Re: How can sort performance be so different Peter Geoghegan 23:54

Jan. 31, 2019

Thread Author Time
Setting effective_cache size Nandakumar M 07:30
Re: Setting effective_cache size Nandakumar M 07:34
Re: [HACKERS] proposal: schema variables 📎 Pavel Stehule 11:49
Re: Setting effective_cache size Laurenz Albe 11:57
Re: How can sort performance be so different Bob Jolliffe 13:29
RE: dsa_allocate() faliure 📎 Arne Roland 18:19

Feb. 1, 2019

Thread Author Time
Re: dsa_allocate() faliure Justin Pryzby 18:08

Feb. 4, 2019

Thread Author Time
Re: dsa_allocate() faliure Jakub Glapa 07:52
Re: dsa_allocate() faliure Thomas Munro 08:22
Fw: server hardware tuning. suganthi Sekar 09:57
Re: Fw: server hardware tuning. Prince Pathria 14:45
Sv: Re: Fw: server hardware tuning. Andreas Joseph Krogh 14:56
Re: ERROR: found xmin from before relfrozenxid Mariel Cherkassky 16:42
RE: dsa_allocate() faliure Arne Roland 20:31
Re: dsa_allocate() faliure Justin Pryzby 21:47

Feb. 5, 2019

Thread Author Time
Re: How can sort performance be so different Merlin Moncure 20:30

Feb. 6, 2019

Thread Author Time
Re: How can sort performance be so different Laurenz Albe 08:38
autovacuum big table taking hours and sometimes seconds Mariel Cherkassky 10:29
Re: autovacuum big table taking hours and sometimes seconds Laurenz Albe 11:16
Re: autovacuum big table taking hours and sometimes seconds David Rowley 13:05
Re: autovacuum big table taking hours and sometimes seconds Mariel Cherkassky 13:34
Re: autovacuum big table taking hours and sometimes seconds dangal 13:36
Re: autovacuum big table taking hours and sometimes seconds Mariel Cherkassky 13:41
Re: autovacuum big table taking hours and sometimes seconds MichaelDBA 14:11
Re: autovacuum big table taking hours and sometimes seconds Jeff Janes 14:12
Re: autovacuum big table taking hours and sometimes seconds Mariel Cherkassky 14:42
Re: autovacuum big table taking hours and sometimes seconds Jeff Janes 18:49
Re: autovacuum big table taking hours and sometimes seconds David Rowley 22:33
Re: dsa_allocate() faliure Justin Pryzby 23:21

Feb. 7, 2019

Thread Author Time
Re: dsa_allocate() faliure Jakub Glapa 10:10
Transaction size and Wal2Json Mai Peng 10:38
Re: Transaction size and Wal2Json Peter Eisentraut 10:45
Re: autovacuum big table taking hours and sometimes seconds Mariel Cherkassky 11:55
Re: autovacuum big table taking hours and sometimes seconds Jeff Janes 16:26
Re: dsa_allocate() faliure Thomas Munro 17:49

Feb. 8, 2019

Thread Author Time
Re: dsa_allocate() faliure Thomas Munro 02:29
Partitioning Optimizer Questions and Issues keith anderson 11:13
Re: Partitioning Optimizer Questions and Issues Justin Pryzby 13:04

Feb. 9, 2019

Thread Author Time
Re: dsa_allocate() faliure Robert Haas 10:21
[No subject] Evandro Abreu 16:45
Re: slow to run query 5000 times Justin Pryzby 17:16
Re: slow to run query 5000 times Andres Freund 20:23
Re: dsa_allocate() faliure Thomas Munro 20:24
Re: dsa_allocate() faliure Thomas Munro 21:06

Feb. 10, 2019

Thread Author Time
Re: slow to run query 5000 times Ricardo Martin Gomez 00:23
Re: dsa_allocate() faliure Robert Haas 06:26
Re: dsa_allocate() faliure 📎 Robert Haas 06:40
Re: dsa_allocate() faliure Justin Pryzby 16:00
Re: dsa_allocate() faliure Sergei Kornilov 16:11
Re: dsa_allocate() faliure Justin Pryzby 16:50
Re: Tumasgiu Rossini 18:43
Re: dsa_allocate() faliure 📎 Thomas Munro 22:45
Re: dsa_allocate() faliure Tom Lane 23:33

Feb. 11, 2019

Thread Author Time
Re: dsa_allocate() faliure Justin Pryzby 00:02
Re: dsa_allocate() faliure Thomas Munro 00:11
Re: dsa_allocate() faliure Thomas Munro 00:24
Re: dsa_allocate() faliure Tom Lane 01:22
Re: Partitioning Optimizer Questions and Issues 📎 keith anderson 08:05
Performance regressions found using sqlfuzz Jung, Jinho 22:29

Feb. 12, 2019

Thread Author Time
Re: Performance regressions found using sqlfuzz Christoph Berg 12:00
Bloom index cost model seems to be wrong Thomas Kellerer 15:08
Re: Bloom index cost model seems to be wrong Tom Lane 15:41
Re: Bloom index cost model seems to be wrong Jeff Janes 16:58
Re: Performance regressions found using sqlfuzz Jeff Janes 18:03
Re: Bloom index cost model seems to be wrong Jeff Janes 19:56
Re: Bloom index cost model seems to be wrong Tom Lane 21:17
Re: Bloom index cost model seems to be wrong Jeff Janes 22:38

Feb. 13, 2019

Thread Author Time
Re: dsa_allocate() faliure Thomas Munro 00:52
understanding max_wal_size,wal_keep_segments and checkpoints Mariel Cherkassky 08:34
Re: understanding max_wal_size,wal_keep_segments and checkpoints Laurenz Albe 09:43
Re: understanding max_wal_size,wal_keep_segments and checkpoints Mariel Cherkassky 10:45
Re: understanding max_wal_size,wal_keep_segments and checkpoints Laurenz Albe 11:23
ERROR: unrecognized parameter "autovacuum_analyze_scale_factor" Mariel Cherkassky 15:43
Re: ERROR: unrecognized parameter "autovacuum_analyze_scale_factor" Alvaro Herrera 16:13
Re: ERROR: unrecognized parameter "autovacuum_analyze_scale_factor" Mariel Cherkassky 16:41
Re: ERROR: unrecognized parameter "autovacuum_analyze_scale_factor" Alvaro Herrera 16:54

Feb. 14, 2019

Thread Author Time
Re: ERROR: unrecognized parameter "autovacuum_analyze_scale_factor" Mariel Cherkassky 07:56
Re: server hardware tuning. suganthi Sekar 09:38
Re: constraint exclusion with ineq condition (Re: server hardware tuning.) Justin Pryzby 10:05
Re: constraint exclusion with ineq condition (Re: server hardware tuning.) suganthi Sekar 10:38
Re: constraint exclusion with ineq condition (Re: server hardware tuning.) Justin Pryzby 10:40
Re: constraint exclusion with ineq condition (Re: server hardware tuning.) suganthi Sekar 10:49
Re: partition pruning Laurenz Albe 12:37
Re: partition pruning suganthi Sekar 12:41
Re: constraint exclusion with ineq condition (Re: server hardware tuning.) Michael Lewis 14:05
Re: constraint exclusion with ineq condition (Re: server hardware tuning.) suganthi Sekar 14:35
Re: partition pruning Justin Pryzby 14:36
Re: autovacuum big table taking hours and sometimes seconds Mariel Cherkassky 16:09
Re: Performance regressions found using sqlfuzz Jung, Jinho 17:27
Re: autovacuum big table taking hours and sometimes seconds Michael Lewis 18:37
Re: constraint exclusion with ineq condition (Re: server hardware tuning.) Michael Lewis 18:50
Re: autovacuum big table taking hours and sometimes seconds Mariel Cherkassky 19:40
Re: autovacuum big table taking hours and sometimes seconds Michael Lewis 19:52
Re: autovacuum big table taking hours and sometimes seconds Mariel Cherkassky 20:07
Re: Q on SQL Performance tuning Greg Stark 20:29
Re: JIT overhead slowdown Justin Pryzby 21:03
Re: autovacuum big table taking hours and sometimes seconds Michael Lewis 21:45

Feb. 15, 2019

Thread Author Time
Re: constraint exclusion with ineq condition (Re: server hardware tuning.) suganthi Sekar 05:09
Re: autovacuum big table taking hours and sometimes seconds Mariel Cherkassky 06:23
Re: autovacuum big table taking hours and sometimes seconds Laurenz Albe 08:06
Re: ERROR: unrecognized parameter "autovacuum_analyze_scale_factor" Alvaro Herrera 13:39
Re: Performance regressions found using sqlfuzz Andrew Gierth 16:20
Re: Performance regressions found using sqlfuzz Andres Freund 16:44
Re: constraint exclusion with ineq condition (Re: server hardware tuning.) Benedict Holland 17:24
Re: ERROR: unrecognized parameter "autovacuum_analyze_scale_factor" Mariel Cherkassky 18:00

Feb. 16, 2019

Thread Author Time
Re: constraint exclusion with ineq condition (Re: server hardware tuning.) Justin Pryzby 22:04
Re: Performance regressions found using sqlfuzz Tom Lane 22:37

Feb. 17, 2019

Thread Author Time
Re: dsa_allocate() faliure Justin Pryzby 22:21

Feb. 18, 2019

Thread Author Time
Re: dsa_allocate() faliure Jakub Glapa 09:11
Re: How can sort performance be so different Bob Jolliffe 15:49
Re: Performance regressions found using sqlfuzz Jung, Jinho 21:08

Feb. 19, 2019

Thread Author Time
index on jsonb col with 2D array inside the json Mariel Cherkassky 15:59
Re: index on jsonb col with 2D array inside the json Michael Lewis 16:28
Re: index on jsonb col with 2D array inside the json Mariel Cherkassky 16:33
Re: index on jsonb col with 2D array inside the json Michael Lewis 16:41
Re: index on jsonb col with 2D array inside the json Mariel Cherkassky 18:30

Feb. 20, 2019

Thread Author Time
Why isn't an index scan being used? Abi Noda 00:10
Re: Why isn't an index scan being used? David Rowley 00:51
Re: Why isn't an index scan being used? Abi Noda 00:59
Re: Why isn't an index scan being used? Andrew Gierth 03:00
Re: Why isn't an index scan being used? Michael Lewis 04:29
Re: Why isn't an index scan being used? Justin Pryzby 04:37
Re: Why isn't an index scan being used? Abi Noda 04:58
Re: Why isn't an index scan being used? Justin Pryzby 08:05
Re: Why isn't an index scan being used? Jeff Janes 14:58
Re: How can sort performance be so different Merlin Moncure 21:35
Re: How can sort performance be so different Bob Jolliffe 21:42
Re: How can sort performance be so different Peter Geoghegan 22:25
neither CPU nor IO bound, but throttled performance Gunther 23:32

Feb. 21, 2019

Thread Author Time
Re: How can sort performance be so different Peter Geoghegan 00:54
Re: neither CPU nor IO bound, but throttled performance Justin Pryzby 01:32
Re: neither CPU nor IO bound, but throttled performance Magnus Hagander 09:08
Re: neither CPU nor IO bound, but throttled performance Gunther Schadow 15:59

Feb. 22, 2019

Thread Author Time
Aggregate and many LEFT JOIN kimaidou 15:14
Slow query with aggregate and many LEFT JOINS kimaidou 15:36
Re: Aggregate and many LEFT JOIN Justin Pryzby 15:54
Re: Aggregate and many LEFT JOIN Michael Lewis 16:14
Re: Aggregate and many LEFT JOIN kimaidou 16:33
Re: Aggregate and many LEFT JOIN Michael Lewis 17:18
Re: Aggregate and many LEFT JOIN Tom Lane 18:05
RE: Slow query with aggregate and many LEFT JOINS Igor Neyman 19:47
RE: Slow query with aggregate and many LEFT JOINS Igor Neyman 19:53

Feb. 23, 2019

Thread Author Time
Massive parallel queue table causes index deterioration, but REINDEX fails with deadlocks. Gunther 21:05
Re: Massive parallel queue table causes index deterioration, but REINDEX fails with deadlocks. Peter Geoghegan 21:13

Feb. 24, 2019

Thread Author Time
Re: Massive parallel queue table causes index deterioration, but REINDEX fails with deadlocks. Gunther 02:55
Re: Massive parallel queue table causes index deterioration, but REINDEX fails with deadlocks. David Rowley 06:41
Re: Massive parallel queue table causes index deterioration, but REINDEX fails with deadlocks. Justin Pryzby 07:03
Re: Massive parallel queue table causes index deterioration, but REINDEX fails with deadlocks. Corey Huinker 07:25
Re: Bloom index cost model seems to be wrong 📎 Jeff Janes 16:09
Re: Massive parallel queue table causes index deterioration, but REINDEX fails with deadlocks. Gunther 17:45
Re: Massive parallel queue table causes index deterioration, but REINDEX fails with deadlocks. Justin Pryzby 20:20
Re: Massive parallel queue table causes index deterioration, but REINDEX fails with deadlocks. Peter Geoghegan 20:41
Re: Massive parallel queue table causes index deterioration, but REINDEX fails with deadlocks. Corey Huinker 21:34
Re: Massive parallel queue table causes index deterioration, but REINDEX fails with deadlocks. Justin Pryzby 22:43
Re: Massive parallel queue table causes index deterioration, but REINDEX fails with deadlocks. Corey Huinker 22:52
Re: Massive parallel queue table causes index deterioration, but REINDEX fails with deadlocks. Jeff Janes 23:33
Re: Massive parallel queue table causes index deterioration, but REINDEX fails with deadlocks. Jeff Janes 23:39

Feb. 25, 2019

Thread Author Time
Re: Massive parallel queue table causes index deterioration, but REINDEX fails with deadlocks. Gunther Schadow 03:06
Re: Massive parallel queue table causes index deterioration, but REINDEX fails with deadlocks. Gunther 03:06
Re: Massive parallel queue table causes index deterioration, but REINDEX fails with deadlocks. Justin Pryzby 03:54
Re: Aggregate and many LEFT JOIN kimaidou 08:54
Re: Aggregate and many LEFT JOIN kimaidou 09:44
Idle backends outside a transaction holding onto large amounts of memory / swap space? 📎 Tobias Gierke 10:36
Query slow for new participants Kim 10:41
Re: Idle backends outside a transaction holding onto large amounts of memory / swap space? Pavel Stehule 10:52
Re: Query slow for new participants Justin Pryzby 16:16
Re: Massive parallel queue table causes index deterioration, but REINDEX fails with deadlocks. Corey Huinker 16:30
Re: Aggregate and many LEFT JOIN Michael Lewis 18:29
Re: Query slow for new participants support@mekong.be 19:23
Re: Massive parallel queue table causes index deterioration, but REINDEX fails with deadlocks. Jeff Janes 20:30
Re: Massive parallel queue table causes index deterioration, but REINDEX fails with deadlocks. Jeff Janes 21:03
Re: Massive parallel queue table causes index deterioration, but REINDEX fails with deadlocks. MichaelDBA 21:07
Re: Query slow for new participants support@mekong.be 23:22
Re: Query slow for new participants Justin Pryzby 23:59

Feb. 26, 2019

Thread Author Time
Re: Query slow for new participants MichaelDBA 00:30
Re: Aggregate and many LEFT JOIN kimaidou 12:54
Re: Aggregate and many LEFT JOIN Justin Pryzby 13:51
Re: Aggregate and many LEFT JOIN Jeff Janes 13:52
Re: Query slow for new participants Michael Lewis 19:08
Re: Query slow for new participants support@mekong.be 21:39

Feb. 27, 2019

Thread Author Time
Re: Query slow for new participants Laurenz Albe 07:58
What is pg_stat_user_tables Showing NULL for last_autoanalyze & last_autovacuum Fd Habash 14:47
Re: What is pg_stat_user_tables Showing NULL for last_autoanalyze & last_autovacuum Justin Pryzby 16:15

Feb. 28, 2019

Thread Author Time
Re: What is pg_stat_user_tables Showing NULL for last_autoanalyze & last_autovacuum Laurenz Albe 08:44
How to get the content of Bind variables ROS Didier 12:21
Re: How to get the content of Bind variables MichaelDBA 12:36

Browse Archives

Prev | Next