pgsql-performance since 2018-12-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

Dec. 30, 2018

Thread Author Time
Re: Need help with optimising simple query Jim Finnerty 01:25
Re: Need help with optimising simple query Jim Finnerty 01:31

Dec. 31, 2018

Thread Author Time
Re: [HACKERS] proposal: schema variables 📎 Pavel Stehule 13:23
Re: [HACKERS] proposal: schema variables Erik Rijkers 15:40
Re: [HACKERS] proposal: schema variables 📎 Pavel Stehule 17:33

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

Browse Archives

Prev | Next