pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
start up cost estimate
  2006-11-18 09:33 UTC  rakesh kumar <trakeshkumar@gmail.com>
` Re: start up cost estimate
  2006-11-18 14:27 UTC  Joshua Marsh <icub3d@gmail.com>
` Re: start up cost estimate
  2006-11-18 18:11 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Fwd: start up cost estimate
  2006-11-19 04:05 UTC  rakesh kumar <trakeshkumar@gmail.com>
  [4+ messages in thread]

Re: Optimicing Postgres for SunSolaris10 on V240
  2006-11-17 18:44 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Optimicing Postgres for SunSolaris10 on V240
  2006-11-18 09:08 UTC  Marc Cousin <cousinmarc@free.fr>
  [2+ messages in thread]

Re: [PERFORM] BUG #2737: hash indexing large tablefails, while btree of same index works
  2006-11-17 10:59 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: [PERFORM] BUG #2737: hash indexing large tablefails, while btree of same index works
  2006-11-17 14:26 UTC  Kenneth Marshall <ktm@it.is.rice.edu>
` Re: [PERFORM] BUG #2737: hash indexing large tablefails, while btree of same index works
  2006-11-17 15:08 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] BUG #2737: hash indexing large tablefails,while
  2006-11-17 15:36 UTC  Julius.Stroffek <Julius.Stroffek@Sun.COM>
  [4+ messages in thread]

Re: [PERFORM] BUG #2737: hash indexing largetablefails, while btree of same index works
  2006-11-17 14:38 UTC  Simon Riggs <simon@2ndquadrant.com>

Keeping processes open for re-use
  2006-11-09 12:35 UTC  Hilary Forbes <hforbes@dmr.co.uk>
` Re: Keeping processes open for re-use
  2006-11-09 12:56 UTC  Csaba Nagy <nagy@ecircle-ag.com>
` Re: Keeping processes open for re-use
  2006-11-09 17:55 UTC  imad <immaad@gmail.com>
` Re: Keeping processes open for re-use
  2006-11-10 02:09 UTC  Shane Ambler <pgsql@007Marketing.com>
` Re: Keeping processes open for re-use
  2006-11-10 02:19 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: Keeping processes open for re-use
  2006-11-16 17:39 UTC  Jean-Max Reymond <jmreymond@gmail.com>
` Re: Keeping processes open for re-use
  2006-11-17 11:20 UTC  Richard Huxton <dev@archonet.com>
  [7+ messages in thread]

BUG #2737: hash indexing large table fails, while btree of same index works
  2006-11-05 13:47 UTC  Balazs Nagy <bnagy@thenewpush.com>
` Re: BUG #2737: hash indexing large table fails, while btree of same index works
  2006-11-10 23:55 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] BUG #2737: hash indexing large table fails, while btree of same index works
  2006-11-11 08:17 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: [PERFORM] BUG #2737: hash indexing large table fails, while btree of same index works
  2006-11-16 22:48 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [4+ messages in thread]

Context switch storm
  2006-11-03 10:32 UTC  creimer@brturbo.com.br
` Re: Context switch storm
  2006-11-03 12:50 UTC  Gregory S. Williamson <gsw@globexplorer.com>
` Re: Context switch storm
  2006-11-03 12:52 UTC  Richard Huxton <dev@archonet.com>
` Re: Context switch storm
  2006-11-03 13:06 UTC  Cosimo Streppone <cosimo@streppone.it>
` Re: Context switch storm
  2006-11-03 13:28 UTC  creimer@brturbo.com.br
` Re: Context switch storm
  2006-11-03 13:29 UTC  Richard Huxton <dev@archonet.com>
` Re: Context switch storm
  2006-11-03 13:53 UTC  Andreas Kostyrka <andreas@kostyrka.org>
` Re: Context switch storm
  2006-11-03 14:05 UTC  Richard Huxton <dev@archonet.com>
` Re: Context switch storm
  2006-11-03 14:10 UTC  Richard Troy <rtroy@ScienceTools.com>
` Re: Context switch storm
  2006-11-03 14:38 UTC  Richard Huxton <dev@archonet.com>
` Re: Context switch storm
  2006-11-03 15:25 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Context switch storm
  2006-11-03 16:16 UTC  Andreas Kostyrka <andreas@kostyrka.org>
` Re: Context switch storm
  2006-11-06 21:33 UTC  Cosimo Streppone <cosimo@streppone.it>
` Re: Context switch storm
  2006-11-14 09:51 UTC  Cosimo Streppone <cosimo@streppone.it>
` Re: Context switch storm
  2006-11-14 10:13 UTC  Andreas Kostyrka <andreas@kostyrka.org>
` Re: Context switch storm
  2006-11-14 14:17 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: Context switch storm
  2006-11-14 16:50 UTC  Jim C. Nasby <jim@nasby.net>
` Re: Context switch storm
  2006-11-14 17:53 UTC  Bucky Jordan <bjordan@lumeta.com>
` Re: Context switch storm
  2006-11-14 20:11 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: Context switch storm
  2006-11-14 21:43 UTC  Cosimo Streppone <cosimo@streppone.it>
` Re: Context switch storm
  2006-11-15 09:07 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: Context switch storm
  2006-11-16 21:01 UTC  Jim Nasby <jim@nasby.net>
  [22+ messages in thread]

Slow SELECT on three or more clients
  2006-11-15 11:37 UTC  AMIR FRANCO D. JOVEN <amir@digi.ph>
` Re: Slow SELECT on three or more clients
  2006-11-15 13:29 UTC  Andreas Kostyrka <andreas@kostyrka.org>
` Re: Slow SELECT on three or more clients
  2006-11-15 13:31 UTC  Russell Smith <mr-russ@pws.com.au>
` Re: Slow SELECT on three or more clients
  2006-11-15 14:01 UTC  Gregory S. Williamson <gsw@globexplorer.com>
` Re: Slow SELECT on three or more clients
  2006-11-15 14:17 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: Slow SELECT on three or more clients
  2006-11-15 14:47 UTC  Markus Schaber <schabi@logix-tt.com>
` Re: Slow SELECT on three or more clients
  2006-11-16 08:47 UTC  AMIR FRANCO D. JOVEN <amir@digi.ph>
  [7+ messages in thread]

Hundreds of database and FSM
  2006-11-15 16:31 UTC  Craig A. James <cjames@modgraph-usa.com>
` Re: Hundreds of database and FSM
  2006-11-15 17:31 UTC  Alvaro Herrera <alvherre@commandprompt.com>
` Re: Hundreds of database and FSM
  2006-11-15 17:42 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
  [3+ messages in thread]

10x rowcount mis-estimation favouring merge over nestloop
  2006-11-10 05:12 UTC  Abhijit Menon-Sen <ams@oryx.com>
` Re: 10x rowcount mis-estimation favouring merge over nestloop
  2006-11-10 06:15 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: 10x rowcount mis-estimation favouring merge over nestloop
  2006-11-10 07:07 UTC  Abhijit Menon-Sen <ams@oryx.com>
  [3+ messages in thread]

Easy read-heavy benchmark kicking around?
  2006-11-06 20:47 UTC  Brian Hurt <bhurt@janestcapital.com>
` Re: Easy read-heavy benchmark kicking around?
  2006-11-06 20:53 UTC  Luke Lonergan <LLonergan@greenplum.com>
` Re: Easy read-heavy benchmark kicking around?
  2006-11-06 21:09 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: Easy read-heavy benchmark kicking around?
  2006-11-06 21:26 UTC  Scott Marlowe <smarlowe@g2switchworks.com>
` Re: Easy read-heavy benchmark kicking around?
  2006-11-07 01:52 UTC  Mark Kirkwood <markir@paradise.net.nz>
` Re: Easy read-heavy benchmark kicking around?
  2006-11-07 10:49 UTC  Dimitri Fontaine <dim@dalibo.com>
` Re: Easy read-heavy benchmark kicking around?
  2006-11-08 16:18 UTC  Markus Schaber <schabi@logix-tt.com>
` Re: Easy read-heavy benchmark kicking around?
  2006-11-08 16:34 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: Easy read-heavy benchmark kicking around?
  2006-11-08 16:57 UTC  Cosimo Streppone <cosimo@streppone.it>
` Re: Easy read-heavy benchmark kicking around?
  2006-11-08 19:32 UTC  Luke Lonergan <llonergan@greenplum.com>
` Re: Easy read-heavy benchmark kicking around?
  2006-11-09 17:28 UTC  Merlin Moncure <mmoncure@gmail.com>
  [11+ messages in thread]

Re: Which OS provides the _fastest_ PostgreSQL performance?
  2006-11-08 17:14 UTC  Ron Mayer <rm_pg@cheapcomplexdevices.com>

Context switching
  2006-11-01 05:23 UTC  Carlos H. Reimer <carlos.reimer@opendb.com.br>
` Re: Context switching
  2006-11-07 17:42 UTC  Josh Berkus <josh@agliodbs.com>
  [2+ messages in thread]

Help w/speeding up range queries?
  2006-10-31 23:18 UTC  John Major <major@cbio.mskcc.org>
` Re: Help w/speeding up range queries?
  2006-10-31 23:54 UTC  Luke Lonergan <llonergan@greenplum.com>
` Re: Help w/speeding up range queries?
  2006-10-31 23:57 UTC  Weslee Bilodeau <weslee.bilodeau@hypermediasystems.com>
` Re: Help w/speeding up range queries?
  2006-11-01 00:10 UTC  Luke Lonergan <llonergan@greenplum.com>
` Re: Help w/speeding up range queries?
  2006-11-01 04:29 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Help w/speeding up range queries?
  2006-11-01 05:26 UTC  Luke Lonergan <llonergan@greenplum.com>
` Re: Help w/speeding up range queries?
  2006-11-01 05:58 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Help w/speeding up range queries?
  2006-11-02 10:54 UTC  Marcin Mank <marcin.mank@gmail.com>
` Re: Help w/speeding up range queries?
  2006-11-02 10:59 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: Help w/speeding up range queries?
  2006-11-07 01:37 UTC  Jim Nasby <jim@nasby.net>
  [10+ messages in thread]

Yet another question on LIMIT performance :/
  2006-11-06 14:13 UTC  Hannes Dorbath <light@theendofthetunnel.de>
` Re: Yet another question on LIMIT performance :/
  2006-11-06 14:13 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
` Re: Yet another question on LIMIT performance :/
  2006-11-06 14:21 UTC  Hannes Dorbath <light@theendofthetunnel.de>
` Re: Yet another question on LIMIT performance :/
  2006-11-06 14:33 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [4+ messages in thread]

Setting "nice" values
  2006-11-02 15:14 UTC  Madison Kelly <linux@alteeve.com>
` Re: Setting "nice" values
  2006-11-02 15:20 UTC  Scott Marlowe <smarlowe@g2switchworks.com>
` Re: Setting "nice" values
  2006-11-02 15:25 UTC  Madison Kelly <linux@alteeve.com>
` Re: Setting "nice" values
  2006-11-02 15:41 UTC  Scott Marlowe <smarlowe@g2switchworks.com>
` Re: Setting "nice" values
  2006-11-02 16:00 UTC  Tobias Brox <tobias@nordicbet.com>
` Re: Setting "nice" values
  2006-11-03 13:34 UTC  Andreas Kostyrka <andreas@kostyrka.org>
` Re: Setting "nice" values
  2006-11-06 04:27 UTC  Jim Nasby <decibel@decibel.org>
` Re: Setting "nice" values
  2006-11-06 13:10 UTC  Madison Kelly <linux@alteeve.com>
` Re: Setting "nice" values
  2006-11-06 13:12 UTC  Madison Kelly <linux@alteeve.com>
` Re: Setting "nice" values
  2006-11-06 13:13 UTC  Madison Kelly <linux@alteeve.com>
` Re: Setting "nice" values
  2006-11-06 13:33 UTC  Tobias Brox <tobias@nordicbet.com>
` Re: Setting "nice" values
  2006-11-06 13:48 UTC  Madison Kelly <linux@alteeve.com>
` Re: Setting "nice" values
  2006-11-06 14:11 UTC  Tobias Brox <tobias@nordicbet.com>
` Re: Setting "nice" values
  2006-11-06 14:18 UTC  Madison Kelly <linux@alteeve.com>
  [14+ messages in thread]

Slow functional indexes?
  2006-10-20 07:10 UTC  Stuart Bishop <stuart.bishop@canonical.com>
` Re: Slow functional indexes?
  2006-10-21 02:39 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: Slow functional indexes?
  2006-10-21 03:30 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow functional indexes?
  2006-10-24 07:00 UTC  Stuart Bishop <stuart@stuartbishop.net>
` Re: Slow functional indexes?
  2006-11-05 20:34 UTC  Stuart Bishop <stuart@stuartbishop.net>
` Re: Slow functional indexes?
  2006-11-06 01:23 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow functional indexes?
  2006-11-06 01:33 UTC  Gene <genekhart@gmail.com>
  [7+ messages in thread]

profiling PL/pgSQL?
  2006-11-03 11:12 UTC  Drew Wilson <drewmwilson@gmail.com>
` Re: profiling PL/pgSQL?
  2006-11-03 11:21 UTC  A. Kretschmer <andreas.kretschmer@schollglas.com>
` Re: profiling PL/pgSQL?
  2006-11-03 12:07 UTC  Richard Huxton <dev@archonet.com>
` Re: profiling PL/pgSQL?
  2006-11-03 15:27 UTC  Jonah H. Harris <jonah.harris@gmail.com>
` Re: profiling PL/pgSQL?
  2006-11-03 19:40 UTC  korryd@enterprisedb.com
  [5+ messages in thread]

Query plan for "heavy" SELECT with "lite" sub-SELECTs
  2006-11-02 11:07 UTC  Nikolay Samokhvalov <samokhvalov@gmail.com>
` Re: Query plan for "heavy" SELECT with "lite" sub-SELECTs
  2006-11-02 12:40 UTC  Richard Huxton <dev@archonet.com>
` Re: Query plan for "heavy" SELECT with "lite" sub-SELECTs
  2006-11-02 14:25 UTC  Dave Dutcher <dave@tridecap.com>
` Re: Query plan for "heavy" SELECT with "lite" sub-SELECTs
  2006-11-02 19:15 UTC  Alvaro Herrera <alvherre@commandprompt.com>
` Re: Query plan for "heavy" SELECT with "lite" sub-SELECTs
  2006-11-03 09:39 UTC  Arjen van der Meijden <acmmailing@tweakers.net>
` Re: Query plan for "heavy" SELECT with "lite" sub-SELECTs
  2006-11-03 14:50 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [6+ messages in thread]

Locking vs. Exceptions
  2006-11-02 12:45 UTC  Robins <tharakan@gmail.com>
` Re: Locking vs. Exceptions
  2006-11-02 23:17 UTC  Benjamin Minshall <minshall@intellicon.biz>
  [2+ messages in thread]

VACUUMs take twice as long across all nodes
  2006-10-26 08:58 UTC  Gavin Hamill <gdh@laterooms.com>
` Re: VACUUMs take twice as long across all nodes
  2006-10-26 14:47 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: VACUUMs take twice as long across all nodes
  2006-10-26 15:06 UTC  Gavin Hamill <gdh@laterooms.com>
` Re: VACUUMs take twice as long across all nodes
  2006-10-26 19:17 UTC  Jim C. Nasby <jim@nasby.net>
` Re: VACUUMs take twice as long across all nodes
  2006-10-26 20:35 UTC  Gavin Hamill <gdh@laterooms.com>
` Re: VACUUMs take twice as long across all nodes
  2006-10-26 21:59 UTC  Jim C. Nasby <jim@nasby.net>
` Re: VACUUMs take twice as long across all nodes
  2006-10-26 22:09 UTC  Andrew Sullivan <ajs@crankycanuck.ca>
` Re: VACUUMs take twice as long across all nodes
  2006-10-27 09:20 UTC  Gavin Hamill <gdh@laterooms.com>
` Re: VACUUMs take twice as long across all nodes
  2006-10-27 18:07 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: VACUUMs take twice as long across all nodes
  2006-10-27 22:19 UTC  Gavin Hamill <gdh@laterooms.com>
` Re: VACUUMs take twice as long across all nodes
  2006-10-29 14:58 UTC  Andrew Sullivan <ajs@crankycanuck.ca>
` Re: VACUUMs take twice as long across all nodes
  2006-10-29 15:08 UTC  Gavin Hamill <gdh@laterooms.com>
` Re: VACUUMs take twice as long across all nodes
  2006-10-29 15:34 UTC  Andrew Sullivan <ajs@crankycanuck.ca>
` Re: VACUUMs take twice as long across all nodes
  2006-10-29 16:24 UTC  Andreas Kostyrka <andreas@kostyrka.org>
` Re: VACUUMs take twice as long across all nodes
  2006-10-29 16:43 UTC  Andrew Sullivan <ajs@crankycanuck.ca>
` Re: VACUUMs take twice as long across all nodes
  2006-10-29 17:12 UTC  Andreas Kostyrka <andreas@kostyrka.org>
` Re: VACUUMs take twice as long across all nodes
  2006-11-02 21:41 UTC  Vivek Khera <vivek@khera.org>
  [17+ messages in thread]

Database-wide vacuum can take a long time, during which tables are not being analyzed
  2006-11-01 19:15 UTC  Steven Flatt <steven.flatt@gmail.com>
` Re: Database-wide vacuum can take a long time, during which
  2006-11-01 21:56 UTC  Matthew O'Connor <matthew@zeut.net>
` Re: Database-wide vacuum can take a long time, duringwhich tables are not being analyzed
  2006-11-02 10:49 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: Database-wide vacuum can take a long time, duringwhich tables are not being analyzed
  2006-11-02 15:15 UTC  Steven Flatt <steven.flatt@gmail.com>
` Re: Database-wide vacuum can take a long time, duringwhich tables are not being analyzed
  2006-11-02 15:53 UTC  Alvaro Herrera <alvherre@commandprompt.com>
  [5+ messages in thread]

big transaction slows down over time - but disk seems almost unused
  2006-11-01 05:58 UTC  Ben <bench@silentmedia.com>
` Re: big transaction slows down over time - but disk
  2006-11-01 09:21 UTC  Andreas Kostyrka <andreas@kostyrka.org>
` Re: big transaction slows down over time - but disk seems
  2006-11-01 09:39 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
` Re: big transaction slows down over time - but disk seems almost unused
  2006-11-01 15:49 UTC  Ben <bench@silentmedia.com>
` Re: big transaction slows down over time - but disk seems almost unused
  2006-11-01 15:56 UTC  Ben <bench@silentmedia.com>
` Re: big transaction slows down over time - but disk seems
  2006-11-01 16:34 UTC  Richard Huxton <dev@archonet.com>
` Re: big transaction slows down over time - but disk seems
  2006-11-01 16:51 UTC  Ben <bench@silentmedia.com>
` Re: big transaction slows down over time - but disk seems
  2006-11-01 17:15 UTC  Richard Huxton <dev@archonet.com>
  [8+ messages in thread]

MVCC & indexes?
  2006-10-31 21:55 UTC  Ivan Voras <ivoras@fer.hr>
` Re: MVCC & indexes?
  2006-10-31 22:36 UTC  Alvaro Herrera <alvherre@commandprompt.com>
` Re: MVCC & indexes?
  2006-11-01 00:20 UTC  mark@mark.mielke.cc
` Re: MVCC & indexes?
  2006-11-01 12:06 UTC  Ivan Voras <ivoras@fer.hr>
  [4+ messages in thread]

pg_trgm indexes giving bad estimations?
  2006-10-05 01:35 UTC  Ben <bench@silentmedia.com>
` Re: pg_trgm indexes giving bad estimations?
  2006-10-05 01:54 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: pg_trgm indexes giving bad estimations?
  2006-11-01 05:41 UTC  Ben <bench@silentmedia.com>
` Re: pg_trgm indexes giving bad estimations?
  2006-11-01 06:01 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [4+ 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