pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedTuning massive UPDATES and GROUP BY's?
2011-03-10 15:40 UTC fork <forkandwait@gmail.com>
` Re: Tuning massive UPDATES and GROUP BY's?
2011-03-10 16:45 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Tuning massive UPDATES and GROUP BY's?
2011-03-10 18:04 UTC fork <forkandwait@gmail.com>
` Re: Tuning massive UPDATES and GROUP BY's?
2011-03-10 22:42 UTC Marti Raudsepp <marti@juffo.org>
` Re: Tuning massive UPDATES and GROUP BY's?
2011-03-11 19:06 UTC fork <forkandwait@gmail.com>
` Re: Tuning massive UPDATES and GROUP BY's?
2011-03-12 17:07 UTC Marti Raudsepp <marti@juffo.org>
` Re: Tuning massive UPDATES and GROUP BY's?
2011-03-13 16:36 UTC runner <runner@winning.com>
` Re: Tuning massive UPDATES and GROUP BY's?
2011-03-14 10:17 UTC Marti Raudsepp <marti@juffo.org>
` Re: Tuning massive UPDATES and GROUP BY's?
2011-03-14 13:34 UTC Greg Spiegelberg <gspiegelberg@gmail.com>
` Re: Tuning massive UPDATES and GROUP BY's?
2011-03-14 15:54 UTC runner <runner@winning.com>
[10+ messages in thread]
big joins not converging
2011-03-10 21:25 UTC Dan Ancona <da@vizbang.com>
` Re: big joins not converging
2011-03-10 22:13 UTC Steve Atkins <steve@blighty.com>
` Re: big joins not converging
2011-03-10 23:48 UTC fork <forkandwait@gmail.com>
` Re: big joins not converging
2011-03-11 00:43 UTC Dan Ancona <da@vizbang.com>
` Re: big joins not converging
2011-03-11 16:46 UTC fork <forkandwait@gmail.com>
[5+ messages in thread]
NULLS LAST performance
2011-02-23 19:27 UTC Mathieu De Zutter <mathieu@dezutter.org>
` Re: NULLS LAST performance
2011-02-23 19:48 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: NULLS LAST performance
2011-02-23 21:37 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: NULLS LAST performance
2011-02-24 09:47 UTC Mathieu De Zutter <mathieu@dezutter.org>
` Re: NULLS LAST performance
2011-03-09 23:01 UTC Jim Nasby <jim@nasby.net>
` Re: NULLS LAST performance
2011-03-10 15:55 UTC Robert Haas <robertmhaas@gmail.com>
` Re: NULLS LAST performance
2011-03-10 16:32 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: NULLS LAST performance
2011-03-11 04:36 UTC Robert Haas <robertmhaas@gmail.com>
[8+ messages in thread]
Basic performance tuning on dedicated server
2011-03-10 09:12 UTC runner <runner@winning.com>
` Re: Basic performance tuning on dedicated server
2011-03-10 18:02 UTC Merlin Moncure <mmoncure@gmail.com>
[2+ messages in thread]
Performance trouble finding records through related records
2011-03-02 00:14 UTC sverhagen <sverhagen@wps-nl.com>
` Re: Performance trouble finding records through related records
2011-03-02 03:41 UTC Andy Colson <andy@squeakycode.net>
` Re: Performance trouble finding records through related records
2011-03-03 00:12 UTC sverhagen <sverhagen@wps-nl.com>
` Re: Performance trouble finding records through related records
2011-03-03 03:04 UTC Andy Colson <andy@squeakycode.net>
` Re: Performance trouble finding records through related records
2011-03-03 09:19 UTC sverhagen <sverhagen@wps-nl.com>
` Re: Performance trouble finding records through related records
2011-03-03 14:55 UTC Andy Colson <andy@squeakycode.net>
` Re: Performance trouble finding records through related records
2011-03-07 19:25 UTC Robert Haas <robertmhaas@gmail.com>
` Re: Performance trouble finding records through related records
2011-03-07 20:27 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Performance trouble finding records through related records
2011-03-08 11:17 UTC sverhagen <sverhagen@wps-nl.com>
` Re: Performance trouble finding records through related records
2011-03-08 11:31 UTC sverhagen <sverhagen@wps-nl.com>
` Re: Performance trouble finding records through related records
2011-03-10 14:10 UTC sverhagen <sverhagen@wps-nl.com>
[11+ messages in thread]
Slow join on partitioned table
2011-03-04 11:40 UTC Mark Thornton <mthornton@optrak.co.uk>
` Re: Slow join on partitioned table
2011-03-04 16:07 UTC Robert Haas <robertmhaas@gmail.com>
` Re: Slow join on partitioned table
2011-03-04 16:47 UTC Mark Thornton <mthornton@optrak.co.uk>
` Re: Slow join on partitioned table
2011-03-04 17:00 UTC Mark Thornton <mthornton@optrak.co.uk>
` Re: Slow join on partitioned table
2011-03-04 18:06 UTC Robert Haas <robertmhaas@gmail.com>
` Re: Slow join on partitioned table
2011-03-09 22:42 UTC Conor Walsh <ctw@adverb.ly>
[6+ messages in thread]
Query performance with disabled hashjoin and mergejoin
2011-02-04 12:08 UTC Ivan Voras <ivoras@freebsd.org>
` Re: Query performance with disabled hashjoin and mergejoin
2011-02-04 14:44 UTC Greg Smith <greg@2ndquadrant.com>
` Re: Query performance with disabled hashjoin and mergejoin
2011-02-04 15:13 UTC Ivan Voras <ivoras@gmail.com>
` Re: Query performance with disabled hashjoin and mergejoin
2011-02-05 02:50 UTC Ivan Voras <ivoras@freebsd.org>
` Re: Query performance with disabled hashjoin and mergejoin
2011-02-23 03:07 UTC Robert Haas <robertmhaas@gmail.com>
` Re: Query performance with disabled hashjoin and mergejoin
2011-03-07 20:40 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Query performance with disabled hashjoin and mergejoin
2011-03-08 20:57 UTC Robert Haas <robertmhaas@gmail.com>
` Re: Query performance with disabled hashjoin and mergejoin
2011-03-08 21:24 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query performance with disabled hashjoin and mergejoin
2011-03-08 21:56 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Query performance with disabled hashjoin and mergejoin
2011-03-09 16:48 UTC Robert Haas <robertmhaas@gmail.com>
[10+ messages in thread]
Linux I/O schedulers - CFQ & random seeks
2011-03-04 17:34 UTC Glyn Astill <glynastill@yahoo.co.uk>
` Re: Linux I/O schedulers - CFQ & random seeks
2011-03-04 18:03 UTC Wayne Conrad <wayne@databill.com>
` Re: Linux I/O schedulers - CFQ & random seeks
2011-03-04 18:39 UTC Dan Harris <fbsd@drivefaster.net>
` Re: Linux I/O schedulers - CFQ & random seeks
2011-03-04 19:02 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Linux I/O schedulers - CFQ & random seeks
2011-03-04 19:07 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Linux I/O schedulers - CFQ & random seeks
2011-03-04 19:09 UTC Rosser Schwarz <rosser.schwarz@gmail.com>
` Re: Linux I/O schedulers - CFQ & random seeks
2011-03-06 00:38 UTC Omar Kilani <omar.kilani@gmail.com>
` Re: Linux I/O schedulers - CFQ & random seeks
2011-03-08 18:27 UTC Mindaugas Riauba <ml@kilimas.com>
[8+ messages in thread]
how to tune this query.
2006-07-04 16:00 UTC Luckys <plpgsql@gmail.com>
` Re: how to tune this query.
2006-07-04 16:18 UTC Nolan Cafferky <Nolan.Cafferky@rbsinteractive.com>
` Re: how to tune this query.
2006-07-07 17:42 UTC Merlin Moncure <mmoncure@gmail.com>
` How to tune this query
2011-03-08 05:01 UTC Adarsh Sharma <adarsh.sharma@orkash.com>
` Re: How to tune this query
2011-03-08 06:24 UTC Jaiswal Dhaval Sudhirkumar <JaiswalDS@microland.com>
[5+ messages in thread]
plan variations: join vs. exists vs. row comparison
2011-03-07 19:07 UTC Jon Nelson <jnelson+pgsql@jamponi.net>
` Re: plan variations: join vs. exists vs. row comparison
2011-03-07 20:00 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: plan variations: join vs. exists vs. row comparison
2011-03-07 20:05 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: plan variations: join vs. exists vs. row comparison
2011-03-07 20:06 UTC Jon Nelson <jnelson+pgsql@jamponi.net>
` Re: plan variations: join vs. exists vs. row comparison
2011-03-07 20:24 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
[5+ messages in thread]
Anyone tried Flashcache with PostgreSQL?
2011-02-28 19:09 UTC Josh Berkus <josh@agliodbs.com>
` Re: Anyone tried Flashcache with PostgreSQL?
2011-03-02 15:29 UTC Robert Haas <robertmhaas@gmail.com>
` Re: Anyone tried Flashcache with PostgreSQL?
2011-03-03 00:20 UTC Samuel Gendler <sgendler@ideasculptor.com>
` Re: Anyone tried Flashcache with PostgreSQL?
2011-03-03 08:15 UTC Arjen van der Meijden <acmmailing@tweakers.net>
` Re: Anyone tried Flashcache with PostgreSQL?
2011-03-07 15:48 UTC Cédric Villemain <cedric.villemain.debian@gmail.com>
[5+ messages in thread]
Fwd: Table Partitioning
2007-08-10 20:58 UTC Nurlan Mukhanov <nurike@gmail.com>
` Re: Fwd: Table Partitioning
2007-08-18 11:11 UTC Henrik <henke@mac.se>
` Table partitioning
2011-03-05 09:37 UTC Tobias Brox <tobixen@gmail.com>
` Re: Table partitioning
2011-03-05 09:57 UTC Mark Thornton <mthornton@optrak.com>
` Re: Table partitioning
2011-03-05 09:59 UTC Mark Thornton <mthornton@optrak.co.uk>
` Re: Table partitioning
2011-03-05 10:09 UTC Tobias Brox <tobixen@gmail.com>
[6+ messages in thread]
Is it require further tuning
2011-03-03 04:31 UTC Adarsh Sharma <adarsh.sharma@orkash.com>
` Re: Is it require further tuning
2011-03-04 14:55 UTC Robert Haas <robertmhaas@gmail.com>
[2+ messages in thread]
Slowing UPDATEs inside a transaction
2011-03-03 14:13 UTC Matt Burke <mattblists@icritical.com>
` Re: Slowing UPDATEs inside a transaction
2011-03-03 14:26 UTC Robert Haas <robertmhaas@gmail.com>
` Re: Slowing UPDATEs inside a transaction
2011-03-03 15:23 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Slowing UPDATEs inside a transaction
2011-03-04 09:21 UTC Matt Burke <mattblists@icritical.com>
` Re: Slowing UPDATEs inside a transaction
2011-03-04 14:20 UTC Robert Haas <robertmhaas@gmail.com>
` Re: Slowing UPDATEs inside a transaction
2011-03-04 14:51 UTC Merlin Moncure <mmoncure@gmail.com>
[6+ messages in thread]
Vacuum problem due to temp tables
2011-02-26 07:00 UTC Bhakti Ghatkar <bghatkar@zedo.com>
` Re: Vacuum problem due to temp tables
2011-02-26 17:25 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Vacuum problem due to temp tables
2011-02-28 05:08 UTC Bhakti Ghatkar <bghatkar@zedo.com>
` Re: Vacuum problem due to temp tables
2011-03-02 15:44 UTC Robert Haas <robertmhaas@gmail.com>
` Re: Vacuum problem due to temp tables
2011-03-04 10:26 UTC Vidhya Bondre <meetvbondre@gmail.com>
` Re: Vacuum problem due to temp tables
2011-03-04 14:14 UTC Robert Haas <robertmhaas@gmail.com>
[6+ messages in thread]
Is Query need to be optimized
2011-02-28 07:23 UTC Adarsh Sharma <adarsh.sharma@orkash.com>
` Re: Is Query need to be optimized
2011-03-03 09:07 UTC Grzegorz Jaśkiewicz <gryzman@gmail.com>
[2+ messages in thread]
Performance Test for PostgreSQL9
2011-02-28 03:26 UTC Selva manickaraja <mavles78@gmail.com>
` Re: Performance Test for PostgreSQL9
2011-02-28 04:18 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: Performance Test for PostgreSQL9
2011-02-28 05:09 UTC Selva manickaraja <mavles78@gmail.com>
` Re: Performance Test for PostgreSQL9
2011-02-28 05:53 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: Performance Test for PostgreSQL9
2011-02-28 06:39 UTC Selva manickaraja <mavles78@gmail.com>
` Re: Performance Test for PostgreSQL9
2011-02-28 06:42 UTC Jochen Erwied <jochen@pgsql-performance.erwied.eu>
` Re: Performance Test for PostgreSQL9
2011-02-28 06:51 UTC Melton Low <softw.db@gmail.com>
` Re: Performance Test for PostgreSQL9
2011-02-28 06:57 UTC Melton Low <softw.db@gmail.com>
` Re: Performance Test for PostgreSQL9
2011-02-28 09:10 UTC Selva manickaraja <mavles78@gmail.com>
` Re: Performance Test for PostgreSQL9
2011-02-28 11:30 UTC Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
` Re: Performance Test for PostgreSQL9
2011-03-02 18:19 UTC Robert Haas <robertmhaas@gmail.com>
` Re: Performance Test for PostgreSQL9
2011-03-02 18:29 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: Performance Test for PostgreSQL9
2011-03-03 01:46 UTC Selva manickaraja <mavles78@gmail.com>
` Re: Performance Test for PostgreSQL9
2011-03-03 04:01 UTC Greg Smith <greg@2ndquadrant.com>
` Re: Performance Test for PostgreSQL9
2011-03-03 05:16 UTC Selva manickaraja <mavles78@gmail.com>
` Re: Performance Test for PostgreSQL9
2011-03-03 05:20 UTC Joshua D. Drake <jd@commandprompt.com>
[16+ messages in thread]
Query on view radically slower than query on underlying table
2011-02-28 18:28 UTC Craig James <craig_james@emolecules.com>
` Re: Query on view radically slower than query on underlying table
2011-02-28 18:57 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query on view radically slower than query on underlying table
2011-02-28 19:23 UTC Craig James <craig_james@emolecules.com>
` Re: Query on view radically slower than query on underlying table
2011-02-28 19:58 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query on view radically slower than query on underlying table
2011-03-02 15:39 UTC Robert Haas <robertmhaas@gmail.com>
[5+ messages in thread]
Pushing IN (subquery) down through UNION ALL?
2011-02-24 04:10 UTC Dave Johansen <davejohansen@gmail.com>
` Pushing IN (subquery) down through UNION ALL?
2011-02-24 15:14 UTC Dave Johansen <davejohansen@gmail.com>
` Re: Pushing IN (subquery) down through UNION ALL?
2011-02-24 16:38 UTC Dave Johansen <davejohansen@gmail.com>
` Re: Pushing IN (subquery) down through UNION ALL?
2011-02-24 19:33 UTC Vik Reykja <vikreykja@gmail.com>
` Re: Pushing IN (subquery) down through UNION ALL?
2011-02-24 19:56 UTC Dave Johansen <davejohansen@gmail.com>
` Re: Pushing IN (subquery) down through UNION ALL?
2011-02-24 19:59 UTC Vik Reykja <vikreykja@gmail.com>
` Re: Pushing IN (subquery) down through UNION ALL?
2011-02-24 20:51 UTC Dave Johansen <davejohansen@gmail.com>
` Re: Pushing IN (subquery) down through UNION ALL?
2011-03-02 14:08 UTC Robert Haas <robertmhaas@gmail.com>
` Re: Pushing IN (subquery) down through UNION ALL?
2011-03-02 14:11 UTC Thom Brown <thom@linux.com>
` Re: Pushing IN (subquery) down through UNION ALL?
2011-03-02 14:22 UTC Robert Haas <robertmhaas@gmail.com>
` Re: Pushing IN (subquery) down through UNION ALL?
2011-03-02 14:23 UTC Thom Brown <thom@linux.com>
[11+ messages in thread]
inheritance: planning time vs children number vs column number
2011-02-28 09:38 UTC Marc Cousin <cousinmarc@gmail.com>
` Re: inheritance: planning time vs children number vs column number
2011-02-28 12:57 UTC Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
` Re: inheritance: planning time vs children number vs column number
2011-02-28 13:09 UTC Marc Cousin <cousinmarc@gmail.com>
` Re: inheritance: planning time vs children number vs column number
2011-02-28 15:35 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: inheritance: planning time vs children number vs column number
2011-02-28 18:47 UTC Marc Cousin <cousinmarc@gmail.com>
` Re: inheritance: planning time vs children number vs column number
2011-03-01 06:20 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: inheritance: planning time vs children number vs column number
2011-03-01 07:42 UTC Marc Cousin <cousinmarc@gmail.com>
` Re: inheritance: planning time vs children number vs column number
2011-03-01 15:33 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: inheritance: planning time vs children number vs column number
2011-03-01 15:39 UTC Marc Cousin <cousinmarc@gmail.com>
` Re: inheritance: planning time vs children number vs column number
2011-03-01 17:33 UTC Tom Lane <tgl@sss.pgh.pa.us>
[10+ messages in thread]
Talking about optimizer, my long dream
2011-02-04 08:03 UTC Віталій Тимчишин <tivv00@gmail.com>
` Re: Talking about optimizer, my long dream
2011-02-04 13:56 UTC Mladen Gogala <mladen.gogala@vmsinfo.com>
` Re: Talking about optimizer, my long dream
2011-02-04 14:02 UTC Shaun Thomas <sthomas@peak6.com>
` Re: Talking about optimizer, my long dream
2011-02-04 14:24 UTC Frank Heikens <frankheikens@mac.com>
` Re: Talking about optimizer, my long dream
2011-02-04 14:27 UTC Greg Smith <greg@2ndquadrant.com>
` Re: Talking about optimizer, my long dream
2011-02-04 14:36 UTC Mladen Gogala <mladen.gogala@vmsinfo.com>
` Re: Talking about optimizer, my long dream
2011-02-04 15:45 UTC Cédric Villemain <cedric.villemain.debian@gmail.com>
` Re: Talking about optimizer, my long dream
2011-02-04 16:06 UTC Mladen Gogala <mladen.gogala@vmsinfo.com>
` Re: Talking about optimizer, my long dream
2011-02-04 16:19 UTC Achilleas Mantzios <achill@matrix.gatewaynet.com>
` Re: Talking about optimizer, my long dream
2011-02-04 23:44 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: Talking about optimizer, my long dream
2011-02-05 04:54 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Talking about optimizer, my long dream
2011-02-05 05:38 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: Talking about optimizer, my long dream
2011-02-27 17:59 UTC Robert Haas <robertmhaas@gmail.com>
` Re: Talking about optimizer, my long dream
2011-02-27 22:20 UTC Віталій Тимчишин <tivv00@gmail.com>
` Re: Talking about optimizer, my long dream
2011-02-28 19:09 UTC Robert Haas <robertmhaas@gmail.com>
` Re: Talking about optimizer, my long dream
2011-03-01 15:37 UTC Merlin Moncure <mmoncure@gmail.com>
[16+ messages in thread]
Load and Stress on PostgreSQL 9.0
2011-02-28 16:25 UTC Selva manickaraja <mavles78@gmail.com>
` Re: Load and Stress on PostgreSQL 9.0
2011-02-28 18:35 UTC Josh Berkus <josh@agliodbs.com>
` Re: Load and Stress on PostgreSQL 9.0
2011-03-01 01:48 UTC Selva manickaraja <mavles78@gmail.com>
[3+ messages in thread]
optimalization
2011-02-28 09:41 UTC croolyc <croolists@gmail.com>
` Re: optimalization
2011-02-28 18:32 UTC Andreas Kretschmer <akretschmer@spamfence.net>
[2+ messages in thread]
Optimization
2003-07-28 16:18 UTC Justin Long <justinlong@strategicnetwork.org>
` Re: Optimization
2003-07-28 18:00 UTC Josh Berkus <josh@agliodbs.com>
` Re: Optimization
2003-07-28 18:25 UTC Nick Fankhauser - Doxpop <nickf@doxpop.com>
` Re: Optimization
2003-07-28 18:28 UTC Nick Fankhauser <nickf@ontko.com>
` Re: Optimization
2003-07-28 18:39 UTC Nick Fankhauser <nickf@ontko.com>
` Re: Optimization
2003-07-28 19:27 UTC Josh Berkus <josh@agliodbs.com>
` Re: Optimization
2003-07-29 06:51 UTC Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Optimization
2003-07-29 07:14 UTC Peter Childs <blue.dragon@blueyonder.co.uk>
` Re: Optimization
2003-07-29 07:21 UTC Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` optimization
2011-02-28 09:43 UTC croolyc <croolists@gmail.com>
` Re: optimization
2011-02-28 14:57 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
[11+ messages in thread]
Indexes with condition using immutable functions applied to column not used
2011-02-08 00:14 UTC Sylvain Rabot <sylvain@abstraction.fr>
` Re: Indexes with condition using immutable functions applied to column not used
2011-02-08 05:15 UTC Jesper Krogh <jesper@krogh.cc>
` Re: Indexes with condition using immutable functions applied to column not used
2011-02-08 17:30 UTC Sylvain Rabot <sylvain@abstraction.fr>
` Re: Indexes with condition using immutable functions applied to column not used
2011-02-08 20:08 UTC Sylvain Rabot <sylvain@abstraction.fr>
` Re: Re: Indexes with condition using immutable functions applied to column not used
2011-02-09 15:34 UTC Nick Lello <nick.lello@rentrakmail.com>
` Re: Indexes with condition using immutable functions applied to column not used
2011-02-27 18:21 UTC Robert Haas <robertmhaas@gmail.com>
[6+ 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