pgsql-performance - October 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 6 7 8 9 10 11 12 13 14 15 16 17 18 21 22 28 29 30 31

Oct. 1, 2019

Thread Author Time
Slow PostgreSQL 10.6 query Behrang Saeedzadeh 12:37
Re: Slow PostgreSQL 10.6 query Tom Lane 13:27
Re: Slow PostgreSQL 10.6 query Behrang Saeedzadeh 13:42

Oct. 2, 2019

Thread Author Time
pg12 - partition by column that might have null values Mariel Cherkassky 06:17
Re: pg12 - partition by column that might have null values Laurenz Albe 07:29
Re: pg12 - partition by column that might have null values Mariel Cherkassky 07:37
RE: pg12 - partition by column that might have null values Mike Sofen 12:08
Re: pg12 - partition by column that might have null values Mariel Cherkassky 13:44
RE: pg12 - partition by column that might have null values Mike Sofen 23:14

Oct. 3, 2019

Thread Author Time
Re: pg12 - partition by column that might have null values Mariel Cherkassky 07:30
Re: pg12 - partition by column that might have null values Michael Lewis 17:55
Some observations on very slow pg_restore operations Ogden Brash 20:30
Re: Some observations on very slow pg_restore operations MichaelDBA 21:48
Re: Some observations on very slow pg_restore operations Ogden Brash 23:19

Oct. 4, 2019

Thread Author Time
Re: [HACKERS] proposal: schema variables 📎 Pavel Stehule 04:12
Re: Some observations on very slow pg_restore operations Justin Pryzby 06:03
Query went slow all of sudden. ON V 11.3 nikhil raj 10:22
Re: Query went slow all of sudden. ON V 11.3 Justin Pryzby 13:20
Re: Query went slow all of sudden. ON V 11.3 nikhil raj 13:58
Re: Query went slow all of sudden. ON V 11.3 Michael Lewis 19:07

Oct. 6, 2019

Thread Author Time
Re: Query went slow all of sudden. ON V 11.3 Tomas Vondra 20:30
Re: Slow PostgreSQL 10.6 query Tomas Vondra 20:37
Re: Delete huge Table under XFS Tomas Vondra 20:54
Re: Out of Memory errors are frustrating as heck! Tomas Vondra 21:06
Re: Out of Memory errors are frustrating as heck! Tomas Vondra 21:11

Oct. 7, 2019

Thread Author Time
Re: Slow PostgreSQL 10.6 query Behrang Saeedzadeh 08:27
Re: distinct on extract returns composite type Michael Lewis 21:53

Oct. 8, 2019

Thread Author Time
Re: Out of Memory errors are frustrating as heck! Merlin Moncure 17:44
Re: Out of Memory errors are frustrating as heck! Merlin Moncure 17:50
Modification of data in base folder and very large tables Ogden Brash 20:20
Would SSD improve Index Only Scan performance by a lot? Arya F 23:37
Sv: Would SSD improve Index Only Scan performance by a lot? Andreas Joseph Krogh 23:42

Oct. 9, 2019

Thread Author Time
Re: Would SSD improve Index Only Scan performance by a lot? Rick Otten 00:12
Re: Would SSD improve Index Only Scan performance by a lot? Matthew Hall 03:17
Get the planner used by a query? Behrang Saeedzadeh 06:21
Re: Modification of data in base folder and very large tables Andrew Gierth 08:42
Query slow again after adding an `OR` operation (was: Slow PostgreSQL 10.6 query) Behrang Saeedzadeh 12:07
Query slows when used with view Yavuz Selim Sertoğlu (ETIYA) 12:31
Re: Query slows when used with view Tom Lane 13:57
RE: Query slows when used with view Yavuz Selim Sertoğlu (ETIYA) 14:55
Re: Query slows when used with view Michael Lewis 15:23
Re: Query slows when used with view Jeff Janes 15:24
Re: Query slows when used with view Michael Lewis 15:32
Re: Query slows when used with view Tom Lane 16:07
Re: Get the planner used by a query? David Rowley 18:15
Re: Modification of data in base folder and very large tables Jeff Janes 18:42
Re: Query slow again after adding an `OR` operation (was: Slow PostgreSQL 10.6 query) Michael Lewis 19:36
Re: Would SSD improve Index Only Scan performance by a lot? Jeff Janes 19:54
Re: Query slow again after adding an `OR` operation (was: Slow PostgreSQL 10.6 query) David Rowley 22:06
Re: Modification of data in base folder and very large tables Jerry Sievers 23:05

Oct. 10, 2019

Thread Author Time
Re: Modification of data in base folder and very large tables Ogden Brash 05:01
Re: [HACKERS] proposal: schema variables 📎 Pavel Stehule 09:41
Re: Modification of data in base folder and very large tables Andrew Gierth 12:05

Oct. 11, 2019

Thread Author Time
Re: Modification of data in base folder and very large tables Jeff Janes 01:08

Oct. 12, 2019

Thread Author Time
Optimising a two column OR check Ivan Voras 14:39
Re: Optimising a two column OR check Justin Pryzby 14:43
Re: Optimising a two column OR check Andrew Gierth 15:16
Re: Optimising a two column OR check Jeff Janes 15:17
Re: Optimising a two column OR check MichaelDBA 15:27
Re: Optimising a two column OR check Andrew Gierth 15:33
Re: Optimising a two column OR check MichaelDBA 15:33
Re: Optimising a two column OR check MichaelDBA 15:35
Re: Optimising a two column OR check MichaelDBA 15:45
Re: Optimising a two column OR check Andrew Gierth 15:46
Re: Optimising a two column OR check MichaelDBA 15:54
Re: Optimising a two column OR check Andrew Gierth 16:58

Oct. 13, 2019

Thread Author Time
Re: Optimising a two column OR check Ivan Voras 13:29
Re: Optimising a two column OR check Ivan Voras 13:38

Oct. 14, 2019

Thread Author Time
pg_stat_bgwriter dangal 01:27
Re: pg_stat_bgwriter Tomas Vondra 18:18
Re: pg_stat_bgwriter dangal 20:12
Re: pg_stat_bgwriter Justin Pryzby 22:16

Oct. 15, 2019

Thread Author Time
Re: pg_stat_bgwriter Tomas Vondra 00:39
Change in CTE treatment in query plans? David Conlin 11:28

Oct. 16, 2019

Thread Author Time
Re: pg_stat_bgwriter dangal 17:37
Re: pg_stat_bgwriter dangal 19:13

Oct. 17, 2019

Thread Author Time
Re: Change in CTE treatment in query plans? Tom Lane 09:04
Can you please tell us how set this prefetch attribute in following lines. M Tarkeshwar Rao 11:16
Re: Can you please tell us how set this prefetch attribute in following lines. Reid Thompson 16:18
Re: Can you please tell us how set this prefetch attribute in following lines. Laurenz Albe 17:05
Reading explain plans- row estimates/actuals on lower nodes vs next level up Michael Lewis 21:15
Re: pg_stat_bgwriter Jeff Janes 23:47

Oct. 18, 2019

Thread Author Time
Re: Reading explain plans- row estimates/actuals on lower nodes vs next level up Tomas Vondra 00:13
Re: pg_stat_bgwriter dangal 00:50
Re: pg_stat_bgwriter dangal 00:55
Can you please tell us how set this prefetch attribute in following lines. M Tarkeshwar Rao 03:43
RE: Can you please tell us how set this prefetch attribute in following lines. M Tarkeshwar Rao 03:47
Can you please tell us how set this prefetch attribute in following lines. M Tarkeshwar Rao 03:47
Re: Can you please tell us how set this prefetch attribute in following lines. Justin Pryzby 16:15

Oct. 21, 2019

Thread Author Time
Re: Change in CTE treatment in query plans? David Conlin 13:22

Oct. 22, 2019

Thread Author Time
max_connections Joao Junior 12:28
Re: max_connections Pavel Stehule 12:39

Oct. 28, 2019

Thread Author Time
Notifications within triggers seem to compromise performance Grégoire de Turckheim 13:42
Re: Notifications within triggers seem to compromise performance Tom Lane 14:22
Re: Notifications within triggers seem to compromise performance Grégoire de Turckheim 15:39
Re: Notifications within triggers seem to compromise performance Tom Lane 16:25
Re: Notifications within triggers seem to compromise performance Grégoire de Turckheim 16:35
UNION causes horrible plan on JOIN Craig James 22:40
Re: UNION causes horrible plan on JOIN Justin Pryzby 22:45
Re: UNION causes horrible plan on JOIN Craig James 23:30
Re: UNION causes horrible plan on JOIN Craig James 23:37

Oct. 29, 2019

Thread Author Time
Re: UNION causes horrible plan on JOIN Kyotaro Horiguchi 03:24

Oct. 30, 2019

Thread Author Time
GIN index on JSONB not used due to lack of nested statistics Alessandro Baretta 16:24
RE: Can you please tell us how set this prefetch attribute in following lines. M Tarkeshwar Rao 16:47
Re: GIN index on JSONB not used due to lack of nested statistics Jeff Janes 22:31

Oct. 31, 2019

Thread Author Time
Barman Daulat Ram 17:29
Re: Barman Tomas Vondra 18:56

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 6 7 8 9 10 11 12 13 14 15 16 17 18 21 22 28 29 30 31