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

Nov. 20, 2018

Thread Author Time
Re: PostgreSQL VS MongoDB: a use case comparison Fabio Pardi 13:11
Re: PostgreSQL VS MongoDB: a use case comparison Stephen Frost 13:34
Re: PostgreSQL VS MongoDB: a use case comparison Fabio Pardi 15:53
Re: PostgreSQL VS MongoDB: a use case comparison Merlin Moncure 16:41
Re: PostgreSQL VS MongoDB: a use case comparison Stephen Frost 16:43
Re: PostgreSQL VS MongoDB: a use case comparison Merlin Moncure 17:02
Re: PostgreSQL VS MongoDB: a use case comparison Stephen Frost 17:28
Re: PostgreSQL VS MongoDB: a use case comparison Merlin Moncure 19:45
Re: PostgreSQL VS MongoDB: a use case comparison Stephen Frost 19:46

Nov. 21, 2018

Thread Author Time
Re: PostgreSQL VS MongoDB: a use case comparison Thomas Kellerer 06:48
Re: [HACKERS] proposal: schema variables 📎 Pavel Stehule 07:24
Re: dsa_allocate() faliure Jakub Glapa 14:26

Nov. 22, 2018

Thread Author Time
Re: performance statistics monitoring without spamming logs Justin Pryzby 05:41
Re: performance statistics monitoring without spamming logs Adrien NAYRAT 08:20
Re: dsa_allocate() faliure Justin Pryzby 16:09
Performance impact of updating target columns with unchanged values ON CONFLICT Abi Noda 19:32
Re: Performance impact of updating target columns with unchanged values ON CONFLICT Abi Noda 21:31
Re: Performance impact of updating target columns with unchanged values ON CONFLICT Justin Pryzby 22:40

Nov. 23, 2018

Thread Author Time
Re: dsa_allocate() faliure Jakub Glapa 14:31
Re: dsa_allocate() faliure Justin Pryzby 16:10

Nov. 24, 2018

Thread Author Time
Re: Performance impact of updating target columns with unchanged values ON CONFLICT Abi Noda 03:44
Re: Performance impact of updating target columns with unchanged values ON CONFLICT Abi Noda 03:53

Nov. 25, 2018

Thread Author Time
explain analyze faster then query Mariel Cherkassky 13:08
Re: explain analyze faster then query Justin Pryzby 13:30
Re: explain analyze faster then query Mariel Cherkassky 13:37
Re: explain analyze faster then query Justin Pryzby 14:12

Nov. 26, 2018

Thread Author Time
Optimizer choosing the wrong plan Viswanath 10:11
autovacuum run but last_autovacuum is empty Mariel Cherkassky 15:12
Re: autovacuum run but last_autovacuum is empty Tom Lane 15:24
Re: dsa_allocate() faliure Jakub Glapa 15:26
Re: dsa_allocate() faliure Jakub Glapa 15:38
Re: autovacuum run but last_autovacuum is empty Mariel Cherkassky 15:51
Re: dsa_allocate() faliure Justin Pryzby 15:52
Re: Optimizer choosing the wrong plan Jeff Janes 15:53
Re: dsa_allocate() faliure Jakub Glapa 16:00
Re: autovacuum run but last_autovacuum is empty Tom Lane 16:10
Re: dsa_allocate() faliure Alvaro Herrera 18:45

Nov. 27, 2018

Thread Author Time
Re: dsa_allocate() faliure Thomas Munro 03:00
Re: dsa_allocate() faliure Thomas Munro 08:02
Query with high planning time at version 11.1 compared versions 10.5 and 11.0 Sanyo Moura 14:16
Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 Tom Lane 15:00
Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 Sanyo Moura 15:11
Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 Jeff Janes 19:34
Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 Sanyo Moura 20:20
Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 Sanyo Moura 20:30
Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 Justin Pryzby 21:10

Nov. 28, 2018

Thread Author Time
Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 Justin Pryzby 00:44
Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 Sanyo Moura 01:00
Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 Justin Pryzby 01:27
Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 Sanyo Moura 01:36
Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 Justin Pryzby 03:01
Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 David Rowley 04:03
Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 Justin Pryzby 04:17
Slow Bitmap Index Scan Scott Rankin 19:08
Re: Slow Bitmap Index Scan Justin Pryzby 19:17
Re: Slow Bitmap Index Scan Scott Rankin 19:31

Nov. 29, 2018

Thread Author Time
Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 Justin Pryzby 00:40
Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 Sanyo Moura 01:01
Re: PostgreSQL VS MongoDB: a use case comparison Oleg Bartunov 21:14

Nov. 30, 2018

Thread Author Time
Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 Sanyo Moura 14:37
Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 Pavel Stehule 14:54
Re: dsa_allocate() faliure Jakub Glapa 19:20
Re: dsa_allocate() faliure Justin Pryzby 20:46
Re: [HACKERS] proposal: schema variables Dmitry Dolgov 23:17

Dec. 1, 2018

Thread Author Time
Re: [HACKERS] proposal: schema variables 📎 Pavel Stehule 06:32

Dec. 2, 2018

Thread Author Time
Re: dsa_allocate() faliure 📎 Thomas Munro 22:45

Dec. 3, 2018

Thread Author Time
Re: Slow Bitmap Index Scan Scott Rankin 18:41
Re: Slow Bitmap Index Scan Alan Hodgson 18:51

Dec. 4, 2018

Thread Author Time
Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 Alvaro Herrera 21:43
Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 Alvaro Herrera 21:55

Dec. 6, 2018

Thread Author Time
Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 📎 Amit Langote 02:14
Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 Amit Langote 02:19
Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 Amit Langote 04:50
Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 Amit Langote 05:00
Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 Alvaro Herrera 07:55
Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 Alvaro Herrera 07:57

Dec. 7, 2018

Thread Author Time
Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 Ashutosh Bapat 05:43
Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 Ashutosh Bapat 11:14

Dec. 8, 2018

Thread Author Time
amazon aroura config - seriously overcommited defaults? (May be Off Topic) Square Bob 19:00
Fwd: amazon aroura config - seriously overcommited defaults? (May be Off Topic) Square Bob 19:03
Re: amazon aroura config - seriously overcommited defaults? (May be Off Topic) Pavel Stehule 19:21
Re: amazon aroura config - seriously overcommited defaults? (May be Off Topic) Bob Lunney 19:48
Re: amazon aroura config - seriously overcommited defaults? (May be Off Topic) Jeremy Schneider 20:06
Re: amazon aroura config - seriously overcommited defaults? (May be Off Topic) Andres Freund 23:12
Re: amazon aroura config - seriously overcommited defaults? (May be Off Topic) Rob Sargent 23:23
Re: amazon aroura config - seriously overcommited defaults? (May be Off Topic) Andres Freund 23:38

Dec. 9, 2018

Thread Author Time
Re: amazon aroura config - seriously overcommited defaults? (May be Off Topic) Andrew Dunstan 12:51
Database size 1T but unclear why Mariel Cherkassky 15:18
Re: amazon aroura config - seriously overcommited defaults? (May be Off Topic) Square Bob 15:20
Re: Database size 1T but unclear why Rick Otten 15:42
Re: Database size 1T but unclear why Justin Pryzby 16:01

Dec. 10, 2018

Thread Author Time
database crash during pgbench run Mariel Cherkassky 17:18
Re: database crash during pgbench run Tom Lane 17:44

Dec. 11, 2018

Thread Author Time
RE: database crash during pgbench run Greg Clough 14:35
Re: database crash during pgbench run Tom Lane 16:01
Re: Database size 1T but unclear why Justin Pryzby 18:55

Dec. 12, 2018

Thread Author Time
pgbench results arent accurate Mariel Cherkassky 12:53
Re: PostgreSQL VS MongoDB: a use case comparison Nicolas Paris 22:37

Dec. 13, 2018

Thread Author Time
RE: pgbench results arent accurate Greg Clough 13:05

Dec. 14, 2018

Thread Author Time
Re: pgbench results arent accurate Mark Kirkwood 23:46

Dec. 16, 2018

Thread Author Time
Re: pgbench results arent accurate Mariel Cherkassky 11:58

Dec. 18, 2018

Thread Author Time
Why Postgres doesn't use TID scan? Vladimir Ryabtsev 01:16
Re: Why Postgres doesn't use TID scan? Tom Lane 01:40
Re: Why Postgres doesn't use TID scan? Vladimir Ryabtsev 01:54
Re: Why Postgres doesn't use TID scan? Tom Lane 02:32
Re: Why Postgres doesn't use TID scan? Vladimir Ryabtsev 02:40
Re: pgbench results arent accurate Mark Kirkwood 03:10
Re: Why Postgres doesn't use TID scan? Alvaro Herrera 16:40

Dec. 19, 2018

Thread Author Time
Increasing parallelism of queries while using file fdw and partitions Patrick Mulrooney 04:39
SQL Perfomance during autovacuum anand086 06:04
Re: SQL Perfomance during autovacuum David Rowley 06:33
Re: Increasing parallelism of queries while using file fdw and partitions Justin Pryzby 06:51
Re: Increasing parallelism of queries while using file fdw and partitions Patrick Mulrooney 07:36
Re: Why Postgres doesn't use TID scan? Andrew Gierth 11:41
Re: Why Postgres doesn't use TID scan? Vladimir Ryabtsev 20:22
Re: Why Postgres doesn't use TID scan? Andrew Gierth 22:23
Re: Why Postgres doesn't use TID scan? Vladimir Ryabtsev 23:44

Dec. 20, 2018

Thread Author Time
Re: Why Postgres doesn't use TID scan? Rick Otten 13:46
Re: pgbench results arent accurate Merlin Moncure 16:46

Dec. 21, 2018

Thread Author Time
Re: database crash during pgbench run Merlin Moncure 13:40
psql cli tool and connection pooling DJ Coertzen 19:08

Dec. 22, 2018

Thread Author Time
Re: SQL Perfomance during autovacuum Jeff Janes 00:13

Dec. 27, 2018

Thread Author Time
PostgreSQL Read IOPS limit per connection Haroldo Kerry 16:44
Re: PostgreSQL Read IOPS limit per connection Justin Pryzby 16:55
Query Performance Issue neslişah demirci 19:25
Re: PostgreSQL Read IOPS limit per connection Haroldo Kerry 19:33

Dec. 28, 2018

Thread Author Time
Re: PostgreSQL Read IOPS limit per connection Jeff Janes 01:20
Re: PostgreSQL Read IOPS limit per connection Justin Pryzby 01:29
Re: psql cli tool and connection pooling Sebastiaan Mannem 09:04
Re: Query Performance Issue Alexey Bashtanov 14:53
Re: Query Performance Issue Justin Pryzby 15:32

Dec. 29, 2018

Thread Author Time
Re: Query Performance Issue David Rowley 06:58
Re: Query Performance Issue Justin Pryzby 07:15
Re: Query Performance Issue Jim Finnerty 12:00
Re: Optimizer choosing the wrong plan Jim Finnerty 12:17
Re: Optimizer choosing the wrong plan Jeff Janes 17:14
Re: Gained %20 performance after disabling bitmapscan Jim Finnerty 20:11
Re: Query Performance Issue Jeff Janes 20:27
Re: Query Performance Issue David Rowley 22:00

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

Browse Archives

Prev | Next