pgsql-performance - January 2019

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 3 4 5 7 8 9 10 11 12 14 15 16 17 18 19 21 22 23 24 25 26 27 28 29 30 31

Jan. 2, 2019

Thread Author Time
select query does not pick up the right index Abadie Lana 16:28
Re: select query does not pick up the right index Justin Pryzby 16:45

Jan. 3, 2019

Thread Author Time
Re: select query does not pick up the right index David Rowley 00:15
RE: select query does not pick up the right index Abadie Lana 12:57
RE: select query does not pick up the right index Abadie Lana 12:58
Re: select query does not pick up the right index David Rowley 13:01
RE: select query does not pick up the right index Abadie Lana 13:13
Re: select query does not pick up the right index David Rowley 13:17
RE: select query does not pick up the right index Abadie Lana 13:20
RE: select query does not pick up the right index Abadie Lana 14:34
Re: select query does not pick up the right index David Rowley 21:42
Re: select query does not pick up the right index Justin Pryzby 23:47

Jan. 4, 2019

Thread Author Time
RE: select query does not pick up the right index Abadie Lana 08:10
RE: select query does not pick up the right index Abadie Lana 08:17
RE: select query does not pick up the right index Abadie Lana 08:58

Jan. 5, 2019

Thread Author Time
Re: select query does not pick up the right index Justin Pryzby 04:23

Jan. 7, 2019

Thread Author Time
RE: select query does not pick up the right index Abadie Lana 16:09

Jan. 8, 2019

Thread Author Time
Re: select query does not pick up the right index Justin Pryzby 08:15

Jan. 9, 2019

Thread Author Time
Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 Amit Langote 00:30
postgresql unix socket connections Mariel Cherkassky 08:35
Re: postgresql unix socket connections Mariel Cherkassky 08:46
Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 📎 Etsuro Fujita 11:20
RE: select query does not pick up the right index Abadie Lana 12:55
Re: postgresql unix socket connections Tom Lane 14:55
Re: postgresql unix socket connections Mariel Cherkassky 15:08
Re: postgresql unix socket connections Jeff Janes 15:09
Re: postgresql unix socket connections Jeff Janes 15:13
Re: postgresql unix socket connections Mariel Cherkassky 15:17
Re: postgresql unix socket connections Tom Lane 16:11
Re: select query does not pick up the right index David Rowley 16:41
Re: PostgreSQL Read IOPS limit per connection Merlin Moncure 19:14
Re: select query does not pick up the right index Abadie Lana 19:22
Re: PostgreSQL Read IOPS limit per connection Haroldo Kerry 21:52
Re: PostgreSQL Read IOPS limit per connection Merlin Moncure 22:47

Jan. 10, 2019

Thread Author Time
Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 Amit Langote 01:41
Re: PostgreSQL Read IOPS limit per connection Mark Hogg 02:49
Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 Etsuro Fujita 06:07
does dml operations load the blocks to the shared buffers ? Mariel Cherkassky 08:06
Re: postgresql unix socket connections Mariel Cherkassky 08:22
Re: does dml operations load the blocks to the shared buffers ? Guillaume Lelarge 08:55
Re: postgresql unix socket connections Ken Tanzer 09:41
Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 Ashutosh Bapat 09:49
Re: postgresql unix socket connections Mariel Cherkassky 10:36
Re: does dml operations load the blocks to the shared buffers ? Mariel Cherkassky 10:40
Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 Amit Langote 12:23
Detect missing combined indexes (automatically) Thomas Güttler 12:56
Re: does dml operations load the blocks to the shared buffers ? Guillaume Lelarge 18:42

Jan. 11, 2019

Thread Author Time
Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 Etsuro Fujita 02:21
Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 📎 Amit Langote 04:46
Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 Amit Langote 04:49
Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 Etsuro Fujita 11:04
Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 Etsuro Fujita 11:10
Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 📎 Etsuro Fujita 12:50

Jan. 12, 2019

Thread Author Time
Re: Detect missing combined indexes (automatically) Jim Finnerty 15:47

Jan. 14, 2019

Thread Author Time
Re: Detect missing combined indexes (automatically) Thomas Kellerer 07:19
Re: Detect missing combined indexes (automatically) Julien Rouhaud 07:42

Jan. 15, 2019

Thread Author Time
Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 Amit Langote 01:46
Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 Amit Langote 01:51
Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 Amit Langote 02:42
Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 Ashutosh Bapat 04:29
Re: Detect missing combined indexes (automatically) Thomas Güttler 09:23
Re: Detect missing combined indexes (automatically) Julien Rouhaud 10:25

Jan. 16, 2019

Thread Author Time
Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 Etsuro Fujita 05:41
Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 Etsuro Fujita 05:45
Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 Etsuro Fujita 05:52
No matching tables have ever been vacuumed Daulat Ram 07:06
Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 Etsuro Fujita 11:21
Parallel stats in execution plans David Conlin 11:31

Jan. 17, 2019

Thread Author Time
Re: No matching tables have ever been vacuumed Laurenz Albe 09:49
autovacuum doesnt run on the pg_toast_id table Mariel Cherkassky 17:28
Re: autovacuum doesnt run on the pg_toast_id table Justin Pryzby 17:46
Re: autovacuum doesnt run on the pg_toast_id table Alvaro Herrera 17:52
Re: autovacuum doesnt run on the pg_toast_id table Mariel Cherkassky 17:58
Re: autovacuum doesnt run on the pg_toast_id table Alvaro Herrera 19:09
Re: autovacuum doesnt run on the pg_toast_id table Mariel Cherkassky 19:59
Re: autovacuum doesnt run on the pg_toast_id table Alvaro Herrera 20:16
Re: autovacuum doesnt run on the pg_toast_id table Mariel Cherkassky 20:18

Jan. 18, 2019

Thread Author Time
Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 📎 Etsuro Fujita 12:55
JIT overhead slowdown 📎 Luis Carril 14:12
Re: JIT overhead slowdown Andres Freund 16:42
Re: JIT overhead slowdown Luis Carril 18:02

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. ldh@laurent-hasson.com 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. ldh@laurent-hasson.com 17:47
Re: Zero throughput on a query on a very large table. ldh@laurent-hasson.com 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. ldh@laurent-hasson.com 18:20
Re: Zero throughput on a query on a very large table. ldh@laurent-hasson.com 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. ldh@laurent-hasson.com 18:36
Re: Zero throughput on a query on a very large table. ldh@laurent-hasson.com 19:06
Re: Zero throughput on a query on a very large table. ldh@laurent-hasson.com 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. ldh@laurent-hasson.com 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

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 7 8 9 10 11 12 14 15 16 17 18 19 21 22 23 24 25 26 27 28 29 30 31