pgsql-performance - November 2018

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 5 6 8 9 10 13 15 17 19 20 21 22 23 24 25 26 27 28 29 30

Nov. 2, 2018

Thread Author Time
Fwd: Query with high planning time compared to execution time 📎 Richard Lee 09:36
Re: Fwd: Query with high planning time compared to execution time Tomas Vondra 13:55
Re: Fwd: Query with high planning time compared to execution time legrand legrand 22:51

Nov. 5, 2018

Thread Author Time
Re: Fwd: Query with high planning time compared to execution time Richard Lee 03:36
Re: Fwd: Query with high planning time compared to execution time Justin Pryzby 04:10
Re: Fwd: Query with high planning time compared to execution time 📎 Richard Lee 07:04
Re: Fwd: Query with high planning time compared to execution time Justin Pryzby 13:55

Nov. 6, 2018

Thread Author Time
Re: Fwd: Query with high planning time compared to execution time Richard Lee 11:40

Nov. 8, 2018

Thread Author Time
NOT IN vs. NOT EXISTS performance Lincoln Swaine-Moore 19:35
Re: NOT IN vs. NOT EXISTS performance David Rowley 21:11

Nov. 9, 2018

Thread Author Time
Re: NOT IN vs. NOT EXISTS performance Merlin Moncure 13:45

Nov. 10, 2018

Thread Author Time
Re: NOT IN vs. NOT EXISTS performance Lincoln Swaine-Moore 00:06

Nov. 13, 2018

Thread Author Time
Re: dsa_allocate() faliure Jakub Glapa 13:08

Nov. 15, 2018

Thread Author Time
checkpoint occurs very often when vacuum full running Mariel Cherkassky 18:53
Re: checkpoint occurs very often when vacuum full running Sergei Kornilov 19:10
Re: checkpoint occurs very often when vacuum full running Mariel Cherkassky 19:29
Re: checkpoint occurs very often when vacuum full running Sergei Kornilov 20:28
Re: checkpoint occurs very often when vacuum full running Laurenz Albe 20:32
Re: checkpoint occurs very often when vacuum full running Justin Pryzby 20:46

Nov. 17, 2018

Thread Author Time
Re: checkpoint occurs very often when vacuum full running Mariel Cherkassky 11:31
Re: checkpoint occurs very often when vacuum full running Mariel Cherkassky 11:36
Re: checkpoint occurs very often when vacuum full running Laurenz Albe 19:28

Nov. 19, 2018

Thread Author Time
PostgreSQL VS MongoDB: a use case comparison Fabio Pardi 15:38
Re: PostgreSQL VS MongoDB: a use case comparison Stephen Frost 17:26
autovacuum is running but pg_stat_all_tables empty Mariel Cherkassky 17:31
Re: autovacuum is running but pg_stat_all_tables empty Laurenz Albe 18:52

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

Browse Archives

Prev | Next
Jump to day: 1 2 5 6 8 9 10 13 15 17 19 20 21 22 23 24 25 26 27 28 29 30