pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
slow rule on update
  2004-10-05 22:55 UTC  Janning Vygen <vygen@gmx.de>

would number of fields in a table affect search-query time?
  2004-10-04 23:27 UTC  Miles Keaton <mileskeaton@gmail.com>
` Re: would number of fields in a table affect search-query time?
  2004-10-04 23:32 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: would number of fields in a table affect search-query time?
  2004-10-04 23:34 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: would number of fields in a table affect search-query time?
  2004-10-05 02:06 UTC  Josh Berkus <josh@agliodbs.com>
  [4+ messages in thread]

Re: Performance suggestions for an update-mostly database?
  2004-10-04 17:38 UTC  Josh Berkus <josh@agliodbs.com>
` Performance suggestions for an update-mostly database?
  2004-10-04 17:40 UTC  Steve Atkins <steve@blighty.com>
` Re: Performance suggestions for an update-mostly database?
  2004-10-04 18:00 UTC  Steve Atkins <steve@blighty.com>
` Re: Performance suggestions for an update-mostly database?
  2004-10-04 19:02 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Performance suggestions for an update-mostly database?
  2004-10-04 19:22 UTC  Jim C. Nasby <decibel@decibel.org>
  [5+ messages in thread]

Slow update/insert process
  2004-10-01 18:14 UTC  Patrick Hatcher <PHatcher@macys.com>
` Re: Slow update/insert process
  2004-10-01 19:48 UTC  Aaron Werman <awerman2@hotmail.com>
` Re: Slow update/insert process
  2004-10-04 17:14 UTC  Patrick Hatcher <PHatcher@macys.com>
  [3+ messages in thread]

Query planner problem
  2004-10-01 22:06 UTC  Ryan VanMiddlesworth <ryan@vanmiddlesworth.org>
` Re: Query planner problem
  2004-10-02 22:50 UTC  Russell Smith <mr-russ@pws.com.au>
` Re: Query planner problem
  2004-10-02 23:21 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query planner problem
  2004-10-03 21:56 UTC  Greg Stark <gsstark@mit.edu>
  [4+ messages in thread]

index not used when using function
  2004-09-29 19:41 UTC  Shiar <postgres@shiar.org>
` Re: index not used when using function
  2004-10-03 15:29 UTC  Pierre-Frédéric Caillaud <lists@boutiquenumerique.com>
  [2+ messages in thread]

inconsistent/weird index usage
  2004-10-01 06:30 UTC  Dustin Sallings <dustin@spy.net>
` Re: inconsistent/weird index usage
  2004-10-01 13:53 UTC  John Meinel <john@johnmeinel.com>
` Re: inconsistent/weird index usage
  2004-10-01 14:38 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: inconsistent/weird index usage
  2004-10-01 14:43 UTC  Richard Huxton <dev@archonet.com>
` Re: inconsistent/weird index usage
  2004-10-01 16:29 UTC  Josh Berkus <josh@agliodbs.com>
` Re: inconsistent/weird index usage
  2004-10-01 16:34 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: inconsistent/weird index usage
  2004-10-02 23:20 UTC  Hannu Krosing <hannu@tm.ee>
` Re: inconsistent/weird index usage
  2004-10-02 23:44 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [8+ messages in thread]

Web server to Database Taking forever
  2004-09-30 14:46 UTC  Scott Dunn <sdunn@tsh.net>
` Re: Web server to Database Taking forever
  2004-09-30 16:39 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Web server to Database Taking forever
  2004-09-30 18:58 UTC  Scott Dunn <sdunn@tsh.net>
` Re: Web server to Database Taking forever
  2004-09-30 19:17 UTC  Edwin Eyan Moragas <haaktu@gmail.com>
` Re: Web server to Database Taking forever
  2004-09-30 20:19 UTC  Scott Marlowe <smarlowe@qwest.net>
  [5+ messages in thread]

O_DIRECT setting
  2004-09-20 07:57 UTC  Guy Thornley <guy@esphion.com>
` Re: O_DIRECT setting
  2004-09-23 03:58 UTC  Neil Conway <neilc@samurai.com>
` Re: O_DIRECT setting
  2004-09-23 13:35 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: O_DIRECT setting
  2004-09-23 14:57 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: O_DIRECT setting
  2004-09-24 15:07 UTC  Mark Wong <markw@osdl.org>
` Re: O_DIRECT setting
  2004-09-30 01:45 UTC  Mark Wong <markw@osdl.org>
` Re: O_DIRECT setting
  2004-09-30 03:03 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: O_DIRECT setting
  2004-09-30 07:02 UTC  Guy Thornley <guy@esphion.com>
` Re: O_DIRECT setting
  2004-09-30 16:33 UTC  Mark Wong <markw@osdl.org>
  [9+ messages in thread]

spurious function execution in prepared statements.
  2004-09-30 13:45 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: [HACKERS] spurious function execution in prepared statements.
  2004-09-30 14:13 UTC  Michael Adler <adler@pobox.com>
` Re: [HACKERS] spurious function execution in prepared statements.
  2004-09-30 14:19 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: spurious function execution in prepared statements.
  2004-09-30 14:45 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: [HACKERS] spurious function execution in prepared statements.
  2004-09-30 14:54 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: spurious function execution in prepared statements.
  2004-09-30 14:58 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: spurious function execution in prepared statements.
  2004-09-30 15:02 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [7+ messages in thread]

Interest in perf testing?
  2004-09-28 17:53 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Interest in perf testing?
  2004-09-29 14:44 UTC  Shea,Dan [CIS] <Dan.Shea@ec.gc.ca>
` Re: Interest in perf testing?
  2004-09-29 22:00 UTC  Gaetano Mendola <mendola@bigfoot.com>
  [3+ messages in thread]

stubborn query confuses two different servers
  2004-09-29 17:44 UTC  SZŰCS Gábor <surrano@mailbox.hu>

Re: [PERFORM] Poor Performance for large queries
  2004-09-29 08:40 UTC  Richard Huxton <dev@archonet.com>
` Re: [PERFORM] Poor Performance for large queries
  2004-09-29 14:56 UTC  John Meinel <john@johnmeinel.com>
` Re: [pgsql-hackers-win32] Poor Performance for large queries
  2004-09-29 16:44 UTC  John Meinel <john@johnmeinel.com>
  [3+ messages in thread]

Poor Performance for large queries in functions
  2004-09-29 03:14 UTC  John Meinel <john@johnmeinel.com>
` Re: Poor Performance for large queries in functions
  2004-09-29 05:10 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Poor Performance for large queries in functions
  2004-09-29 06:34 UTC  John Meinel <john@johnmeinel.com>
` Re: Poor Performance for large queries in functions
  2004-09-29 16:18 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [4+ messages in thread]

why does explain analyze differ so much from estimated explain?
  2004-09-29 15:55 UTC  Dirk Lutzebäck <lutzeb@aeccom.com>

This query is still running after 10 hours...
  2004-09-28 14:19 UTC  Robert Creager <Robert_Creager@LogicalChaos.org>
` Re: This query is still running after 10 hours...
  2004-09-28 14:28 UTC  Kevin Barnard <kevin.barnard@gmail.com>
` Re: This query is still running after 10 hours...
  2004-09-28 14:55 UTC  Gaetano Mendola <mendola@bigfoot.com>
` Re: This query is still running after 10 hours...
  2004-09-28 15:04 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: This query is still running after 10 hours...
  2004-09-29 02:21 UTC  Robert Creager <Robert_Creager@LogicalChaos.org>
` Re: This query is still running after 10 hours...
  2004-09-29 02:25 UTC  Robert Creager <Robert_Creager@LogicalChaos.org>
` Re: This query is still running after 10 hours...
  2004-09-29 02:41 UTC  Kevin Barnard <kevin.barnard@gmail.com>
` Re: This query is still running after 10 hours...
  2004-09-29 03:44 UTC  Robert Creager <Robert_Creager@LogicalChaos.org>
` Re: This query is still running after 10 hours...
  2004-09-29 03:51 UTC  Robert Creager <Robert_Creager@LogicalChaos.org>
` Re: This query is still running after 10 hours...
  2004-09-29 13:28 UTC  Steven Rosenstein <srosenst@us.ibm.com>
  [10+ messages in thread]

best statistic target for boolean columns
  2004-09-27 18:09 UTC  Gaetano Mendola <mendola@bigfoot.com>
` Re: best statistic target for boolean columns
  2004-09-27 18:31 UTC  Josh Berkus <josh@agliodbs.com>
` Re: best statistic target for boolean columns
  2004-09-27 19:13 UTC  Gregory Stark <gsstark@mit.edu>
` Re: best statistic target for boolean columns
  2004-09-27 19:26 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: best statistic target for boolean columns
  2004-09-27 20:41 UTC  Gaetano Mendola <mendola@bigfoot.com>
` Re: best statistic target for boolean columns
  2004-09-27 22:42 UTC  Gaetano Mendola <mendola@bigfoot.com>
` Re: best statistic target for boolean columns
  2004-09-27 23:43 UTC  Neil Conway <neilc@samurai.com>
` Re: best statistic target for boolean columns
  2004-09-28 00:16 UTC  Gaetano Mendola <mendola@bigfoot.com>
  [8+ messages in thread]

Performance/Functional Analysis Complete
  2004-09-27 08:50 UTC  Mark Cotner <mcotner@yahoo.com>

performance of PostgreSQL on 64 bit MAC OS X G5!
  2004-09-24 19:23 UTC  Qing Zhao <qzhao@supplyfx.com>
` Re: performance of PostgreSQL on 64 bit MAC OS X G5!
  2004-09-26 23:31 UTC  Christopher Browne <cbbrowne@acm.org>
  [2+ messages in thread]

SAN performance
  2004-09-22 21:49 UTC  Anjan Dave <adave@vantage.com>
` Re: SAN performance
  2004-09-23 15:39 UTC  Mr Pink <mr_pink_is_the_only_pro@yahoo.com>
` Re: SAN performance
  2004-09-23 18:05 UTC  Anjan Dave <adave@vantage.com>
` Re: SAN performance
  2004-09-26 20:37 UTC  Andrew Hammond <ahammond@ca.afilias.info>
  [4+ messages in thread]

Cleaning up indexes
  2004-09-23 22:16 UTC  Martin Foster <martin@ethereal-realms.org>
` Re: Cleaning up indexes
  2004-09-23 23:05 UTC  Gregory S. Williamson <gsw@globexplorer.com>
` Re: Cleaning up indexes
  2004-09-26 01:28 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
  [3+ messages in thread]

automated builds?
  2004-09-25 19:39 UTC  Andrew Dunstan <andrew@dunslane.net>

Re: Caching of Queries (now with pgpool)
  2004-09-24 01:23 UTC  Jason Coene <jcoene@gotfrag.com>
` Re: Caching of Queries (now with pgpool)
  2004-09-24 02:00 UTC  Michael Adler <adler@pobox.com>
` Re: Caching of Queries (now with pgpool)
  2004-09-25 17:25 UTC  Gaetano Mendola <mendola@bigfoot.com>
  [3+ messages in thread]

Getting rid of nested loop
  2004-09-25 00:57 UTC  Rod Taylor <pg@rbt.ca>

Large # of rows in query extremely slow, not using index
  2004-09-14 00:51 UTC  Stephen Crowley <stephen.crowley@gmail.com>
` Re: Large # of rows in query extremely slow, not using index
  2004-09-14 01:11 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Large # of rows in query extremely slow, not using
  2004-09-14 01:11 UTC  Rod Taylor <rbt@rbt.ca>
` Re: Large # of rows in query extremely slow, not using index
  2004-09-14 01:22 UTC  Stephen Crowley <stephen.crowley@gmail.com>
` Re: Large # of rows in query extremely slow, not using index
  2004-09-14 01:49 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Large # of rows in query extremely slow, not using index
  2004-09-14 06:04 UTC  Stephen Crowley <stephen.crowley@gmail.com>
` Re: Large # of rows in query extremely slow, not using
  2004-09-14 16:43 UTC  Markus Schaber <schabios@logi-track.com>
` Re: Large # of rows in query extremely slow, not using
  2004-09-14 19:27 UTC  Pierre-Frédéric Caillaud <lists@boutiquenumerique.com>
` Re: Large # of rows in query extremely slow, not using
  2004-09-17 01:51 UTC  Stephen Crowley <stephen.crowley@gmail.com>
` Re: Large # of rows in query extremely slow, not using
  2004-09-17 03:14 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: Large # of rows in query extremely slow, not using
  2004-09-17 17:40 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Large # of rows in query extremely slow, not using
  2004-09-17 20:44 UTC  Manfred Koizar <mkoi-pg@aon.at>
` Re: Large # of rows in query extremely slow, not using
  2004-09-18 00:23 UTC  Stephen Crowley <stephen.crowley@gmail.com>
` Re: Large # of rows in query extremely slow, not using
  2004-09-20 07:31 UTC  Manfred Koizar <mkoi-pg@aon.at>
` Re: Large # of rows in query extremely slow, not using
  2004-09-23 23:22 UTC  Kris Jurka <books@ejurka.com>
` Re: Large # of rows in query extremely slow, not using index
  2004-09-23 23:36 UTC  Stephen Crowley <stephen.crowley@gmail.com>
` Re: Large # of rows in query extremely slow, not using
  2004-09-23 23:47 UTC  Kris Jurka <books@ejurka.com>
  [17+ 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