pgsql-performance since 2019-11-18 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. 18, 2019

Thread Author Time
Out of memory error on automatic vacuum Ekaterina Amez 11:41
Re: Out of memory error on automatic vacuum Tomas Vondra 12:25
Re: Out of memory error on automatic vacuum Ekaterina Amez 14:02
Re: Out of memory error on automatic vacuum Tomas Vondra 14:16
Re: Out of memory error on automatic vacuum Ekaterina Amez 14:46
Re: Out of memory error on automatic vacuum Tomas Vondra 15:10
Wrong estimations and NL Anti join poor performance Andrew Zakharov 17:35
Re: [HACKERS] proposal: schema variables 📎 Pavel Stehule 18:47

Nov. 22, 2019

Thread Author Time
Postgresql planning time too high 📎 Sterpu Victor 11:21
RE: Postgresql planning time too high Fırat Güleç 11:35
Re[2]: Postgresql planning time too high 📎 Sterpu Victor 11:44
Re[2]: Postgresql planning time too high Sterpu Victor 11:46
RE: Re[2]: Postgresql planning time too high Fırat Güleç 12:05
Re: Postgresql planning time too high Luís Roberto Weck 12:22
Re[4]: Postgresql planning time too high Sterpu Victor 12:25
Re[4]: Postgresql planning time too high Sterpu Victor 12:44
Re[3]: Postgresql planning time too high Sterpu Victor 12:50
Re: Re[2]: Postgresql planning time too high Pavel Stehule 12:59
Re[4]: Postgresql planning time too high Sterpu Victor 13:45
Re[4]: Postgresql planning time too high Sterpu Victor 14:06
Re: Re[4]: Postgresql planning time too high Pavel Stehule 14:29
Hash Join over Nested Loop Luís Roberto Weck 17:33
Re: Hash Join over Nested Loop Luís Roberto Weck 17:43
Re: Hash Join over Nested Loop Pavel Stehule 17:55
Re: Re[4]: Postgresql planning time too high Michael Lewis 18:13
Re: Hash Join over Nested Loop Luís Roberto Weck 18:48
Re: Hash Join over Nested Loop Pavel Stehule 18:54
Re: Postgresql planning time too high Tomas Vondra 19:36

Nov. 24, 2019

Thread Author Time
performance degredation after upgrade from 9.6 to 12 Mariel Cherkassky 12:53
Re: performance degredation after upgrade from 9.6 to 12 Thomas Poty 13:15
Re: performance degredation after upgrade from 9.6 to 12 Andrew Zakharov 13:19
Re: performance degredation after upgrade from 9.6 to 12 Mariel Cherkassky 13:51
Re: performance degredation after upgrade from 9.6 to 12 Jeff Janes 15:22
Re: performance degredation after upgrade from 9.6 to 12 Jeff Janes 15:30
Re: performance degredation after upgrade from 9.6 to 12 Mariel Cherkassky 18:05
Re: performance degredation after upgrade from 9.6 to 12 John Felix 20:00
Re: performance degredation after upgrade from 9.6 to 12 Jeff Janes 20:50
Re: performance degredation after upgrade from 9.6 to 12 Mariel Cherkassky 21:49

Nov. 29, 2019

Thread Author Time
Considerable performance downgrade of v11 and 12 on Windows Eugene Podshivalov 10:04
Re: Considerable performance downgrade of v11 and 12 on Windows Thomas Kellerer 10:36
Re: Considerable performance downgrade of v11 and 12 on Windows Eugene Podshivalov 10:47
Re: Considerable performance downgrade of v11 and 12 on Windows Laurenz Albe 12:04
Re: Considerable performance downgrade of v11 and 12 on Windows Eugene Podshivalov 12:22
Logical replication performance Florian Philippon 16:06
Re: Logical replication performance Flavio Henrique Araque Gurgel 16:25

Nov. 30, 2019

Thread Author Time
Re: Considerable performance downgrade of v11 and 12 on Windows Eugene Podshivalov 19:47

Dec. 2, 2019

Thread Author Time
Re: Considerable performance downgrade of v11 and 12 on Windows Laurenz Albe 09:04
[External] Join queries slow with predicate, limit, and ordering Aufar Gilbran 12:43
Make recently inserted/updated records available in the buffer/cache Sachin Divekar 17:03
Re: Make recently inserted/updated records available in the buffer/cache Hüseyin Demir 17:13
Re: Make recently inserted/updated records available in the buffer/cache MichaelDBA 17:17
Re: Considerable performance downgrade of v11 and 12 on Windows Eugene Podshivalov 19:03

Dec. 3, 2019

Thread Author Time
Re: [External] Join queries slow with predicate, limit, and ordering Jeff Janes 00:38
Re: [External] Join queries slow with predicate, limit, and ordering Aufar Gilbran 07:50
Re: Make recently inserted/updated records available in the buffer/cache Michael Lewis 17:29
Re: Make recently inserted/updated records available in the buffer/cache MichaelDBA 17:32
Re: Make recently inserted/updated records available in the buffer/cache Sachin Divekar 18:45
Re: Make recently inserted/updated records available in the buffer/cache Michael Lewis 18:58
Re: performance degredation after upgrade from 9.6 to 12 Andres Freund 21:13

Dec. 5, 2019

Thread Author Time
How to run in parallel in Postgres Lars Aksel Opsahl 12:10
Re: How to run in parallel in Postgres Laurenz Albe 16:42
autovacuum locking question Mike Schanne 17:46
Postgres backup tool recommendations for multi-terabyte database in Google Cloud Craig Jackson 17:47
Re: Postgres backup tool recommendations for multi-terabyte database in Google Cloud Craig James 19:51
Re: Postgres backup tool recommendations for multi-terabyte database in Google Cloud Craig Jackson 21:05
Re: Postgres backup tool recommendations for multi-terabyte database in Google Cloud Nikolay Samokhvalov 21:08
Re: autovacuum locking question Michael Lewis 22:49
RE: autovacuum locking question Mike Schanne 23:18
Re: autovacuum locking question Tom Lane 23:49
Re: autovacuum locking question Jeff Janes 23:55

Dec. 6, 2019

Thread Author Time
Re: How to run in parallel in Postgres Lars Aksel Opsahl 08:39
RE: autovacuum locking question Mike Schanne 15:46
RE: autovacuum locking question Mike Schanne 15:55
Re: autovacuum locking question Tom Lane 17:12
unexpected result for wastedbytes query after vacuum full Mike Schanne 17:18
Re: autovacuum locking question Tom Lane 17:19
Re: autovacuum locking question Jeff Janes 17:47
Re: autovacuum locking question Justin Pryzby 17:49
Re: autovacuum locking question MichaelDBA 17:50
Legal disclaimers on emails to this group Craig James 18:42
Re: Legal disclaimers on emails to this group Tom Lane 19:27
threads (Re: Legal disclaimers on emails to this group) Justin Pryzby 21:55
Re: Legal disclaimers on emails to this group Tim Cross 22:42
Re: unexpected result for wastedbytes query after vacuum full Justin Pryzby 23:28

Dec. 7, 2019

Thread Author Time
Re: autovacuum locking question Jeff Janes 00:59
Re: How to run in parallel in Postgres Ondrej Ivanič 01:23
Re: How to run in parallel in Postgres Justin Pryzby 01:25
Re: How to run in parallel in Postgres Lars Aksel Opsahl 11:17
Re: How to run in parallel in Postgres Lars Aksel Opsahl 11:27
Re: Legal disclaimers on emails to this group Jean-David Beyer 12:10
Specific query taking time to process Fahiz Mohamed 20:05

Dec. 8, 2019

Thread Author Time
query that canceled isnt logged Mariel Cherkassky 13:08
Re: query that canceled isnt logged Tom Lane 15:05
Re: query that canceled isnt logged Mariel Cherkassky 15:18
Re: query that canceled isnt logged Mariel Cherkassky 15:23
Re: query that canceled isnt logged Tom Lane 15:42
Re: How to run in parallel in Postgres, EXECUTE_PARALLEL Lars Aksel Opsahl 18:14
Re: How to run in parallel in Postgres, EXECUTE_PARALLEL Joe Conway 20:04
Re: How to run in parallel in Postgres, EXECUTE_PARALLEL Lars Aksel Opsahl 21:59

Dec. 9, 2019

Thread Author Time
Re: Specific query taking time to process Justin Pryzby 04:13
Re: Specific query taking time to process Michael Lewis 19:03
Re: Logical replication performance Jeff Janes 22:31
Re: Specific query taking time to process Fahiz Mohamed 22:39
RE: Legal disclaimers on emails to this group Mike Schanne 23:05
RE: unexpected result for wastedbytes query after vacuum full Mike Schanne 23:06

Dec. 10, 2019

Thread Author Time
Re: unexpected result for wastedbytes query after vacuum full Guillaume Lelarge 16:43
Re: unexpected result for wastedbytes query after vacuum full Jeff Janes 19:48
Re: Specific query taking time to process Michael Lewis 20:15
Re: Specific query taking time to process Justin Pryzby 20:42

Dec. 11, 2019

Thread Author Time
Re: unexpected result for wastedbytes query after vacuum full Guillaume Lelarge 15:23
Re: Specific query taking time to process Fahiz Mohamed 19:53
Re: Specific query taking time to process Michael Lewis 20:09
Re: Specific query taking time to process Jeff Janes 21:14

Dec. 12, 2019

Thread Author Time
Re: Specific query taking time to process Jeff Janes 02:25
Re: Legal disclaimers on emails to this group Moreno Andreo 14:49
Re: Legal disclaimers on emails to this group Moreno Andreo 15:03

Dec. 14, 2019

Thread Author Time
Re: [HACKERS] proposal: schema variables 📎 Pavel Stehule 21:43

Dec. 16, 2019

Thread Author Time
Consecutive Query Executions with Increasing Execution Time Shijia Wei 05:59
Re: Consecutive Query Executions with Increasing Execution Time Olivier Gautherot 08:03
Re: Consecutive Query Executions with Increasing Execution Time Shijia Wei 09:51
Re: Consecutive Query Executions with Increasing Execution Time Olivier Gautherot 10:17
Re: performance degredation after upgrade from 9.6 to 12 Mariel Cherkassky 11:48
RE: performance degredation after upgrade from 9.6 to 12 Andrew Zakharov 12:27
Re: performance degredation after upgrade from 9.6 to 12 Mariel Cherkassky 13:01
Re: Consecutive Query Executions with Increasing Execution Time Laurenz Albe 13:25
Re: Consecutive Query Executions with Increasing Execution Time Tom Lane 13:50
Re: Consecutive Query Executions with Increasing Execution Time Shijia Wei 17:28
Re: performance degredation after upgrade from 9.6 to 12 Pavel Stehule 17:29
Re: Consecutive Query Executions with Increasing Execution Time Peter Geoghegan 20:39
Re: Consecutive Query Executions with Increasing Execution Time Tom Lane 20:50
Re: Consecutive Query Executions with Increasing Execution Time Nicolas Charles 22:08
Re: Consecutive Query Executions with Increasing Execution Time Tom Lane 22:48

Dec. 17, 2019

Thread Author Time
Re: Consecutive Query Executions with Increasing Execution Time Sam Gendler 00:53
weird long time query Kaijiang Chen 02:58
Re: Consecutive Query Executions with Increasing Execution Time Andres Freund 04:04
Re: weird long time query Pavel Stehule 11:08
Re: Consecutive Query Executions with Increasing Execution Time Laurenz Albe 13:08
Re: Consecutive Query Executions with Increasing Execution Time Jeff Janes 16:11
Re: weird long time query Tom Lane 17:04
shared memory size during upgrade pgsql with partitions Piotr Włodarczyk 20:03

Dec. 18, 2019

Thread Author Time
Re: weird long time query Kaijiang Chen 03:23
Fwd: weird long time query Kaijiang Chen 03:25
Re: shared memory size during upgrade pgsql with partitions (max_locks_per_transaction) Justin Pryzby 04:01
Re: shared memory size during upgrade pgsql with partitions (max_locks_per_transaction) Piotr Włodarczyk 09:16
How to prevent POSTGRES killing linux system from accepting too much inserts? James (王旭) 09:53
Re: Consecutive Query Executions with Increasing Execution Time Laurenz Albe 12:17
Re: Consecutive Query Executions with Increasing Execution Time Tom Lane 13:44
Re: Fwd: weird long time query hubert depesz lubaczewski 14:06
Re: Fwd: weird long time query Kaijiang Chen 16:14
Re: Fwd: weird long time query hubert depesz lubaczewski 16:23
Re: Fwd: weird long time query Tom Lane 16:30
Re: How to prevent POSTGRES killing linux system from accepting too much inserts? Steven Lembark 18:07
Re: How to prevent POSTGRES killing linux system from accepting too much inserts? Merlin Moncure 18:34
Re: How to prevent POSTGRES killing linux system from accepting too much inserts? Jeff Janes 19:09

Dec. 20, 2019

Thread Author Time
Re: Consecutive Query Executions with Increasing Execution Time Shijia Wei 05:21
How to set parallel_tuple_cost Jeff Janes 18:03
Re: How to set parallel_tuple_cost Laurenz Albe 18:42
Re: How to set parallel_tuple_cost Tom Lane 18:58

Dec. 21, 2019

Thread Author Time
Re: How to set parallel_tuple_cost Andres Freund 00:24
Re: How to set parallel_tuple_cost Jeff Janes 01:37

Dec. 22, 2019

Thread Author Time
Re: proposal: schema variables Philippe BEAUDOIN 12:03
Re: proposal: schema variables Pavel Stehule 18:50

Dec. 25, 2019

Thread Author Time
Re: proposal: schema variables 📎 Pavel Stehule 21:45

Dec. 26, 2019

Thread Author Time
Re: proposal: schema variables 📎 Pavel Stehule 18:13
Merge join doesn't seem to break early when I (and planner) think it should - 10.4 Timothy Garnett 20:07

Dec. 27, 2019

Thread Author Time
Re: Merge join doesn't seem to break early when I (and planner) think it should - 10.4 Jeff Janes 16:52

Dec. 30, 2019

Thread Author Time
Re: proposal: schema variables Philippe BEAUDOIN 16:26
Re: proposal: schema variables 📎 Pavel Stehule 20:05

Jan. 3, 2020

Thread Author Time
distinguish index cost component from table component Justin Pryzby 14:14
Re: distinguish index cost component from table component Jeff Janes 14:33
Re: distinguish index cost component from table component 📎 Justin Pryzby 16:03

Jan. 4, 2020

Thread Author Time
allow disabling indexscans without disabling bitmapscans 📎 Justin Pryzby 16:50
Re: allow disabling indexscans without disabling bitmapscans Justin Pryzby 19:34

Jan. 6, 2020

Thread Author Time
doc: alter table references bogus table-specific planner parameters 📎 Justin Pryzby 02:56
Re: doc: alter table references bogus table-specific planner parameters Simon Riggs 03:48
Re: doc: alter table references bogus table-specific planner parameters Justin Pryzby 04:13
Re: doc: alter table references bogus table-specific planner parameters Simon Riggs 04:33

Jan. 10, 2020

Thread Author Time
Bad query plan when you add many OR conditions Marco Colli 01:11
Re: Bad query plan when you add many OR conditions Justin Pryzby 03:06
Re: Bad query plan when you add many OR conditions Marco Colli 11:03
Re: Bad query plan when you add many OR conditions Marco Colli 13:30
Re: Bad query plan when you add many OR conditions Justin Pryzby 13:34
Re: Bad query plan when you add many OR conditions Marco Colli 14:53
Re: Bad query plan when you add many OR conditions Tom Lane 15:18
Re: Bad query plan when you add many OR conditions Marco Colli 16:03
Re: Bad query plan when you add many OR conditions Jeff Janes 17:12

Jan. 13, 2020

Thread Author Time
Seeking reason behind performance gain in 12 with HashAggregate Shira Bezalel 16:29
Re: Seeking reason behind performance gain in 12 with HashAggregate Justin Pryzby 16:42
Re: Seeking reason behind performance gain in 12 with HashAggregate Shira Bezalel 17:34
Re: Seeking reason behind performance gain in 12 with HashAggregate Michael Lewis 18:07
Re: Seeking reason behind performance gain in 12 with HashAggregate Shira Bezalel 20:44
Re: Seeking reason behind performance gain in 12 with HashAggregate Tomas Vondra 21:11
Re: Seeking reason behind performance gain in 12 with HashAggregate Shira Bezalel 21:45
Re: Bad query plan when you add many OR conditions Tomas Vondra 22:14
Re: Seeking reason behind performance gain in 12 with HashAggregate Alvaro Herrera 22:15

Jan. 14, 2020

Thread Author Time
Re: Seeking reason behind performance gain in 12 with HashAggregate Shira Bezalel 00:11
Re: Bad query plan when you add many OR conditions Thomas Kellerer 08:01
shared buffers and startup process Joao Junior 15:29

Jan. 15, 2020

Thread Author Time
Re: shared buffers and startup process Michael Paquier 02:48

Jan. 16, 2020

Thread Author Time
Queries in plpgsql are 6 times slower on partitioned tables Marcin Barczyński 13:21

Browse Archives

Prev | Next