pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedRT3.4 query needed a lot more tuning with 9.2 than it did with 8.1
2013-04-30 11:20 UTC Christoph Berg <christoph.berg@credativ.de>
` Re: RT3.4 query needed a lot more tuning with 9.2 than it did with 8.1
2013-05-06 16:38 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: RT3.4 query needed a lot more tuning with 9.2 than it did with 8.1
2013-05-13 19:58 UTC Robert Haas <robertmhaas@gmail.com>
` Re: RT3.4 query needed a lot more tuning with 9.2 than it did with 8.1
2013-05-13 20:08 UTC Mark Felder <feld@feld.me>
` Re: RT3.4 query needed a lot more tuning with 9.2 than it did with 8.1
2013-05-13 20:14 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: RT3.4 query needed a lot more tuning with 9.2 than it did with 8.1
2013-05-13 20:29 UTC Robert Haas <robertmhaas@gmail.com>
` Re: RT3.4 query needed a lot more tuning with 9.2 than it did with 8.1
2013-05-13 20:33 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: RT3.4 query needed a lot more tuning with 9.2 than it did with 8.1
2013-05-14 12:12 UTC Robert Haas <robertmhaas@gmail.com>
` Re: RT3.4 query needed a lot more tuning with 9.2 than it did with 8.1
2013-05-15 06:48 UTC Christoph Berg <cb@df7cb.de>
` Re: RT3.4 query needed a lot more tuning with 9.2 than it did with 8.1
2013-05-15 06:52 UTC Christoph Berg <cb@df7cb.de>
` Re: RT3.4 query needed a lot more tuning with 9.2 than it did with 8.1
2013-05-15 13:52 UTC ktm@rice.edu <ktm@rice.edu>
[11+ messages in thread]
Lock and pg_stat
2013-05-13 13:05 UTC Desbiens, Eric <edesbiens@lxdata.com>
` Re: Lock and pg_stat
2013-05-14 12:44 UTC Robert Haas <robertmhaas@gmail.com>
[2+ messages in thread]
Predicate information in EXPLAIN Command
2013-05-14 09:23 UTC Sameer Thakur <samthakur74@gmail.com>
` Re: Predicate information in EXPLAIN Command
2013-05-14 09:29 UTC Heikki Linnakangas <hlinnakangas@vmware.com>
[2+ messages in thread]
Setting vacuum_freeze_min_age really low
2013-03-25 20:31 UTC Josh Berkus <josh@agliodbs.com>
` Re: Setting vacuum_freeze_min_age really low
2013-05-09 16:09 UTC Robert Haas <robertmhaas@gmail.com>
` Re: Setting vacuum_freeze_min_age really low
2013-05-09 17:18 UTC Andres Freund <andres@2ndquadrant.com>
` Re: Setting vacuum_freeze_min_age really low
2013-05-09 17:22 UTC Andres Freund <andres@2ndquadrant.com>
` Re: Setting vacuum_freeze_min_age really low
2013-05-11 23:28 UTC Josh Berkus <josh@agliodbs.com>
` Re: Setting vacuum_freeze_min_age really low
2013-05-12 12:50 UTC Andres Freund <andres@2ndquadrant.com>
` Re: Setting vacuum_freeze_min_age really low
2013-05-13 17:21 UTC Robert Haas <robertmhaas@gmail.com>
` Re: Setting vacuum_freeze_min_age really low
2013-05-13 17:43 UTC Andres Freund <andres@2ndquadrant.com>
` Re: Setting vacuum_freeze_min_age really low
2013-05-14 04:02 UTC Josh Berkus <josh@agliodbs.com>
[9+ messages in thread]
PostgreSQL planner
2013-03-24 00:12 UTC Misa Simic <misa.simic@gmail.com>
` Re: PostgreSQL planner
2013-05-10 19:57 UTC Robert Haas <robertmhaas@gmail.com>
` Re: PostgreSQL planner
2013-05-10 23:12 UTC Misa Simic <misa.simic@gmail.com>
[3+ messages in thread]
Deterioration in performance when query executed in multi threads
2013-05-01 05:50 UTC Anne Rosset <arosset@collab.net>
` Deterioration in performance when query executed in multi threads
2013-05-01 14:05 UTC Anne Rosset <arosset@collab.net>
` Re: Deterioration in performance when query executed in multi threads
2013-05-01 14:12 UTC ktm@rice.edu <ktm@rice.edu>
` Re: Deterioration in performance when query executed in multi threads
2013-05-01 16:07 UTC Anne Rosset <arosset@collab.net>
` Re: Deterioration in performance when query executed in multi threads
2013-05-01 16:26 UTC ktm@rice.edu <ktm@rice.edu>
` Re: Deterioration in performance when query executed in multi threads
2013-05-01 17:07 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Deterioration in performance when query executed in multi threads
2013-05-01 17:10 UTC Anne Rosset <arosset@collab.net>
` Re: Deterioration in performance when query executed in multi threads
2013-05-01 17:26 UTC Igor Neyman <ineyman@perceptron.com>
` Re: Deterioration in performance when query executed in multi threads
2013-05-03 20:52 UTC Anne Rosset <arosset@collab.net>
` Re: Deterioration in performance when query executed in multi threads
2013-05-06 14:05 UTC Igor Neyman <ineyman@perceptron.com>
` Re: Deterioration in performance when query executed in multi threads
2013-05-06 16:11 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Deterioration in performance when query executed in multi threads
2013-05-06 17:00 UTC Anne Rosset <arosset@collab.net>
` Re: Deterioration in performance when query executed in multi threads
2013-05-06 17:11 UTC Thomas Kellerer <spam_eater@gmx.net>
` Re: Deterioration in performance when query executed in multi threads
2013-05-06 17:12 UTC Igor Neyman <ineyman@perceptron.com>
` Re: Deterioration in performance when query executed in multi threads
2013-05-06 17:25 UTC Igor Neyman <ineyman@perceptron.com>
` Re: Deterioration in performance when query executed in multi threads
2013-05-06 21:46 UTC Anne Rosset <arosset@collab.net>
` Re: Deterioration in performance when query executed in multi threads
2013-05-06 21:51 UTC Anne Rosset <arosset@collab.net>
` Re: Deterioration in performance when query executed in multi threads
2013-05-06 22:11 UTC Gavin Flower <GavinFlower@archidevsys.co.nz>
` Re: Deterioration in performance when query executed in multi threads
2013-05-07 02:03 UTC Igor Neyman <ineyman@perceptron.com>
` Re: Deterioration in performance when query executed in multi threads
2013-05-07 17:53 UTC Anne Rosset <arosset@collab.net>
[20+ messages in thread]
"WHERE 1 = 2 OR ..." makes planner choose a very inefficient plan
2013-04-18 14:20 UTC dmitry potapov <potapov.dmitry@gmail.com>
` Re: "WHERE 1 = 2 OR ..." makes planner choose a very inefficient plan
2013-04-18 14:43 UTC Richard Huxton <dev@archonet.com>
` Re: "WHERE 1 = 2 OR ..." makes planner choose a very inefficient plan
2013-04-18 14:46 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: "WHERE 1 = 2 OR ..." makes planner choose a very inefficient plan
2013-05-02 12:48 UTC Simon Riggs <simon@2ndQuadrant.com>
` Re: "WHERE 1 = 2 OR ..." makes planner choose a very inefficient plan
2013-05-02 15:00 UTC Claudio Freire <klaussfreire@gmail.com>
[5+ messages in thread]
Query planner ignoring constraints on partitioned tables when joining
2013-04-17 16:59 UTC Michael Okner <michael.okner@gmail.com>
` Re: Query planner ignoring constraints on partitioned tables when joining
2013-04-18 21:42 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query planner ignoring constraints on partitioned tables when joining
2013-05-02 12:41 UTC Simon Riggs <simon@2ndQuadrant.com>
[3+ messages in thread]
100x slowdown for nearly identical tables
2013-05-01 23:35 UTC Craig James <cjames@emolecules.com>
` Re: 100x slowdown for nearly identical tables
2013-05-02 00:18 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: 100x slowdown for nearly identical tables
2013-05-02 00:45 UTC Craig James <cjames@emolecules.com>
` Re: 100x slowdown for nearly identical tables
2013-05-02 01:51 UTC Tom Lane <tgl@sss.pgh.pa.us>
[4+ messages in thread]
BUG #8130: Hashjoin still gives issues
2013-05-01 12:48 UTC stefan@konink.de
` Re: BUG #8130: Hashjoin still gives issues
2013-05-01 15:10 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [BUGS] BUG #8130: Hashjoin still gives issues
2013-05-01 15:44 UTC Stefan de Konink <stefan@konink.de>
` Re: [BUGS] BUG #8130: Hashjoin still gives issues
2013-05-01 17:59 UTC Igor Neyman <ineyman@perceptron.com>
` Re: [BUGS] BUG #8130: Hashjoin still gives issues
2013-05-01 20:07 UTC Jeff Davis <pgsql@j-davis.com>
[5+ messages in thread]
Bad Execution Plan with "OR" Clauses Across Outer-Joined Tables
2013-04-30 17:13 UTC Mark Hampton <mark@cleverdba.com>
` Re: Bad Execution Plan with "OR" Clauses Across Outer-Joined Tables
2013-04-30 19:24 UTC Vitalii Tymchyshyn <tivv00@gmail.com>
` Re: Bad Execution Plan with "OR" Clauses Across Outer-Joined Tables
2013-04-30 20:03 UTC Mark Hampton <mark@cleverdba.com>
[3+ messages in thread]
different plans for the same query - different filter values
2013-04-25 12:18 UTC Misa Simic <misa.simic@gmail.com>
Re: [PERFORM] Question about network bandwidth usage between PostgreSQL’s client and server
2013-04-25 11:26 UTC Heikki Linnakangas <hlinnakangas@vmware.com>
Question about network bandwidth usage between PostgreSQL’s client and server
2013-04-24 23:56 UTC Kelphet Xiong <kelphet@gmail.com>
template1 vacuuming consuming much time compared to another production DBs
2013-04-22 11:31 UTC pradeep singh <pradeepsingh1988@gmail.com>
` Re: template1 vacuuming consuming much time compared to another production DBs
2013-04-22 12:08 UTC Andrew Dunstan <andrew@dunslane.net>
` Re: template1 vacuuming consuming much time compared to another production DBs
2013-04-23 01:49 UTC pradeep singh <pradeepsingh1988@gmail.com>
[3+ messages in thread]
Issues with OSX and SHMMAX?
2013-04-21 21:29 UTC Josh Berkus <josh@agliodbs.com>
` Re: Issues with OSX and SHMMAX?
2013-04-21 21:33 UTC Evgeny Shishkin <itparanoia@gmail.com>
` Re: Issues with OSX and SHMMAX?
2013-04-22 18:19 UTC Josh Berkus <josh@agliodbs.com>
` Re: Issues with OSX and SHMMAX?
2013-04-22 22:30 UTC Steve Atkins <steve@blighty.com>
` Re: Issues with OSX and SHMMAX?
2013-04-23 00:39 UTC Tom Lane <tgl@sss.pgh.pa.us>
[5+ messages in thread]
Performance with the new security release
2013-04-22 16:48 UTC Anne Rosset <arosset@collab.net>
` Re: Performance with the new security release
2013-04-22 17:41 UTC Heikki Linnakangas <hlinnakangas@vmware.com>
[2+ messages in thread]
Re: - why only 9.1?
2013-04-22 08:26 UTC Ireneusz Pluta <ipluta@wp.pl>
(no subject)
2013-04-21 12:46 UTC sunil virmani <sunhcl@gmail.com>
` Re:
2013-04-21 17:00 UTC Rob Wultsch <wultsch@gmail.com>
` Re:
2013-04-21 17:28 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re:
2013-04-21 17:32 UTC Scott Marlowe <scott.marlowe@gmail.com>
[4+ messages in thread]
maintenance_work_mem and autovacuum_max_workers
2013-04-19 21:55 UTC Rodrigo Barboza <rodrigombufrj@gmail.com>
slow bitmap heap scans on pg 9.2
2013-04-10 13:49 UTC Steve Singer <ssinger@ca.afilias.info>
` Re: slow bitmap heap scans on pg 9.2
2013-04-10 13:56 UTC ktm@rice.edu <ktm@rice.edu>
` Re: slow bitmap heap scans on pg 9.2
2013-04-10 15:56 UTC Steve Singer <ssinger@ca.afilias.info>
` Re: slow bitmap heap scans on pg 9.2
2013-04-10 17:49 UTC ktm@rice.edu <ktm@rice.edu>
` Re: slow bitmap heap scans on pg 9.2
2013-04-10 18:06 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: slow bitmap heap scans on pg 9.2
2013-04-10 18:15 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: slow bitmap heap scans on pg 9.2
2013-04-10 23:54 UTC Steve Singer <ssinger@ca.afilias.info>
` Re: slow bitmap heap scans on pg 9.2
2013-04-11 14:20 UTC Steve Singer <ssinger@ca.afilias.info>
` Re: slow bitmap heap scans on pg 9.2
2013-04-13 01:20 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: slow bitmap heap scans on pg 9.2
2013-04-13 16:14 UTC Steve Singer <ssinger@ca.afilias.info>
` Re: slow bitmap heap scans on pg 9.2
2013-04-13 20:54 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: slow bitmap heap scans on pg 9.2
2013-04-15 00:06 UTC Steve Singer <ssinger@ca.afilias.info>
` Re: slow bitmap heap scans on pg 9.2
2013-04-19 17:04 UTC Steve Singer <ssinger@ca.afilias.info>
[13+ messages in thread]
SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object
2013-04-17 16:01 UTC itishree sukla <itishree.sukla@gmail.com>
` Re: SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object
2013-04-17 18:48 UTC Alfonso Afonso <aafonsoc@gmail.com>
` Re: [PERFORM] SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object
2013-04-18 21:17 UTC Vitalii Tymchyshyn <tivv00@gmail.com>
[3+ messages in thread]
High CPU usage buy low I/O wait
2013-04-11 23:30 UTC bing1221 <bzhao@recognia.com>
` Re: High CPU usage buy low I/O wait
2013-04-18 20:54 UTC ktm@rice.edu <ktm@rice.edu>
[2+ messages in thread]
Postgresql performance degrading... how to diagnose the root cause
2013-03-29 14:20 UTC Franck Routier <franck.routier@axege.com>
` Re: Postgresql performance degrading... how to diagnose the root cause
2013-03-29 14:42 UTC Julien Cigar <jcigar@ulb.ac.be>
` Re: Postgresql performance degrading... how to diagnose the root cause
2013-03-29 14:50 UTC Guillaume Cottenceau <gc@mnc.ch>
` Re: Postgresql performance degrading... how to diagnose the root cause
2013-03-29 15:31 UTC Franck Routier <franck.routier@axege.com>
` Re: Postgresql performance degrading... how to diagnose the root cause
2013-03-29 23:23 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Postgresql performance degrading... how to diagnose the root cause
2013-03-30 00:02 UTC Guillaume Cottenceau <gc@mnc.ch>
` Re: Postgresql performance degrading... how to diagnose the root cause
2013-03-30 12:57 UTC Cédric Villemain <cedric@2ndquadrant.com>
` Re: Postgresql performance degrading... how to diagnose the root cause
2013-03-30 19:00 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Postgresql performance degrading... how to diagnose the root cause
2013-04-16 09:16 UTC Franck Routier <franck.routier@axege.com>
[9+ messages in thread]
Poor performance on an aggregate query
2013-04-15 20:59 UTC Anne Rosset <arosset@collab.net>
` Re: Poor performance on an aggregate query
2013-04-15 21:04 UTC Peter Geoghegan <peter.geoghegan86@gmail.com>
[2+ messages in thread]
[next (older)]
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox