public inbox for [email protected]
help / color / mirror / Atom feedPerformance loss upgrading from 9.3 to 9.6
2017-11-06 13:18 UTC Adam Torres <[email protected]>
` Re: Performance loss upgrading from 9.3 to 9.6
2017-11-06 14:21 UTC Justin Pryzby <[email protected]>
` Re: Performance loss upgrading from 9.3 to 9.6
2017-11-06 21:12 UTC Adam Torres <[email protected]>
` Re: Performance loss upgrading from 9.3 to 9.6
2017-11-07 02:59 UTC Adam Brusselback <[email protected]>
` Re: Performance loss upgrading from 9.3 to 9.6
2017-11-07 05:11 UTC Justin Pryzby <[email protected]>
[5+ messages in thread]
Index-Advisor Tools
2017-10-31 17:12 UTC Neto pr <[email protected]>
` Re: Index-Advisor Tools
2017-10-31 17:19 UTC Anthony Sotolongo <[email protected]>
` Re: Index-Advisor Tools
2017-10-31 17:25 UTC Neto pr <[email protected]>
` Re: Index-Advisor Tools
2017-10-31 19:25 UTC Alexandre de Arruda Paes <[email protected]>
` Re: Index-Advisor Tools
2017-10-31 20:04 UTC Yves Dorfsman <[email protected]>
` Re: Index-Advisor Tools
2017-10-31 20:04 UTC Julien Rouhaud <[email protected]>
` Re: Index-Advisor Tools
2017-11-06 18:52 UTC Baron Schwartz <[email protected]>
[7+ messages in thread]
OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices
2017-11-02 00:28 UTC Gunther <[email protected]>
` Re: OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices
2017-11-02 02:44 UTC [email protected] <[email protected]>
` Re: OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices
2017-11-02 08:30 UTC Laurenz Albe <[email protected]>
` Re: OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices
2017-11-02 16:36 UTC Gunther <[email protected]>
` Re: OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices
2017-11-02 17:14 UTC Gunther <[email protected]>
` Re: OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices
2017-11-02 18:03 UTC legrand legrand <[email protected]>
` Re: OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices
2017-11-03 08:01 UTC Laurenz Albe <[email protected]>
` Re: OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices
2017-11-03 09:28 UTC Thomas Kellerer <[email protected]>
` Re: Re: OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices
2017-11-03 12:07 UTC Adam Brusselback <[email protected]>
` Re: Re: OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices
2017-11-03 14:36 UTC Gunther <[email protected]>
` Re: Re: OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices
2017-11-03 14:51 UTC Gunther <[email protected]>
` Re: OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices
2017-11-03 14:55 UTC legrand legrand <[email protected]>
` Re: Re: OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices
2017-11-03 15:13 UTC Gunther <[email protected]>
` Re: Re: OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices
2017-11-03 15:56 UTC Dave Nicponski <[email protected]>
[14+ messages in thread]
Cursor vs Set Operation
2017-10-30 22:51 UTC patibandlakoshal <[email protected]>
` Re: Cursor vs Set Operation
2017-11-01 16:28 UTC Merlin Moncure <[email protected]>
[2+ messages in thread]
Massive insert vs heavy contention in LWLock:buffer_content
2017-10-31 16:30 UTC luisfpg <[email protected]>
Cheaper subquery scan not considered unless offset 0
2017-10-29 11:24 UTC Benjamin Coutu <[email protected]>
` Re: Cheaper subquery scan not considered unless offset 0
2017-10-29 11:46 UTC David Rowley <[email protected]>
` Re: Cheaper subquery scan not considered unless offset 0
2017-10-29 14:58 UTC Tom Lane <[email protected]>
[3+ messages in thread]
Re: Cheaper subquery scan not considered unless offset 0
2017-10-29 14:41 UTC Benjamin Coutu <[email protected]>
Re: Cheaper subquery scan not considered unless offset 0
2017-10-29 13:17 UTC Benjamin Coutu <[email protected]>
WAL still kept in pg_xlog even long after heavy workload is done
2017-10-27 11:28 UTC Stefan Petrea <[email protected]>
` Re: WAL still kept in pg_xlog even long after heavy workload is done
2017-10-27 12:50 UTC MichaelDBA <[email protected]>
[2+ messages in thread]
postgresql tuning with perf
2017-10-23 19:19 UTC Purav Chovatia <[email protected]>
` Re: postgresql tuning with perf
2017-10-23 20:29 UTC legrand legrand <[email protected]>
` Re: postgresql tuning with perf
2017-10-23 20:55 UTC Tomas Vondra <[email protected]>
` Re: postgresql tuning with perf
2017-10-23 21:59 UTC Steve Atkins <[email protected]>
` Re: postgresql tuning with perf
2017-10-24 07:36 UTC Purav Chovatia <[email protected]>
` Re: postgresql tuning with perf
2017-10-24 11:33 UTC Purav Chovatia <[email protected]>
` Re: postgresql tuning with perf
2017-10-24 11:39 UTC Purav Chovatia <[email protected]>
` Re: postgresql tuning with perf
2017-10-24 14:51 UTC legrand legrand <[email protected]>
` Re: postgresql tuning with perf
2017-10-24 15:06 UTC Purav Chovatia <[email protected]>
` Re: postgresql tuning with perf
2017-10-24 15:08 UTC Purav Chovatia <[email protected]>
` Re: postgresql tuning with perf
2017-10-24 15:21 UTC legrand legrand <[email protected]>
[11+ messages in thread]
Row-level security performance
2017-10-24 02:51 UTC Jason Borg <[email protected]>
Low priority batch insert
2017-10-19 16:10 UTC Jean Baro <[email protected]>
` Re: Low priority batch insert
2017-10-19 22:54 UTC Michael Paquier <[email protected]>
[2+ messages in thread]
memory allocation
2017-10-17 09:28 UTC nijam J <[email protected]>
` Re: memory allocation
2017-10-19 12:51 UTC Laurenz Albe <[email protected]>
[2+ messages in thread]
Row level security policy policy versus SQL constraints. Any performance difference?
2017-10-17 20:44 UTC Joe Carlson <[email protected]>
` Re: Row level security policy policy versus SQL constraints. Any performance difference?
2017-10-17 21:35 UTC Tomas Vondra <[email protected]>
` Re: Row level security policy policy versus SQL constraints. Any performance difference?
2017-10-17 22:06 UTC Tom Lane <[email protected]>
` Re: Row level security policy policy versus SQL constraints. Any performance difference?
2017-10-17 22:18 UTC Joe Carlson <[email protected]>
[4+ messages in thread]
99% time spent in WAL wait events
2017-10-16 13:34 UTC Purav Chovatia <[email protected]>
` Re: 99% time spent in WAL wait events
2017-10-16 15:31 UTC Purav Chovatia <[email protected]>
[2+ messages in thread]
Stored Procedure Performance
2017-10-03 14:33 UTC Purav Chovatia <[email protected]>
` Re: Stored Procedure Performance
2017-10-03 14:54 UTC Laurenz Albe <[email protected]>
` Re: Stored Procedure Performance
2017-10-03 15:17 UTC Adam Brusselback <[email protected]>
` Re: Stored Procedure Performance
2017-10-03 15:28 UTC Pavel Stehule <[email protected]>
` Re: Stored Procedure Performance
2017-10-11 13:59 UTC Purav Chovatia <[email protected]>
` Re: Stored Procedure Performance
2017-10-11 14:11 UTC Purav Chovatia <[email protected]>
` Re: Stored Procedure Performance
2017-10-11 14:20 UTC Pavel Stehule <[email protected]>
` Re: Stored Procedure Performance
2017-10-11 16:05 UTC Purav Chovatia <[email protected]>
` Re: Stored Procedure Performance
2017-10-11 16:37 UTC Adam Brusselback <[email protected]>
` Re: Stored Procedure Performance
2017-10-11 16:52 UTC Purav Chovatia <[email protected]>
` Re: Stored Procedure Performance
2017-10-11 16:54 UTC Adam Brusselback <[email protected]>
` Re: Stored Procedure Performance
2017-10-11 19:06 UTC Pavel Stehule <[email protected]>
` Re: Stored Procedure Performance
2017-10-14 10:21 UTC phb07 <[email protected]>
[13+ messages in thread]
Rowcount estimation changes based on from clause order
2017-10-11 09:33 UTC Ants Aasma <[email protected]>
` Re: Rowcount estimation changes based on from clause order
2017-10-12 20:50 UTC Tom Lane <[email protected]>
` Re: Rowcount estimation changes based on from clause order
2017-10-13 02:32 UTC Ants Aasma <[email protected]>
[3+ messages in thread]
synchronization between PostgreSQL and Oracle
2017-10-12 09:13 UTC ROS Didier <[email protected]>
` Re: synchronization between PostgreSQL and Oracle
2017-10-12 10:01 UTC Rick Otten <[email protected]>
` Re: synchronization between PostgreSQL and Oracle
2017-10-12 10:04 UTC Laurenz Albe <[email protected]>
[3+ messages in thread]
blocking index creation
2017-10-11 12:58 UTC Neto pr <[email protected]>
` Re: blocking index creation
2017-10-11 13:46 UTC Laurenz Albe <[email protected]>
` Re: blocking index creation
2017-10-11 14:11 UTC Neto pr <[email protected]>
` Re: blocking index creation
2017-10-11 21:08 UTC Tomas Vondra <[email protected]>
` Re: blocking index creation
2017-10-11 22:54 UTC Neto pr <[email protected]>
` Re: blocking index creation
2017-10-12 01:35 UTC Neto pr <[email protected]>
` Re: blocking index creation
2017-10-12 02:25 UTC Scott Marlowe <[email protected]>
[7+ messages in thread]
Wrong plane for limit after group by
2017-10-12 00:18 UTC Денис Смирнов <[email protected]>
Cursor With_Hold Performance Workarounds/Optimization
2017-10-10 12:20 UTC Leon Winter <[email protected]>
Regression from 9.4-9.6
2017-10-08 19:25 UTC Jim Nasby <[email protected]>
` Re: Regression from 9.4-9.6
2017-10-08 19:34 UTC Tom Lane <[email protected]>
` Re: Regression from 9.4-9.6
2017-10-08 20:02 UTC Jim Nasby <[email protected]>
` Re: Regression from 9.4-9.6
2017-10-08 20:33 UTC Jim Nasby <[email protected]>
` Re: Regression from 9.4-9.6
2017-10-08 20:37 UTC Tom Lane <[email protected]>
` Re: Regression from 9.4-9.6
2017-10-08 21:07 UTC Jim Nasby <[email protected]>
[6+ messages in thread]
How does max_parallel_workers_per_gather change load averages?
2017-10-03 19:48 UTC Ben Nachtrieb <[email protected]>
` Re: How does max_parallel_workers_per_gather change load averages?
2017-10-03 21:44 UTC David Rowley <[email protected]>
[2+ messages in thread]
select with max functions
2017-10-01 12:41 UTC Mariel Cherkassky <[email protected]>
` Re: select with max functions
2017-10-01 13:35 UTC Gerardo Herzig <[email protected]>
` Re: select with max functions
2017-10-01 18:48 UTC Andreas Kretschmer <[email protected]>
` Re: select with max functions
2017-10-02 13:25 UTC Mariel Cherkassky <[email protected]>
` Re: select with max functions
2017-10-02 13:45 UTC Gerardo Herzig <[email protected]>
` Re: select with max functions
2017-10-02 14:45 UTC Mariel Cherkassky <[email protected]>
` Re: select with max functions
2017-10-02 15:29 UTC Tom Lane <[email protected]>
` Re: select with max functions
2017-10-03 21:16 UTC Mark Kirkwood <[email protected]>
[8+ messages in thread]
BDR, wal sender, high system cpu, mutex_lock_common
2017-09-29 23:07 UTC milist ujang <[email protected]>
` Re: BDR, wal sender, high system cpu, mutex_lock_common
2017-10-01 01:36 UTC milist ujang <[email protected]>
[2+ messages in thread]
[next (older)]
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox