pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Append Cost in query planners
  2007-10-28 15:22 UTC  Nimesh Satam <nimesh.zedo@gmail.com>
` Re: Append Cost in query planners
  2007-10-28 15:38 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
` Re: Append Cost in query planners
  2007-10-28 18:22 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
` Re: Append Cost in query planners
  2007-10-29 11:09 UTC  Nimesh Satam <nimesh.zedo@gmail.com>
` Re: Append Cost in query planners
  2007-10-29 11:40 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
` Re: Append Cost in query planners
  2007-10-29 11:55 UTC  Nimesh Satam <nimesh.zedo@gmail.com>
` Re: Append Cost in query planners
  2007-10-29 15:22 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
  [7+ messages in thread]

Outer joins and Seq scans
  2007-10-28 21:25 UTC  Sami Dalouche <skoobi@free.fr>
` Re: Outer joins and Seq scans
  2007-10-28 22:08 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Outer joins and Seq scans
  2007-10-28 22:55 UTC  Sami Dalouche <skoobi@free.fr>
` Re: Outer joins and Seq scans
  2007-10-28 23:45 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Outer joins and Seq scans
  2007-10-29 09:48 UTC  Dimitri Fontaine <dfontaine@hi-media.com>
` Re: Outer joins and Seq scans
  2007-10-29 11:11 UTC  Richard Huxton <dev@archonet.com>
` Re: Outer joins and Seq scans
  2007-10-29 11:28 UTC  Cédric Villemain <cedric.villemain@dalibo.com>
  [7+ messages in thread]

Speed difference between select ... union select ... and select from partitioned_table
  2007-10-26 20:37 UTC  Pablo Alcaraz <pabloa@laotraesquina.com.ar>
` Re: Speed difference between select ... union select ... and select from partitioned_table
  2007-10-26 21:07 UTC  Jeff Davis <pgsql@j-davis.com>
` Re: Speed difference between select ... union select ... and select from partitioned_table
  2007-10-26 21:10 UTC  Pablo Alcaraz <pabloa@laotraesquina.com.ar>
` Re: Speed difference between select ... union select ... and select from partitioned_table
  2007-10-26 21:12 UTC  Gregory Stark <stark@enterprisedb.com>
` Re: Speed difference between select ... union select ... and select from partitioned_table
  2007-10-27 05:14 UTC  Pablo Alcaraz <pabloa@laotraesquina.com.ar>
` Re: Speed difference between select ... union select ... and select from partitioned_table
  2007-10-27 13:15 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Speed difference between select ... union select ... and select from partitioned_table
  2007-10-27 21:26 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: Speed difference between select ... union select ... and select from partitioned_table
  2007-10-27 22:31 UTC  Pablo Alcaraz <pabloa@laotraesquina.com.ar>
  [8+ messages in thread]

Bunching "transactions"
  2007-10-25 15:30 UTC  Jean-David Beyer <jeandavid8@verizon.net>
` Re: Bunching "transactions"
  2007-10-25 15:51 UTC  Erik Jones <erik@myemma.com>
` Re: Bunching "transactions"
  2007-10-25 16:06 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
` Re: Bunching "transactions"
  2007-10-25 16:21 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Bunching "transactions"
  2007-10-25 17:55 UTC  Chris Browne <cbbrowne@acm.org>
` Re: Bunching "transactions"
  2007-10-25 19:15 UTC  Jean-David Beyer <jeandavid8@verizon.net>
` Re: Bunching "transactions"
  2007-10-25 20:46 UTC  Chris Browne <cbbrowne@acm.org>
` Re: Bunching "transactions"
  2007-10-26 13:04 UTC  Jean-David Beyer <jeandavid8@verizon.net>
` Re: Bunching "transactions"
  2007-10-26 14:12 UTC  Jean-David Beyer <jeandavid8@verizon.net>
` Re: Bunching "transactions"
  2007-10-26 15:08 UTC  Greg Smith <gsmith@gregsmith.com>
  [10+ messages in thread]

Finalizing commit taking very long
  2007-10-24 10:44 UTC  Giulio Cesare Solaroli <giulio.cesare@gmail.com>
` Re: Finalizing commit taking very long
  2007-10-24 13:15 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Finalizing commit taking very long
  2007-10-24 13:37 UTC  Giulio Cesare Solaroli <giulio.cesare@gmail.com>
` Re: Finalizing commit taking very long
  2007-10-24 14:03 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Finalizing commit taking very long
  2007-10-24 14:25 UTC  Giulio Cesare Solaroli <giulio.cesare@gmail.com>
` Re: Finalizing commit taking very long
  2007-10-26 12:41 UTC  Giulio Cesare Solaroli <giulio.cesare@gmail.com>
  [6+ messages in thread]

PostgreSQL 8.3beta1 on Solaris testing case study
  2007-10-25 14:04 UTC  Jignesh K. Shah <J.K.Shah@Sun.COM>

multiple apaches against single postgres database
  2007-10-24 12:15 UTC  Honza Novak <kacerr@developers.zlutazimnice.cz>
` Re: multiple apaches against single postgres database
  2007-10-24 13:08 UTC  Michal Taborsky - Internet Mall <michal.taborsky@mall.cz>
` Re: multiple apaches against single postgres database
  2007-10-24 13:17 UTC  Gregory Stark <stark@enterprisedb.com>
` Re: multiple apaches against single postgres database
  2007-10-24 14:33 UTC  Sven Geisler <sgeisler@aeccom.com>
` Re: multiple apaches against single postgres database
  2007-10-24 17:22 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: multiple apaches against single postgres database
  2007-10-25 03:26 UTC  Tatsuo Ishii <ishii@postgresql.org>
  [6+ messages in thread]

12 hour table vacuums
  2007-10-23 15:53 UTC  Ron St-Pierre <ron.pgsql@shaw.ca>
` Re: 12 hour table vacuums
  2007-10-23 16:07 UTC  Bill Moran <wmoran@collaborativefusion.com>
` Re: 12 hour table vacuums
  2007-10-23 16:11 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: 12 hour table vacuums
  2007-10-23 16:12 UTC  Alvaro Herrera <alvherre@commandprompt.com>
` Re: 12 hour table vacuums
  2007-10-23 16:21 UTC  Csaba Nagy <nagy@ecircle-ag.com>
` Re: 12 hour table vacuums
  2007-10-23 16:33 UTC  Ron St-Pierre <ron.pgsql@shaw.ca>
` Re: 12 hour table vacuums
  2007-10-23 16:38 UTC  Gregory Stark <stark@enterprisedb.com>
` Re: 12 hour table vacuums
  2007-10-23 16:41 UTC  Bill Moran <wmoran@collaborativefusion.com>
` Re: 12 hour table vacuums
  2007-10-23 16:43 UTC  Ron St-Pierre <ron.pgsql@shaw.ca>
` Re: 12 hour table vacuums
  2007-10-23 16:52 UTC  Ron St-Pierre <ron.pgsql@shaw.ca>
` Re: 12 hour table vacuums
  2007-10-23 17:00 UTC  Ron St-Pierre <ron.pgsql@shaw.ca>
` Re: 12 hour table vacuums
  2007-10-23 17:41 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: 12 hour table vacuums
  2007-10-23 18:03 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: 12 hour table vacuums
  2007-10-23 18:22 UTC  Alvaro Herrera <alvherre@commandprompt.com>
` Re: 12 hour table vacuums
  2007-10-23 18:23 UTC  Alvaro Herrera <alvherre@commandprompt.com>
` Re: 12 hour table vacuums
  2007-10-24 09:04 UTC  Harald Fuchs <hf0217x@protecting.net>
` Re: 12 hour table vacuums
  2007-10-24 13:14 UTC  Jean-David Beyer <jeandavid8@verizon.net>
  [17+ messages in thread]

Seqscan
  2007-10-23 02:24 UTC  Adrian Demaestri <ademaestri@yahoo.com>
` Re: Seqscan
  2007-10-23 02:45 UTC  Jeff Davis <pgsql@j-davis.com>
` Re: Seqscan
  2007-10-23 13:06 UTC  Adrian Demaestri <ademaestri@yahoo.com>
` Re: Seqscan
  2007-10-23 13:36 UTC  Nis Jørgensen <nis@superlativ.dk>
  [4+ messages in thread]

How to improve speed of 3 table join &group (HUGE tables)
  2007-10-18 17:01 UTC  John Major <major@cbio.mskcc.org>
` Re: How to improve speed of 3 table join &group (HUGE tables)
  2007-10-18 18:58 UTC  Nis Jørgensen <nis@superlativ.dk>
` Re: How to improve speed of 3 table join &group (HUGE tables)
  2007-10-18 19:06 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
` Re: How to improve speed of 3 table join &group (HUGE tables)
  2007-10-18 19:46 UTC  John Major <major@cbio.mskcc.org>
` Re: How to improve speed of 3 table join &group (HUGE tables)
  2007-10-18 20:04 UTC  John Major <major@cbio.mskcc.org>
` Re: How to improve speed of 3 table join &group (HUGE tables)
  2007-10-19 04:40 UTC  ismo.tuononen@solenovo.fi
` Re: How to improve speed of 3 table join &group (HUGE tables)
  2007-10-23 11:16 UTC  Nis Jørgensen <nis@superlativ.dk>
  [7+ messages in thread]

need help with a query
  2007-10-19 15:05 UTC  Pavel Velikhov <pvelikhov@yahoo.com>
` Re: need help with a query
  2007-10-19 15:52 UTC  Jonah H. Harris <jonah.harris@gmail.com>
` Re: need help with a query
  2007-10-19 16:11 UTC  Pavel Velikhov <pvelikhov@yahoo.com>
` Re: need help with a query
  2007-10-19 16:34 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: need help with a query
  2007-10-20 20:11 UTC  Pavel Velikhov <pvelikhov@yahoo.com>
` Re: need help with a query
  2007-10-21 16:44 UTC  Jonah H. Harris <jonah.harris@gmail.com>
` Re: need help with a query
  2007-10-23 09:54 UTC  Pavel Velikhov <pvelikhov@yahoo.com>
  [7+ messages in thread]

Memory Settings....
  2007-10-22 16:10 UTC  Lee Keel <lee.keel@uai.com>
` Re: Memory Settings....
  2007-10-22 17:15 UTC  Peter Koczan <pjkoczan@gmail.com>
` Re: Memory Settings....
  2007-10-22 17:23 UTC  Ben <bench@silentmedia.com>
` Re: Memory Settings....
  2007-10-22 17:30 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
` Re: Memory Settings....
  2007-10-22 17:34 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
  [5+ messages in thread]

two queryes in a single tablescan
  2007-10-17 12:30 UTC  Stefano Dal Pra <s.dalpra@gmail.com>
` Re: two queryes in a single tablescan
  2007-10-17 13:00 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
` Re: two queryes in a single tablescan
  2007-10-17 13:15 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: two queryes in a single tablescan
  2007-10-17 13:21 UTC  Stefano Dal Pra <s.dalpra@gmail.com>
` Re: two queryes in a single tablescan
  2007-10-17 13:39 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
` Re: two queryes in a single tablescan
  2007-10-18 02:24 UTC  李彦 Ian Li <liyan82@gmail.com>
` Re: [SQL] two queryes in a single tablescan
  2007-10-20 10:58 UTC  Markus Schaber <schabi@logix-tt.com>
` Re: [SQL] two queryes in a single tablescan
  2007-10-20 17:19 UTC  Andreas Kretschmer <akretschmer@spamfence.net>
` Re: [SQL] two queryes in a single tablescan
  2007-10-20 22:02 UTC  Erik Jones <erik@myemma.com>
  [9+ messages in thread]

how to improve the performance of creating index
  2007-10-19 11:57 UTC  Yinan Li <yinanli@cse.ust.hk>
` Re: how to improve the performance of creating index
  2007-10-19 12:03 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
` Re: how to improve the performance of creating index
  2007-10-19 12:52 UTC  Chris Browne <cbbrowne@acm.org>
` Re: how to improve the performance of creating index
  2007-10-19 14:50 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
` Re: how to improve the performance of creating index
  2007-10-19 18:21 UTC  Scott Marlowe <scott.marlowe@gmail.com>
  [5+ messages in thread]

Incorrect estimates on columns
  2007-10-17 17:34 UTC  Chris Kratz <chris.kratz@vistashare.com>
` Re: Incorrect estimates on columns
  2007-10-17 18:49 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Incorrect estimates on columns
  2007-10-17 19:43 UTC  Chris Kratz <chris.kratz@vistashare.com>
` Re: Incorrect estimates on columns
  2007-10-18 00:23 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Incorrect estimates on columns
  2007-10-18 09:29 UTC  Nis Jørgensen <nis@superlativ.dk>
` Re: Incorrect estimates on columns
  2007-10-18 20:03 UTC  Chris Kratz <chris.kratz@vistashare.com>
  [6+ messages in thread]

Vacuum goes worse
  2007-10-16 08:48 UTC  Stéphane Schildknecht <stephane.schildknecht@postgresqlfr.org>
` Re: Vacuum goes worse
  2007-10-16 09:08 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
` Re: Vacuum goes worse
  2007-10-16 09:50 UTC  Stéphane Schildknecht <stephane.schildknecht@postgresqlfr.org>
` Re: Vacuum goes worse
  2007-10-16 14:26 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Vacuum goes worse
  2007-10-16 15:26 UTC  Stéphane Schildknecht <stephane.schildknecht@postgresqlfr.org>
` Re: Vacuum goes worse
  2007-10-16 15:30 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Vacuum goes worse
  2007-10-16 15:43 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Vacuum goes worse
  2007-10-16 16:03 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Vacuum goes worse
  2007-10-17 00:03 UTC  Brian Herlihy <btherl@yahoo.com.au>
` Re: Vacuum goes worse
  2007-10-17 01:16 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Vacuum goes worse
  2007-10-17 03:19 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: Vacuum goes worse
  2007-10-17 11:33 UTC  Stéphane Schildknecht <stephane.schildknecht@postgresqlfr.org>
` Re: Vacuum goes worse
  2007-10-17 13:43 UTC  Alvaro Herrera <alvherre@commandprompt.com>
` Re: Vacuum goes worse
  2007-10-17 14:35 UTC  Stefano Dal Pra <s.dalpra@gmail.com>
` Re: Vacuum goes worse
  2007-10-17 15:53 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Vacuum goes worse
  2007-10-17 15:56 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Vacuum goes worse
  2007-10-17 16:07 UTC  Alvaro Herrera <alvherre@commandprompt.com>
` Re: Vacuum goes worse
  2007-10-17 18:43 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Vacuum goes worse
  2007-10-18 06:17 UTC  Stéphane Schildknecht <stephane.schildknecht@postgresqlfr.org>
` Re: Vacuum goes worse
  2007-10-18 06:19 UTC  Stéphane Schildknecht <stephane.schildknecht@postgresqlfr.org>
  [20+ messages in thread]

Shared Buffer setting in postgresql.conf
  2007-10-09 20:12 UTC  Radhika S <radhika.sambamurti@gmail.com>
` Re: Shared Buffer setting in postgresql.conf
  2007-10-10 05:25 UTC  Marcin Stępnicki <mstepnicki@gmail.com>
` Re: Shared Buffer setting in postgresql.conf
  2007-10-10 15:20 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Shared Buffer setting in postgresql.conf
  2007-10-10 20:32 UTC  Josh Trutwin <josh@trutwins.homeip.net>
` Re: Shared Buffer setting in postgresql.conf
  2007-10-10 20:58 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Shared Buffer setting in postgresql.conf
  2007-10-11 00:33 UTC  Radhika S <radhika.sambamurti@gmail.com>
` Re: Shared Buffer setting in postgresql.conf
  2007-10-11 00:49 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Shared Buffer setting in postgresql.conf
  2007-10-18 01:33 UTC  Ow Mun Heng <Ow.Mun.Heng@wdc.com>
  [8+ messages in thread]

Huge amount of memory consumed during transaction
  2007-10-11 14:04 UTC  henk de wit <henk53602@hotmail.com>
` Re: Huge amount of memory consumed during transaction
  2007-10-11 14:16 UTC  Richard Huxton <dev@archonet.com>
` Re: Huge amount of memory consumed during transaction
  2007-10-11 14:27 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Huge amount of memory consumed during transaction
  2007-10-11 14:51 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Huge amount of memory consumed during transaction
  2007-10-11 16:51 UTC  Erik Jones <erik@myemma.com>
` Re: Huge amount of memory consumed during transaction
  2007-10-11 17:49 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Huge amount of memory consumed during transaction
  2007-10-11 23:21 UTC  henk de wit <henk53602@hotmail.com>
` Re: Huge amount of memory consumed during transaction
  2007-10-11 23:23 UTC  henk de wit <henk53602@hotmail.com>
` Re: Huge amount of memory consumed during transaction
  2007-10-12 01:26 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Huge amount of memory consumed during transaction
  2007-10-12 19:59 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Huge amount of memory consumed during transaction
  2007-10-12 21:09 UTC  henk de wit <henk53602@hotmail.com>
` Re: Huge amount of memory consumed during transaction
  2007-10-12 21:39 UTC  Erik Jones <erik@myemma.com>
` Re: Huge amount of memory consumed during transaction
  2007-10-12 21:48 UTC  henk de wit <henk53602@hotmail.com>
` Re: Huge amount of memory consumed during transaction
  2007-10-12 22:13 UTC  Erik Jones <erik@myemma.com>
` Re: Huge amount of memory consumed during transaction
  2007-10-17 20:40 UTC  Alvaro Herrera <alvherre@commandprompt.com>
` Re: Huge amount of memory consumed during transaction
  2007-10-17 23:28 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [16+ messages in thread]

using a stored proc that returns a result set in a complex SQL stmt
  2007-10-15 16:09 UTC  chrisj <chrisj.wood@sympatico.ca>
` Re: using a stored proc that returns a result set in a complex SQL stmt
  2007-10-16 15:22 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
` Re: using a stored proc that returns a result set in a complex SQL stmt
  2007-10-17 05:32 UTC  Marcin Stępnicki <mstepnicki@gmail.com>
  [3+ messages in thread]

How to speed up min/max(id) in 50M rows table?
  2007-10-12 20:41 UTC  henk de wit <henk53602@hotmail.com>
` Re: How to speed up min/max(id) in 50M rows table?
  2007-10-12 20:53 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: How to speed up min/max(id) in 50M rows table?
  2007-10-12 20:59 UTC  henk de wit <henk53602@hotmail.com>
` Re: How to speed up min/max(id) in 50M rows table?
  2007-10-12 21:19 UTC  henk de wit <henk53602@hotmail.com>
` Re: How to speed up min/max(id) in 50M rows table?
  2007-10-12 21:40 UTC  henk de wit <henk53602@hotmail.com>
` Re: How to speed up min/max(id) in 50M rows table?
  2007-10-12 22:03 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: How to speed up min/max(id) in 50M rows table?
  2007-10-12 22:04 UTC  Alan Hodgson <ahodgson@simkin.ca>
` Re: How to speed up min/max(id) in 50M rows table?
  2007-10-12 22:17 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: How to speed up min/max(id) in 50M rows table?
  2007-10-12 22:21 UTC  henk de wit <henk53602@hotmail.com>
` Re: How to speed up min/max(id) in 50M rows table?
  2007-10-12 22:51 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: How to speed up min/max(id) in 50M rows table?
  2007-10-12 23:13 UTC  henk de wit <henk53602@hotmail.com>
` Re: How to speed up min/max(id) in 50M rows table?
  2007-10-12 23:48 UTC  henk de wit <henk53602@hotmail.com>
  [12+ messages in thread]

Performance problems with prepared statements
  2007-10-10 14:45 UTC  Theo Kramer <theo@flame.co.za>
` Re: Performance problems with prepared statements
  2007-10-10 15:00 UTC  Cédric Villemain <cedric.villemain@dalibo.com>
` Re: Performance problems with prepared statements
  2007-10-10 19:34 UTC  Theo Kramer <theo@flame.co.za>
` Re: Performance problems with prepared statements
  2007-10-10 19:55 UTC  Jonah H. Harris <jonah.harris@gmail.com>
` Re: Performance problems with prepared statements
  2007-10-10 20:08 UTC  Theo Kramer <theo@flame.co.za>
` Re: Performance problems with prepared statements
  2007-10-11 08:51 UTC  Cédric Villemain <cedric.villemain@dalibo.com>
` Re: Performance problems with prepared statements
  2007-10-11 09:12 UTC  Richard Huxton <dev@archonet.com>
` Re: Performance problems with prepared statements
  2007-10-11 10:33 UTC  Theo Kramer <theo@flame.co.za>
` Re: Performance problems with prepared statements
  2007-10-11 17:28 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: Performance problems with prepared statements
  2007-10-11 18:28 UTC  Andrew - Supernews <andrew+nonews@supernews.com>
` Re: Performance problems with prepared statements
  2007-10-11 20:04 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: Performance problems with prepared statements
  2007-10-12 07:35 UTC  Theo Kramer <theo@flame.co.za>
` Re: Performance problems with prepared statements
  2007-10-12 07:38 UTC  Theo Kramer <theo@flame.co.za>
` Re: Performance problems with prepared statements
  2007-10-12 08:05 UTC  Theo Kramer <theo@flame.co.za>
` Re: Performance problems with prepared statements
  2007-10-12 08:26 UTC  Richard Huxton <dev@archonet.com>
` Re: Performance problems with prepared statements
  2007-10-12 13:02 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: Performance problems with prepared statements
  2007-10-12 14:57 UTC  Theo Kramer <theo@flame.co.za>
` Re: Performance problems with prepared statements
  2007-10-12 19:03 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
  [18+ messages in thread]

Slow TSearch2 performance for table with 1 million documents.
  2007-10-05 07:50 UTC  Benjamin Arai <benjamin@araisoft.com>
` Re: Slow TSearch2 performance for table with 1 million documents.
  2007-10-05 12:00 UTC  Alban Hertroys <a.hertroys@magproductions.nl>
` Re: Slow TSearch2 performance for table with 1 million documents.
  2007-10-05 15:12 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] Slow TSearch2 performance for table with 1 million documents.
  2007-10-05 15:32 UTC  Oleg Bartunov <oleg@sai.msu.su>
` Re: [PERFORM] Slow TSearch2 performance for table with 1 million documents.
  2007-10-05 22:57 UTC  Benjamin Arai <benjamin@araisoft.com>
` Re: [PERFORM] Slow TSearch2 performance for table with 1 million documents.
  2007-10-11 14:52 UTC  Benjamin Arai <me@benjaminarai.com>
` Re: [PERFORM] Slow TSearch2 performance for table with 1 million documents.
  2007-10-11 15:53 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] Slow TSearch2 performance for table with 1 million documents.
  2007-10-11 16:12 UTC  Benjamin Arai <me@benjaminarai.com>
  [8+ messages in thread]

building a performance test suite
  2007-10-10 22:21 UTC  Kevin Kempter <kevin@kevinkempterllc.com>
` Re: building a performance test suite
  2007-10-11 03:14 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: building a performance test suite
  2007-10-11 08:52 UTC  Dimitri Fontaine <dfontaine@hi-media.com>
  [3+ messages in thread]

Query taking too long. Problem reading explain output.
  2007-10-03 08:03 UTC  Henrik <henke@mac.se>
` Re: Query taking too long. Problem reading explain output.
  2007-10-03 13:31 UTC  Michael Fuhr <mike@fuhr.org>
` Re: Query taking too long. Problem reading explain output.
  2007-10-03 14:15 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query taking too long. Problem reading explain output.
  2007-10-04 10:15 UTC  Henrik <henke@mac.se>
` Re: Query taking too long. Problem reading explain output.
  2007-10-04 12:30 UTC  Alvaro Herrera <alvherre@commandprompt.com>
` Re: Query taking too long. Problem reading explain output.
  2007-10-04 21:15 UTC  Henrik <henke@mac.se>
` Re: Query taking too long. Problem reading explain output.
  2007-10-04 23:43 UTC  Alvaro Herrera <alvherre@commandprompt.com>
` Re: Query taking too long. Problem reading explain output.
  2007-10-11 03:16 UTC  Ow Mun Heng <Ow.Mun.Heng@wdc.com>
  [8+ messages in thread]

hashjoin chosen over 1000x faster plan
  2007-10-09 20:09 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: hashjoin chosen over 1000x faster plan
  2007-10-10 06:31 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: hashjoin chosen over 1000x faster plan
  2007-10-10 14:15 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: hashjoin chosen over 1000x faster plan
  2007-10-10 17:05 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: hashjoin chosen over 1000x faster plan
  2007-10-10 18:07 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: hashjoin chosen over 1000x faster plan
  2007-10-10 18:30 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: hashjoin chosen over 1000x faster plan
  2007-10-10 18:54 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: hashjoin chosen over 1000x faster plan
  2007-10-10 19:01 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: hashjoin chosen over 1000x faster plan
  2007-10-10 19:35 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: hashjoin chosen over 1000x faster plan
  2007-10-10 19:52 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: hashjoin chosen over 1000x faster plan
  2007-10-10 20:11 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: hashjoin chosen over 1000x faster plan
  2007-10-10 20:32 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: hashjoin chosen over 1000x faster plan
  2007-10-10 20:48 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: hashjoin chosen over 1000x faster plan
  2007-10-10 21:02 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: hashjoin chosen over 1000x faster plan
  2007-10-10 22:08 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: hashjoin chosen over 1000x faster plan
  2007-10-10 22:09 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
  [16+ 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