pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedANTI-JOIN needs table, index scan not possible?
2011-03-11 15:32 UTC hans wulf <lotu1@gmx.net>
` Re: ANTI-JOIN needs table, index scan not possible?
2011-03-11 17:18 UTC Maciek Sakrejda <msakrejda@truviso.com>
` Re: ANTI-JOIN needs table, index scan not possible?
2011-03-11 17:54 UTC hans wulf <lotu1@gmx.net>
` Re: ANTI-JOIN needs table, index scan not possible?
2011-03-11 22:16 UTC Kenneth Marshall <ktm@rice.edu>
` Re: ANTI-JOIN needs table, index scan not possible?
2011-03-11 22:32 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: ANTI-JOIN needs table, index scan not possible?
2011-03-23 04:31 UTC Robert Haas <robertmhaas@gmail.com>
[6+ messages in thread]
Performance on AIX
2011-03-19 09:00 UTC phb07 <phb07@apra.asso.fr>
` Re: Performance on AIX
2011-03-19 13:17 UTC Andy Colson <andy@squeakycode.net>
` Re: Performance on AIX
2011-03-22 21:24 UTC Josh Berkus <josh@agliodbs.com>
[3+ messages in thread]
Help: massive parallel update to the same table
2011-03-18 13:05 UTC Red Maple <redmapleleaf@gmail.com>
` Re: Help: massive parallel update to the same table
2011-03-18 14:23 UTC Nicholson, Brad (Toronto, ON, CA) <bnicholson@hp.com>
` Re: Help: massive parallel update to the same table
2011-03-18 14:28 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Help: massive parallel update to the same table
2011-03-18 16:06 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Help: massive parallel update to the same table
2011-03-18 18:21 UTC Red Maple <redmapleleaf@gmail.com>
` Re: Help: massive parallel update to the same table
2011-03-18 19:21 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Help: massive parallel update to the same table
2011-03-22 14:13 UTC Red Maple <redmapleleaf@gmail.com>
[7+ messages in thread]
Request for feedback on hardware for a new database server
2011-03-18 00:51 UTC Oliver Charles <postgresql-perf@ocharles.org.uk>
` Re: Request for feedback on hardware for a new database server
2011-03-18 02:05 UTC Steve Atkins <steve@blighty.com>
` Re: Request for feedback on hardware for a new database server
2011-03-18 03:02 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Request for feedback on hardware for a new database server
2011-03-18 06:19 UTC Jesper Krogh <jesper@krogh.cc>
` Re: Request for feedback on hardware for a new database server
2011-03-18 07:16 UTC Arjen van der Meijden <acmmailing@tweakers.net>
` Re: Request for feedback on hardware for a new database server
2011-03-18 09:11 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Request for feedback on hardware for a new database server
2011-03-18 12:44 UTC Arjen van der Meijden <acmmailing@tweakers.net>
` Re: Request for feedback on hardware for a new database server
2011-03-18 16:02 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Request for feedback on hardware for a new database server
2011-03-18 16:32 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Request for feedback on hardware for a new database server
2011-03-18 20:29 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Request for feedback on hardware for a new database server
2011-03-22 13:54 UTC Merlin Moncure <mmoncure@gmail.com>
[11+ messages in thread]
Fastest pq_restore?
2011-03-17 14:25 UTC Michael Andreasen <michael@dunlops.com>
` Re: Fastest pq_restore?
2011-03-18 01:08 UTC Andy Colson <andy@squeakycode.net>
` Re: Fastest pq_restore?
2011-03-18 14:38 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Fastest pq_restore?
2011-03-18 19:10 UTC Andy Colson <andy@squeakycode.net>
` Re: Fastest pq_restore?
2011-03-19 16:58 UTC bricklen <bricklen@gmail.com>
[5+ messages in thread]
Help with Query Tuning
2011-03-16 09:13 UTC Adarsh Sharma <adarsh.sharma@orkash.com>
` Re: Help with Query Tuning
2011-03-16 16:36 UTC Kenneth Marshall <ktm@rice.edu>
` Re: Help with Query Tuning
2011-03-16 17:24 UTC Reid Thompson <Reid.Thompson@ateb.com>
` Re: Help with Query Tuning
2011-03-17 04:48 UTC Adarsh Sharma <adarsh.sharma@orkash.com>
` Re: Help with Query Tuning
2011-03-17 06:25 UTC Adarsh Sharma <adarsh.sharma@orkash.com>
` Re: Help with Query Tuning
2011-03-17 09:34 UTC tv@fuzzy.cz
` Re: Help with Query Tuning
2011-03-18 04:17 UTC Adarsh Sharma <adarsh.sharma@orkash.com>
` Re: Help with Query Tuning
2011-03-18 14:05 UTC Reid Thompson <Reid.Thompson@ateb.com>
` Re: Help with Query Tuning
2011-03-18 15:30 UTC tv@fuzzy.cz
[9+ messages in thread]
Re: Disabling nested loops - worst case performance
2011-03-18 07:02 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Disabling nested loops - worst case performance
2011-03-18 07:15 UTC Anssi Kääriäinen <anssi.kaariainen@thl.fi>
` Re: Disabling nested loops - worst case performance
2011-03-18 10:52 UTC Vitalii Tymchyshyn <tivv00@gmail.com>
` Re: Disabling nested loops - worst case performance
2011-03-18 10:58 UTC Anssi Kääriäinen <anssi.kaariainen@thl.fi>
` Re: Disabling nested loops - worst case performance
2011-03-18 11:14 UTC Thomas Kellerer <spam_eater@gmx.net>
` Re: Disabling nested loops - worst case performance
2011-03-18 11:59 UTC Anssi Kääriäinen <anssi.kaariainen@thl.fi>
` Re: Disabling nested loops - worst case performance
2011-03-18 12:19 UTC Anssi Kääriäinen <anssi.kaariainen@thl.fi>
` Re: Disabling nested loops - worst case performance
2011-03-18 15:26 UTC Claudio Freire <klaussfreire@gmail.com>
[8+ messages in thread]
Updating histogram_bounds after a delete
2011-03-16 19:40 UTC Derrick Rice <derrick.rice@gmail.com>
` Re: Updating histogram_bounds after a delete
2011-03-16 19:41 UTC Derrick Rice <derrick.rice@gmail.com>
` Re: Updating histogram_bounds after a delete
2011-03-16 21:56 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Updating histogram_bounds after a delete
2011-03-17 13:27 UTC Derrick Rice <derrick.rice@gmail.com>
` Re: Updating histogram_bounds after a delete
2011-03-17 14:49 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Updating histogram_bounds after a delete
2011-03-17 14:55 UTC Kenneth Marshall <ktm@rice.edu>
` Re: Updating histogram_bounds after a delete
2011-03-17 15:00 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Updating histogram_bounds after a delete
2011-03-17 15:05 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
[8+ messages in thread]
pg_xlog size
2011-03-15 15:09 UTC Tech Madhu <technimadhu@gmail.com>
` Re: pg_xlog size
2011-03-16 17:27 UTC Euler Taveira de Oliveira <euler@timbira.com>
` Re: pg_xlog size
2011-03-16 21:27 UTC Tech Madhu <technimadhu@gmail.com>
` Re: pg_xlog size
2011-03-17 03:09 UTC Fujii Masao <masao.fujii@gmail.com>
[4+ messages in thread]
Table partitioning problem
2011-03-08 15:45 UTC Samba GUEYE <samba.gueye@intesens.com>
` Re: Table partitioning problem
2011-03-09 22:01 UTC Jim Nasby <jim@nasby.net>
` Re: Table partitioning problem
2011-03-10 08:25 UTC Samba GUEYE <samba.gueye@intesens.com>
` Re: Table partitioning problem
2011-03-11 18:31 UTC Robert Haas <robertmhaas@gmail.com>
` Re: Table partitioning problem
2011-03-14 16:42 UTC Samba GUEYE <samba.gueye@intesens.com>
` Re: Table partitioning problem
2011-03-14 19:40 UTC Robert Haas <robertmhaas@gmail.com>
` Re: Table partitioning problem
2011-03-14 20:22 UTC Conor Walsh <ctw@adverb.ly>
` Re: Table partitioning problem
2011-03-15 10:10 UTC Samba GUEYE <samba.gueye@intesens.com>
` Re: Table partitioning problem
2011-03-15 13:18 UTC Shaun Thomas <sthomas@peak6.com>
` Re: Table partitioning problem
2011-03-15 15:19 UTC Samba GUEYE <samba.gueye@intesens.com>
[10+ messages in thread]
unexpected stable function behavior
2011-03-10 16:26 UTC Julius Tuskenis <julius@nsoft.lt>
` Re: unexpected stable function behavior
2011-03-10 21:14 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: unexpected stable function behavior
2011-03-14 08:46 UTC Julius Tuskenis <julius@nsoft.lt>
` Re: unexpected stable function behavior
2011-03-14 13:41 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: unexpected stable function behavior
2011-03-14 14:08 UTC Andres Freund <andres@anarazel.de>
` Re: unexpected stable function behavior
2011-03-14 17:17 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: unexpected stable function behavior
2011-03-15 08:04 UTC Julius Tuskenis <julius@nsoft.lt>
` Re: unexpected stable function behavior
2011-03-15 08:12 UTC Julius Tuskenis <julius@nsoft.lt>
[8+ messages in thread]
Bug in the planner?
2011-03-14 17:24 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Bug in the planner?
2011-03-15 00:56 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
Re: Performance regression from 8.3.7 to 9.0.3
2011-03-14 15:54 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Performance regression from 8.3.7 to 9.0.3
2011-03-14 17:34 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Performance regression from 8.3.7 to 9.0.3
2011-03-14 17:59 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Performance regression from 8.3.7 to 9.0.3
2011-03-14 18:50 UTC Tom Lane <tgl@sss.pgh.pa.us>
[4+ messages in thread]
Planner wrongly shuns multi-column index for select .. order by col1, col2 limit 1
2011-03-12 10:07 UTC John Surcombe <John.Surcombe@digimap.gg>
` Re: Planner wrongly shuns multi-column index for select .. order by col1, col2 limit 1
2011-03-13 12:21 UTC Jeremy <jgh@wizmail.org>
` Re: Planner wrongly shuns multi-column index for select .. order by col1, col2 limit 1
2011-03-13 16:24 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Planner wrongly shuns multi-column index for select .. order by col1, col2 limit 1
2011-03-13 22:10 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Planner wrongly shuns multi-column index for select .. order by col1, col2 limit 1
2011-03-14 09:37 UTC John Surcombe <John.Surcombe@digimap.gg>
` Re: Planner wrongly shuns multi-column index for select .. order by col1, col2 limit 1
2011-03-14 17:24 UTC Tom Lane <tgl@sss.pgh.pa.us>
[6+ messages in thread]
Tuning 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]
[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