pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedHow to avoid hashjoin and mergejoin
2007-11-01 20:57 UTC Carlo Stonebanks <stonec.register@sympatico.ca>
` Re: How to avoid hashjoin and mergejoin
2007-11-01 21:38 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: How to avoid hashjoin and mergejoin
2007-11-01 21:41 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: How to avoid hashjoin and mergejoin
2007-11-02 04:12 UTC Carlo Stonebanks <stonec.register@sympatico.ca>
` Re: How to avoid hashjoin and mergejoin
2007-11-02 14:46 UTC Carlo Stonebanks <carlo@raspberryred.com>
[5+ messages in thread]
select max(field) from table much faster with a group by clause?
2007-11-01 13:07 UTC Palle Girgensohn <girgen@pingpong.net>
` Re: select max(field) from table much faster with a group by clause?
2007-11-01 13:43 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: select max(field) from table much faster with a group by clause?
2007-11-01 14:20 UTC Palle Girgensohn <girgen@pingpong.net>
` Re: select max(field) from table much faster with a group by clause?
2007-11-01 14:36 UTC Palle Girgensohn <girgen@pingpong.net>
` Re: select max(field) from table much faster with a group by clause?
2007-11-01 15:06 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: select max(field) from table much faster with a group by clause?
2007-11-01 15:25 UTC Palle Girgensohn <girgen@pingpong.net>
` Re: select max(field) from table much faster with a group by clause?
2007-11-01 15:28 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: select max(field) from table much faster with a group by clause?
2007-11-01 15:34 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: select max(field) from table much faster with a group by clause?
2007-11-01 15:47 UTC Gregory Stark <stark@enterprisedb.com>
` Re: select max(field) from table much faster with a group by clause?
2007-11-02 07:56 UTC hubert depesz lubaczewski <depesz@depesz.com>
` Re: select max(field) from table much faster with a group by clause?
2007-11-02 10:44 UTC Palle Girgensohn <girgen@pingpong.net>
[11+ messages in thread]
Re: [Fwd: Re: Outer joins and Seq scans]
2007-11-01 13:29 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [Fwd: Re: Outer joins and Seq scans]
2007-11-01 14:21 UTC Sami Dalouche <skoobi@free.fr>
[2+ messages in thread]
hardware and For PostgreSQL
2007-10-31 15:53 UTC Ketema Harris <ketema@ketema.net>
` Re: hardware and For PostgreSQL
2007-10-31 17:24 UTC Ben <bench@silentmedia.com>
` Re: hardware and For PostgreSQL
2007-10-31 18:19 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: hardware and For PostgreSQL
2007-10-31 18:54 UTC Joe Uhl <joeuhl@gmail.com>
` Re: hardware and For PostgreSQL
2007-10-31 22:01 UTC Ron St-Pierre <ron.pgsql@shaw.ca>
` Re: hardware and For PostgreSQL
2007-10-31 22:30 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: hardware and For PostgreSQL
2007-10-31 23:00 UTC Paul Lambert <paul.lambert@autoledgers.com.au>
` Re: hardware and For PostgreSQL
2007-11-01 06:57 UTC Magnus Hagander <magnus@hagander.net>
` Re: hardware and For PostgreSQL
2007-11-01 11:00 UTC Joe Uhl <joeuhl@gmail.com>
[9+ messages in thread]
[Fwd: Re: Outer joins and Seq scans]
2007-10-31 21:22 UTC Sami Dalouche <skoobi@free.fr>
` Re: [Fwd: Re: Outer joins and Seq scans]
2007-10-31 22:05 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
tables with 300+ partitions
2007-10-30 18:09 UTC Pablo Alcaraz <pabloa@laotraesquina.com.ar>
` Re: tables with 300+ partitions
2007-10-30 18:56 UTC Heikki Linnakangas <heikki@enterprisedb.com>
` Re: tables with 300+ partitions
2007-10-30 21:00 UTC Steven Flatt <steven.flatt@gmail.com>
` Re: tables with 300+ partitions
2007-10-31 15:27 UTC Pablo Alcaraz <pabloa@laotraesquina.com.ar>
` Re: tables with 300+ partitions
2007-10-31 17:03 UTC Steven Flatt <steven.flatt@gmail.com>
` Re: tables with 300+ partitions
2007-10-31 17:57 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: tables with 300+ partitions
2007-10-31 17:57 UTC Tomáš Vondra <tv@fuzzy.cz>
` Re: tables with 300+ partitions
2007-10-31 20:15 UTC Pablo Alcaraz <pabloa@laotraesquina.com.ar>
[8+ messages in thread]
Two fast queries get slow when combined
2007-10-30 20:48 UTC cluster <skrald@amossen.dk>
` Re: Two fast queries get slow when combined
2007-10-30 21:46 UTC Heikki Linnakangas <heikki@enterprisedb.com>
` Re: Two fast queries get slow when combined
2007-10-31 04:05 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Two fast queries get slow when combined
2007-10-31 09:37 UTC cluster <skrald@amossen.dk>
` Re: Two fast queries get slow when combined
2007-10-31 09:39 UTC cluster <skrald@amossen.dk>
[5+ messages in thread]
Optimizing PostgreSQL for Windows
2007-10-30 13:28 UTC Christian Rengstl <Christian.Rengstl@klinik.uni-regensburg.de>
` Re: Optimizing PostgreSQL for Windows
2007-10-30 14:21 UTC Marc Schablewski <ms@clickware.de>
` Re: Optimizing PostgreSQL for Windows
2007-10-30 15:13 UTC Dave Dutcher <dave@tridecap.com>
` Re: Optimizing PostgreSQL for Windows
2007-10-30 19:21 UTC Guillaume Lelarge <guillaume@lelarge.info>
` Re: Optimizing PostgreSQL for Windows
2007-10-31 08:43 UTC Christian Rengstl <Christian.Rengstl@klinik.uni-regensburg.de>
[5+ messages in thread]
Improving Query
2007-10-30 12:18 UTC Ketema <ketema@gmail.com>
` Re: Improving Query
2007-10-30 13:23 UTC Richard Huxton <dev@archonet.com>
` Re: Improving Query
2007-10-30 13:31 UTC Michael Glaesemann <grzm@seespotcode.net>
` Re: Improving Query
2007-10-30 13:42 UTC Ketema Harris <ketema@gmail.com>
` Re: Improving Query
2007-10-30 14:15 UTC Ketema Harris <ketema@gmail.com>
` Re: Improving Query
2007-10-30 15:39 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Improving Query
2007-10-30 16:41 UTC Ketema Harris <ketema@gmail.com>
[7+ messages in thread]
High Availability and Load Balancing
2007-10-30 08:20 UTC ruben@rentalia.com
Suggestions on an update query
2007-10-26 20:26 UTC Campbell, Lance <lance@uiuc.edu>
` Re: Suggestions on an update query
2007-10-26 20:31 UTC Campbell, Lance <lance@uiuc.edu>
` Re: Suggestions on an update query
2007-10-26 21:09 UTC Gregory Stark <stark@enterprisedb.com>
` Re: Suggestions on an update query
2007-10-26 21:15 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: Suggestions on an update query
2007-10-27 02:04 UTC Gregory Stark <stark@enterprisedb.com>
` Re: Suggestions on an update query
2007-10-27 02:31 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: Suggestions on an update query
2007-10-29 16:33 UTC Campbell, Lance <lance@uiuc.edu>
` Re: Suggestions on an update query
2007-10-30 05:19 UTC Scott Marlowe <scott.marlowe@gmail.com>
[8+ messages in thread]
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]
[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