pgsql-performance - October 2017

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

Oct. 1, 2017

Thread	Author	Time
Re: BDR, wal sender, high system cpu, mutex_lock_common	milist ujang	01:36
select with max functions	Mariel Cherkassky	12:41
Re: select with max functions	Gerardo Herzig	13:35
Re: select with max functions	Andreas Kretschmer	18:48

Oct. 2, 2017

Thread	Author	Time
Re: select with max functions	Mariel Cherkassky	13:25
Re: select with max functions	Gerardo Herzig	13:45
Re: select with max functions	Mariel Cherkassky	14:45
Re: select with max functions	Tom Lane	15:29

Oct. 3, 2017

Thread	Author	Time
Stored Procedure Performance	Purav Chovatia	14:33
Re: Stored Procedure Performance	Laurenz Albe	14:54
Re: Stored Procedure Performance	Adam Brusselback	15:17
Re: Stored Procedure Performance	Pavel Stehule	15:28
How does max_parallel_workers_per_gather change load averages?	Ben Nachtrieb	19:48
Re: select with max functions	Mark Kirkwood	21:16
Re: How does max_parallel_workers_per_gather change load averages?	David Rowley	21:44

Oct. 8, 2017

Thread	Author	Time
Regression from 9.4-9.6	Jim Nasby	19:25
Re: Regression from 9.4-9.6	Tom Lane	19:34
Re: Regression from 9.4-9.6	Jim Nasby	20:02
Re: Regression from 9.4-9.6	Jim Nasby	20:33
Re: Regression from 9.4-9.6	Tom Lane	20:37
Re: Regression from 9.4-9.6	Jim Nasby	21:07

Oct. 10, 2017

Thread	Author	Time
Cursor With_Hold Performance Workarounds/Optimization	Leon Winter	12:20

Oct. 11, 2017

Thread	Author	Time
Rowcount estimation changes based on from clause order	Ants Aasma	09:33
performance drop after upgrade (9.6 > 10)	johannes graën	11:06
Re: performance drop after upgrade (9.6 > 10)	Pavel Stehule	11:11
Re: performance drop after upgrade (9.6 > 10)	johannes graën	12:19
blocking index creation	Neto pr	12:58
Re: blocking index creation	Laurenz Albe	13:46
Re: Stored Procedure Performance	Purav Chovatia	13:59
Re: Stored Procedure Performance	Purav Chovatia	14:11
Re: blocking index creation	Neto pr	14:11
Re: Stored Procedure Performance	Pavel Stehule	14:20
Re: Stored Procedure Performance	Purav Chovatia	16:05
Re: Stored Procedure Performance	Adam Brusselback	16:37
Re: Stored Procedure Performance	Purav Chovatia	16:52
Re: Stored Procedure Performance	Adam Brusselback	16:54
Re: Stored Procedure Performance	Pavel Stehule	19:06
Re: blocking index creation	Tomas Vondra	21:08
Re: blocking index creation	Neto pr	22:54

Oct. 12, 2017

Thread	Author	Time
Wrong plane for limit after group by	Денис Смирнов	00:18
Re: blocking index creation	Neto pr	01:35
Re: blocking index creation	Scott Marlowe	02:25
synchronization between PostgreSQL and Oracle	ROS Didier	09:13
Re: synchronization between PostgreSQL and Oracle	Rick Otten	10:01
Re: synchronization between PostgreSQL and Oracle	Laurenz Albe	10:04
Re: Rowcount estimation changes based on from clause order	Tom Lane	20:50

Oct. 13, 2017

Thread	Author	Time
Re: Rowcount estimation changes based on from clause order	Ants Aasma	02:32

Oct. 14, 2017

Thread	Author	Time
Re: Stored Procedure Performance	phb07	10:21

Oct. 16, 2017

Thread	Author	Time
99% time spent in WAL wait events	Purav Chovatia	13:34
Re: 99% time spent in WAL wait events	Purav Chovatia	15:31

Oct. 17, 2017

Thread	Author	Time
memory allocation	nijam J	09:28
Row level security policy policy versus SQL constraints. Any performance difference?	Joe Carlson	20:44
Re: Row level security policy policy versus SQL constraints. Any performance difference?	Tomas Vondra	21:35
Re: Row level security policy policy versus SQL constraints. Any performance difference?	Tom Lane	22:06
Re: Row level security policy policy versus SQL constraints. Any performance difference?	Joe Carlson	22:18

Oct. 19, 2017

Thread	Author	Time
Re: memory allocation	Laurenz Albe	12:51
Low priority batch insert	Jean Baro	16:10
Re: Low priority batch insert	Michael Paquier	22:54

Oct. 23, 2017

Thread	Author	Time
postgresql tuning with perf	Purav Chovatia	19:19
Re: postgresql tuning with perf	legrand legrand	20:29
Re: postgresql tuning with perf	Tomas Vondra	20:55
Re: postgresql tuning with perf	Steve Atkins	21:59

Oct. 24, 2017

Thread	Author	Time
Row-level security performance	Jason Borg	02:51
Re: postgresql tuning with perf	Purav Chovatia	07:36
Re: postgresql tuning with perf 📎	Purav Chovatia	11:33
Re: postgresql tuning with perf	Purav Chovatia	11:39
Re: performance drop after upgrade (9.6 > 10)	johannes graën	14:15
Re: postgresql tuning with perf	legrand legrand	14:51
Re: postgresql tuning with perf	Purav Chovatia	15:06
Re: postgresql tuning with perf	Purav Chovatia	15:08
Re: performance drop after upgrade (9.6 > 10)	Justin Pryzby	15:18
Re: postgresql tuning with perf	legrand legrand	15:21
Re: performance drop after upgrade (9.6 > 10)	Johannes Graën	15:57
Re: performance drop after upgrade (9.6 > 10)	Alvaro Herrera	16:17

Oct. 26, 2017

Thread	Author	Time
proposal: schema variables	Pavel Stehule	07:21
Re: performance drop after upgrade (9.6 > 10)	Justin Pryzby	19:45
Re: proposal: schema variables	Nico Williams	22:07

Oct. 27, 2017

Thread	Author	Time
Re: proposal: schema variables	Pavel Stehule	05:08
Re: proposal: schema variables	Tatsuo Ishii	05:30
Re: proposal: schema variables	Tsunakawa, Takayuki	05:47
Re: proposal: schema variables	Pavel Stehule	06:16
WAL still kept in pg_xlog even long after heavy workload is done	Stefan Petrea	11:28
Re: WAL still kept in pg_xlog even long after heavy workload is done	MichaelDBA	12:50
Re: proposal: schema variables	Gilles Darold	13:38
Re: proposal: schema variables	Pavel Stehule	14:09

Oct. 28, 2017

Thread	Author	Time
Re: proposal: schema variables	Chris Travers	14:24
Re: proposal: schema variables	Pavel Stehule	14:56

Oct. 29, 2017

Thread	Author	Time
Re: proposal: schema variables	Chris Travers	08:51
Re: proposal: schema variables	Hannu Krosing	10:47
Cheaper subquery scan not considered unless offset 0	Benjamin Coutu	11:24
Re: Cheaper subquery scan not considered unless offset 0	David Rowley	11:46
Re: Cheaper subquery scan not considered unless offset 0	Benjamin Coutu	13:17
Re: Cheaper subquery scan not considered unless offset 0	Benjamin Coutu	14:41
Re: Cheaper subquery scan not considered unless offset 0	Tom Lane	14:58

Oct. 30, 2017

Thread	Author	Time
Re: proposal: schema variables	srielau	21:42
Cursor vs Set Operation	patibandlakoshal	22:51

Oct. 31, 2017

Thread	Author	Time
Massive insert vs heavy contention in LWLock:buffer_content	luisfpg	16:30
Index-Advisor Tools	Neto pr	17:12
Re: Index-Advisor Tools	Anthony Sotolongo	17:19
Re: Index-Advisor Tools	Neto pr	17:25
Re: Index-Advisor Tools	Alexandre de Arruda Paes	19:25
Re: Index-Advisor Tools	Yves Dorfsman	20:04
Re: Index-Advisor Tools	Julien Rouhaud	20:04
Re: proposal: schema variables	Pavel Stehule	20:33
Re: proposal: schema variables	Serge Rielau	21:08
Re: proposal: schema variables	Pavel Stehule	21:10
Re: proposal: schema variables	srielau	21:28
Re: proposal: schema variables	Gilles Darold	22:36
Re: proposal: schema variables	Gilles Darold	23:02

Browse Archives

Prev | Next