agora inbox for pgsql-performance@postgresql.org
help / color / mirror / Atom feedPerformance loss upgrading from 9.3 to 9.6
2017-11-06 13:18 UTC Adam Torres <atorres@amplify-nation.com>
` Re: Performance loss upgrading from 9.3 to 9.6
2017-11-06 14:21 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Performance loss upgrading from 9.3 to 9.6
2017-11-06 21:12 UTC Adam Torres <atorres@amplify-nation.com>
` Re: Performance loss upgrading from 9.3 to 9.6
2017-11-07 02:59 UTC Adam Brusselback <adambrusselback@gmail.com>
` Re: Performance loss upgrading from 9.3 to 9.6
2017-11-07 05:11 UTC Justin Pryzby <pryzby@telsasoft.com>
[5+ messages in thread]
Dynamic performance issues
2017-11-06 20:05 UTC Arne Roland <A.Roland@index.de>
Index-Advisor Tools
2017-10-31 17:12 UTC Neto pr <netopr9@gmail.com>
` Re: Index-Advisor Tools
2017-10-31 17:19 UTC Anthony Sotolongo <asotolongo@gmail.com>
` Re: Index-Advisor Tools
2017-10-31 17:25 UTC Neto pr <netopr9@gmail.com>
` Re: Index-Advisor Tools
2017-10-31 19:25 UTC Alexandre de Arruda Paes <adaldeia@gmail.com>
` Re: Index-Advisor Tools
2017-10-31 20:04 UTC Yves Dorfsman <yves@zioup.com>
` Re: Index-Advisor Tools
2017-10-31 20:04 UTC Julien Rouhaud <rjuju123@gmail.com>
` Re: Index-Advisor Tools
2017-11-06 18:52 UTC Baron Schwartz <baron.schwartz@gmail.com>
[7+ messages in thread]
Unnecessary DISTINCT while primary key in SQL
2017-11-04 15:20 UTC 刘瑞 <whx20202@gmail.com>
` Re: Unnecessary DISTINCT while primary key in SQL
2017-11-06 00:34 UTC David Rowley <david.rowley@2ndquadrant.com>
[2+ 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 <raj@gusw.net>
` Re: OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices
2017-11-02 02:44 UTC ldh@laurent-hasson.com <ldh@laurent-hasson.com>
` Re: OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices
2017-11-02 08:30 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices
2017-11-02 16:36 UTC Gunther <raj@gusw.net>
` Re: OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices
2017-11-02 17:14 UTC Gunther <raj@gusw.net>
` Re: OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices
2017-11-02 18:03 UTC legrand legrand <legrand_legrand@hotmail.com>
` Re: OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices
2017-11-03 08:01 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices
2017-11-03 09:28 UTC Thomas Kellerer <spam_eater@gmx.net>
` 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 <adambrusselback@gmail.com>
` Re: Re: OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices
2017-11-03 14:36 UTC Gunther <raj@gusw.net>
` Re: Re: OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices
2017-11-03 14:51 UTC Gunther <raj@gusw.net>
` Re: OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices
2017-11-03 14:55 UTC legrand legrand <legrand_legrand@hotmail.com>
` Re: Re: OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices
2017-11-03 15:13 UTC Gunther <raj@gusw.net>
` 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 <dave@seamlessdocs.com>
[14+ messages in thread]
Cursor vs Set Operation
2017-10-30 22:51 UTC patibandlakoshal <patibandlakoshal@gmail.com>
` Re: Cursor vs Set Operation
2017-11-01 16:28 UTC Merlin Moncure <mmoncure@gmail.com>
[2+ messages in thread]
Massive insert vs heavy contention in LWLock:buffer_content
2017-10-31 16:30 UTC luisfpg <lfpg.dev@gmail.com>
[PATCH 1/3] Provide overflow safe integer math inline functions.
2017-10-30 05:13 UTC Andres Freund <andres@anarazel.de>
Cheaper subquery scan not considered unless offset 0
2017-10-29 11:24 UTC Benjamin Coutu <ben.coutu@zeyos.com>
` Re: Cheaper subquery scan not considered unless offset 0
2017-10-29 11:46 UTC David Rowley <david.rowley@2ndquadrant.com>
` Re: Cheaper subquery scan not considered unless offset 0
2017-10-29 13:17 UTC Benjamin Coutu <ben.coutu@zeyos.com>
` Re: Cheaper subquery scan not considered unless offset 0
2017-10-29 14:41 UTC Benjamin Coutu <ben.coutu@zeyos.com>
` Re: Cheaper subquery scan not considered unless offset 0
2017-10-29 14:58 UTC Tom Lane <tgl@sss.pgh.pa.us>
[5+ messages in thread]
WAL still kept in pg_xlog even long after heavy workload is done
2017-10-27 11:28 UTC Stefan Petrea <Stefan.Petrea@tangoe.com>
` Re: WAL still kept in pg_xlog even long after heavy workload is done
2017-10-27 12:50 UTC MichaelDBA <MichaelDBA@sqlexec.com>
[2+ messages in thread]
postgresql tuning with perf
2017-10-23 19:19 UTC Purav Chovatia <puravc@gmail.com>
` Re: postgresql tuning with perf
2017-10-23 20:29 UTC legrand legrand <legrand_legrand@hotmail.com>
` Re: postgresql tuning with perf
2017-10-23 20:55 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: postgresql tuning with perf
2017-10-23 21:59 UTC Steve Atkins <steve@blighty.com>
` Re: postgresql tuning with perf
2017-10-24 07:36 UTC Purav Chovatia <puravc@gmail.com>
` Re: postgresql tuning with perf
2017-10-24 11:33 UTC Purav Chovatia <puravc@gmail.com>
` Re: postgresql tuning with perf
2017-10-24 11:39 UTC Purav Chovatia <puravc@gmail.com>
` Re: postgresql tuning with perf
2017-10-24 14:51 UTC legrand legrand <legrand_legrand@hotmail.com>
` Re: postgresql tuning with perf
2017-10-24 15:06 UTC Purav Chovatia <puravc@gmail.com>
` Re: postgresql tuning with perf
2017-10-24 15:08 UTC Purav Chovatia <puravc@gmail.com>
` Re: postgresql tuning with perf
2017-10-24 15:21 UTC legrand legrand <legrand_legrand@hotmail.com>
[11+ messages in thread]
Row-level security performance
2017-10-24 02:51 UTC Jason Borg <jasonb@sunpay.com.au>
Low priority batch insert
2017-10-19 16:10 UTC Jean Baro <jfbaro@gmail.com>
` Re: Low priority batch insert
2017-10-19 22:54 UTC Michael Paquier <michael.paquier@gmail.com>
[2+ messages in thread]
memory allocation
2004-06-18 13:34 UTC Michael Ryan S. Puncia <mpuncia@census.gov.ph>
` Re: memory allocation
2004-06-18 13:39 UTC Devrim GUNDUZ <devrim@gunduz.org>
` Re: memory allocation
2004-06-18 13:58 UTC Richard Huxton <dev@archonet.com>
` Memory Allocation
2008-11-26 22:09 UTC Ryan Hansen <ryan.hansen@brightbuilders.com>
` Re: Memory Allocation
2008-11-26 22:18 UTC Alan Hodgson <ahodgson@simkin.ca>
` Re: Memory Allocation
2008-11-26 22:47 UTC Carlos Moreno <morenopg@mochima.com>
` Re: Memory Allocation
2008-11-26 22:58 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Memory Allocation
2008-11-26 23:00 UTC Scott Carey <scott@richrelevance.com>
` Re: Memory Allocation
2008-11-26 23:09 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Memory Allocation
2008-11-26 23:52 UTC Scott Carey <scott@richrelevance.com>
` Re: Memory Allocation
2008-11-28 22:28 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` memory allocation
2017-10-17 09:28 UTC nijam J <nijamutheenblogs1@gmail.com>
` Re: memory allocation
2017-10-19 12:51 UTC Laurenz Albe <laurenz.albe@cybertec.at>
[13+ messages in thread]
Row level security policy policy versus SQL constraints. Any performance difference?
2017-10-17 20:44 UTC Joe Carlson <jwcarlson@lbl.gov>
` Re: Row level security policy policy versus SQL constraints. Any performance difference?
2017-10-17 21:35 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Row level security policy policy versus SQL constraints. Any performance difference?
2017-10-17 22:06 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Row level security policy policy versus SQL constraints. Any performance difference?
2017-10-17 22:18 UTC Joe Carlson <jwcarlson@lbl.gov>
[4+ messages in thread]
99% time spent in WAL wait events
2017-10-16 13:34 UTC Purav Chovatia <puravc@gmail.com>
` Re: 99% time spent in WAL wait events
2017-10-16 15:31 UTC Purav Chovatia <puravc@gmail.com>
[2+ messages in thread]
Stored Procedure Performance
2006-04-11 07:19 UTC Simon Dale <sdale@rm.com>
` Re: Stored Procedure Performance
2006-04-11 07:58 UTC hubert depesz lubaczewski <depesz@gmail.com>
` Re: Stored Procedure Performance
2006-04-11 08:22 UTC Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
` Re: Stored Procedure Performance
2006-04-11 10:04 UTC Richard Huxton <dev@archonet.com>
` Re: Stored Procedure Performance
2006-04-11 13:49 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Stored Procedure Performance
2006-04-11 13:56 UTC Christopher Browne <cbbrowne@acm.org>
` Re: Stored Procedure Performance
2006-04-11 14:02 UTC H.J. Sanders <hjs@rmax.nl>
` Re: Stored Procedure Performance
2006-04-11 14:08 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: Stored Procedure Performance
2006-04-11 21:02 UTC Merlin Moncure <mmoncure@gmail.com>
` Stored Procedure Performance
2017-10-03 14:33 UTC Purav Chovatia <puravc@gmail.com>
` Re: Stored Procedure Performance
2017-10-03 14:54 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Stored Procedure Performance
2017-10-03 15:17 UTC Adam Brusselback <adambrusselback@gmail.com>
` Re: Stored Procedure Performance
2017-10-03 15:28 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Stored Procedure Performance
2017-10-11 13:59 UTC Purav Chovatia <puravc@gmail.com>
` Re: Stored Procedure Performance
2017-10-11 14:11 UTC Purav Chovatia <puravc@gmail.com>
` Re: Stored Procedure Performance
2017-10-11 14:20 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Stored Procedure Performance
2017-10-11 16:05 UTC Purav Chovatia <puravc@gmail.com>
` Re: Stored Procedure Performance
2017-10-11 16:37 UTC Adam Brusselback <adambrusselback@gmail.com>
` Re: Stored Procedure Performance
2017-10-11 16:52 UTC Purav Chovatia <puravc@gmail.com>
` Re: Stored Procedure Performance
2017-10-11 16:54 UTC Adam Brusselback <adambrusselback@gmail.com>
` Re: Stored Procedure Performance
2017-10-11 19:06 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Stored Procedure Performance
2017-10-14 10:21 UTC phb07 <phb07@apra.asso.fr>
[22+ messages in thread]
Rowcount estimation changes based on from clause order
2017-10-11 09:33 UTC Ants Aasma <ants.aasma@eesti.ee>
` Re: Rowcount estimation changes based on from clause order
2017-10-12 20:50 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Rowcount estimation changes based on from clause order
2017-10-13 02:32 UTC Ants Aasma <ants.aasma@eesti.ee>
[3+ messages in thread]
synchronization between PostgreSQL and Oracle
2017-10-12 09:13 UTC ROS Didier <didier.ros@edf.fr>
` Re: synchronization between PostgreSQL and Oracle
2017-10-12 10:01 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: synchronization between PostgreSQL and Oracle
2017-10-12 10:04 UTC Laurenz Albe <laurenz.albe@cybertec.at>
[3+ messages in thread]
blocking index creation
2017-10-11 12:58 UTC Neto pr <netopr9@gmail.com>
` Re: blocking index creation
2017-10-11 13:46 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: blocking index creation
2017-10-11 14:11 UTC Neto pr <netopr9@gmail.com>
` Re: blocking index creation
2017-10-11 21:08 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: blocking index creation
2017-10-11 22:54 UTC Neto pr <netopr9@gmail.com>
` Re: blocking index creation
2017-10-12 01:35 UTC Neto pr <netopr9@gmail.com>
` Re: blocking index creation
2017-10-12 02:25 UTC Scott Marlowe <scott.marlowe@gmail.com>
[7+ messages in thread]
Wrong plane for limit after group by
2017-10-12 00:18 UTC Денис Смирнов <darthunix@gmail.com>
Cursor With_Hold Performance Workarounds/Optimization
2017-10-10 12:20 UTC Leon Winter <winter-pg@bfw-online.de>
Regression from 9.4-9.6
2017-10-08 19:25 UTC Jim Nasby <jim@nasby.net>
` Re: Regression from 9.4-9.6
2017-10-08 19:34 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Regression from 9.4-9.6
2017-10-08 20:02 UTC Jim Nasby <jim@nasby.net>
` Re: Regression from 9.4-9.6
2017-10-08 20:33 UTC Jim Nasby <jim@nasby.net>
` Re: Regression from 9.4-9.6
2017-10-08 20:37 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Regression from 9.4-9.6
2017-10-08 21:07 UTC Jim Nasby <jim@nasby.net>
[6+ messages in thread]
How does max_parallel_workers_per_gather change load averages?
2017-10-03 19:48 UTC Ben Nachtrieb <bnachtrieb@crescat.net>
` Re: How does max_parallel_workers_per_gather change load averages?
2017-10-03 21:44 UTC David Rowley <david.rowley@2ndquadrant.com>
[2+ messages in thread]
select with max functions
2017-10-01 12:41 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: select with max functions
2017-10-01 13:35 UTC Gerardo Herzig <gherzig@fmed.uba.ar>
` Re: select with max functions
2017-10-01 18:48 UTC Andreas Kretschmer <andreas@a-kretschmer.de>
` Re: select with max functions
2017-10-02 13:25 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: select with max functions
2017-10-02 13:45 UTC Gerardo Herzig <gherzig@fmed.uba.ar>
` Re: select with max functions
2017-10-02 14:45 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: select with max functions
2017-10-02 15:29 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: select with max functions
2017-10-03 21:16 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
[8+ 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