pgsql-performance since 2019-01-19 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. 19, 2019

Thread Author Time
Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 Amit Langote 12:17

Jan. 21, 2019

Thread Author Time
Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 Etsuro Fujita 08:17
Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 Amit Langote 08:21
Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 Etsuro Fujita 08:56
Memory and hard ware calculation : Rangaraj G 11:24
Re: Memory and hard ware calculation : Cleiton Luiz Domazak 17:43

Jan. 22, 2019

Thread Author Time
Re: Memory and hard ware calculation : Fabio Pardi 08:11
RE: Memory and hard ware calculation : Rangaraj G 12:54
Very long query planning times for database with lots of partitions Mickael van der Beek 13:44
Re: Very long query planning times for database with lots of partitions Justin Pryzby 14:02
RE: Very long query planning times for database with lots of partitions Steven Winfield 14:07
Re: Very long query planning times for database with lots of partitions Mickael van der Beek 15:24
Re: [HACKERS] proposal: schema variables 📎 Pavel Stehule 19:32
SELECT performance drop Jan Nielsen 20:04
Re: Memory and hard ware calculation : Ron 20:05
Re: SELECT performance drop Jan Nielsen 21:00
ANALYZE accuracy problems for n_distinct, and a solution Jim Finnerty 21:13
Re: SELECT performance drop legrand legrand 21:55
Re: SELECT performance drop Jan Nielsen 22:28

Jan. 23, 2019

Thread Author Time
Re: SELECT performance drop Jim Finnerty 13:50
ERROR: found xmin from before relfrozenxid Mariel Cherkassky 15:25
Re: SELECT performance drop Jan Nielsen 17:28
Benchmarking: How to identify bottleneck (limiting factor) and achieve "linear scalability"? Saurabh Nanda 19:16
RE:SELECT performance drop legrand legrand 19:37
Re: ERROR: found xmin from before relfrozenxid Jerry Sievers 19:42
Re: SELECT performance drop Laurenz Albe 22:41

Jan. 24, 2019

Thread Author Time
Re: ERROR: found xmin from before relfrozenxid Mariel Cherkassky 06:32
Re: Parallel stats in execution plans David Conlin 08:18
Re: Parallel stats in execution plans David Rowley 11:55
Re: ERROR: found xmin from before relfrozenxid Mariel Cherkassky 14:14
RE: dsa_allocate() faliure 📎 Arne Roland 14:44
Re: SELECT performance drop Jan Nielsen 16:52
Re: SELECT performance drop Jan Nielsen 18:04

Jan. 25, 2019

Thread Author Time
Zero throughput on a query on a very large table. [email protected] 05:20
Re: Zero throughput on a query on a very large table. Andreas Kretschmer 05:54
Re: Zero throughput on a query on a very large table. Tom Lane 06:24
Re: Zero throughput on a query on a very large table. David Rowley 06:55
Re: Benchmarking: How to identify bottleneck (limiting factor) and achieve "linear scalability"? Saurabh Nanda 07:17
Re: ERROR: found xmin from before relfrozenxid Adrien NAYRAT 08:18
Re: ERROR: found xmin from before relfrozenxid Mariel Cherkassky 17:20
RE: Zero throughput on a query on a very large table. [email protected] 17:47
Re: Zero throughput on a query on a very large table. [email protected] 18:00
Re: Zero throughput on a query on a very large table. Tom Lane 18:10
Re: Zero throughput on a query on a very large table. [email protected] 18:20
Re: Zero throughput on a query on a very large table. [email protected] 18:29
Re: Zero throughput on a query on a very large table. Tom Lane 18:34
Re: Zero throughput on a query on a very large table. [email protected] 18:36
Re: Zero throughput on a query on a very large table. [email protected] 19:06
Re: Zero throughput on a query on a very large table. [email protected] 19:24
Re: Zero throughput on a query on a very large table. Tom Lane 20:04
Re: Zero throughput on a query on a very large table. [email protected] 20:31

Jan. 26, 2019

Thread Author Time
Re: ERROR: found xmin from before relfrozenxid Adrien NAYRAT 10:48
Re: ERROR: found xmin from before relfrozenxid Mariel Cherkassky 10:56
Re: ERROR: found xmin from before relfrozenxid Adrien NAYRAT 10:59
Re: Benchmarking: How to identify bottleneck (limiting factor) and achieve "linear scalability"? Saurabh Nanda 11:10

Jan. 27, 2019

Thread Author Time
Re: Benchmarking: How to identify bottleneck (limiting factor) and achieve "linear scalability"? Saurabh Nanda 07:39
Q on SQL Performance tuning Bhupathi, Kaushik (CORP) 08:43
Re: Q on SQL Performance tuning legrand legrand 11:28
Re: Q on SQL Performance tuning Justin Pryzby 14:31
Re: Benchmarking: How to identify bottleneck (limiting factor) and achieve "linear scalability"? Justin Pryzby 16:04
Re: Benchmarking: How to identify bottleneck (limiting factor) and achieve "linear scalability"? Saurabh Nanda 16:38
Re: Benchmarking: How to identify bottleneck (limiting factor) and achieve "linear scalability"? Jeff Janes 17:48
Re: Benchmarking: How to identify bottleneck (limiting factor) and achieve "linear scalability"? Jeff Janes 19:41

Jan. 28, 2019

Thread Author Time
Re: Benchmarking: How to identify bottleneck (limiting factor) and achieve "linear scalability"? Saurabh Nanda 04:52
Re: Benchmarking: How to identify bottleneck (limiting factor) and achieve "linear scalability"? Saurabh Nanda 04:59
Re: Benchmarking: How to identify bottleneck (limiting factor) and achieve "linear scalability"? Saurabh Nanda 05:03
upgrade from 9.6 to 10/11 Mariel Cherkassky 10:04
Re: upgrade from 9.6 to 10/11 Laurenz Albe 10:20
RE: dsa_allocate() faliure Arne Roland 13:50
Re: Benchmarking: How to identify bottleneck (limiting factor) and achieve "linear scalability"? Saurabh Nanda 14:03
Re: Benchmarking: How to identify bottleneck (limiting factor) and achieve "linear scalability"? Nicolas Charles 14:22
Re: upgrade from 9.6 to 10/11 Justin Pryzby 15:43
Re: Benchmarking: How to identify bottleneck (limiting factor) and achieve "linear scalability"? Saurabh Nanda 15:55
Re: Benchmarking: How to identify bottleneck (limiting factor) and achieve "linear scalability"? Nicolas Charles 16:06
Re: Benchmarking: How to identify bottleneck (limiting factor) and achieve "linear scalability"? Saurabh Nanda 16:35
Re: Benchmarking: How to identify bottleneck (limiting factor) and achieve "linear scalability"? Saurabh Nanda 16:56
Re: dsa_allocate() faliure Thomas Munro 18:56

Jan. 29, 2019

Thread Author Time
Re: Benchmarking: How to identify bottleneck (limiting factor) and achieve "linear scalability"? Saurabh Nanda 01:44
Re: Benchmarking: How to identify bottleneck (limiting factor) and achieve "linear scalability"? Saurabh Nanda 04:48
Re: Benchmarking: How to identify bottleneck (limiting factor) and achieve "linear scalability"? Saurabh Nanda 06:15
pg_locks - what is a virtualxid locktype Mariel Cherkassky 08:57
Re: Benchmarking: How to identify bottleneck (limiting factor) and achieve "linear scalability"? Nicolas Charles 09:14
Re: pg_locks - what is a virtualxid locktype Shreeyansh Dba 09:33
Re: dsa_allocate() faliure Fabio Isabettini 11:32
Will higher shared_buffers improve tpcb-like benchmarks? Saurabh Nanda 11:39
Re: Will higher shared_buffers improve tpcb-like benchmarks? Joe Mirabal 12:12
Interpreting shared_buffers setting Bob Jolliffe 12:32
Re: Interpreting shared_buffers setting Thomas Markus 12:35
Re: Interpreting shared_buffers setting Andrew Gierth 13:07
Re: pg_locks - what is a virtualxid locktype Alvaro Herrera 15:12
Re: Benchmarking: How to identify bottleneck (limiting factor) and achieve "linear scalability"? Jeff Janes 15:42
Re: Interpreting shared_buffers setting Bob Jolliffe 15:42
Re: Will higher shared_buffers improve tpcb-like benchmarks? Jeff Janes 18:00
Re: Will higher shared_buffers improve tpcb-like benchmarks? Saurabh Nanda 18:10
How can sort performance be so different Bob Jolliffe 18:29
Re: Interpreting shared_buffers setting Jerry Sievers 18:31
Re: How can sort performance be so different Pavel Stehule 18:33
Re: How can sort performance be so different Saurabh Nanda 18:36
Re: Interpreting shared_buffers setting Jerry Sievers 18:40
Re: How can sort performance be so different Tom Lane 18:47

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

Browse Archives

Prev | Next