pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Mainframe Linux + PostgreSQL
  2004-02-02 18:06 UTC  Josh Berkus <josh@agliodbs.com>

another query optimization question
  2004-01-30 18:00 UTC  David Teran <david.teran@cluster9.com>
` Re: another query optimization question
  2004-01-30 18:09 UTC  PC Drew <drewpc@ibsncentral.com>
` Re: another query optimization question
  2004-01-30 18:10 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: another query optimization question
  2004-01-30 18:20 UTC  David Teran <david.teran@cluster9.com>
` Re: another query optimization question
  2004-01-30 19:19 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: another query optimization question
  2004-01-30 20:25 UTC  Richard Huxton <dev@archonet.com>
` Re: another query optimization question
  2004-01-30 22:02 UTC  David Teran <david.teran@cluster9.com>
` Re: another query optimization question
  2004-01-30 22:40 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: another query optimization question
  2004-01-31 10:28 UTC  David Teran <david.teran@cluster9.com>
` Re: another query optimization question
  2004-01-31 15:45 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: another query optimization question
  2004-01-31 20:15 UTC  Marc G. Fournier <scrappy@postgresql.org>
` Re: another query optimization question
  2004-01-31 21:12 UTC  David Teran <david.teran@cluster9.com>
  [12+ messages in thread]

High Performance/High Reliability File system on SuSE64
  2004-01-23 16:43 UTC  Dave Thompson <dave@hub.org>
` Re: High Performance/High Reliability File system on SuSE64
  2004-01-23 16:51 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: High Performance/High Reliability File system on SuSE64
  2004-01-23 17:55 UTC  Andrew Sullivan <ajs@crankycanuck.ca>
` Re: High Performance/High Reliability File system on SuSE64
  2004-01-23 18:18 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: High Performance/High Reliability File system on SuSE64
  2004-01-23 19:01 UTC  Andrew Sullivan <ajs@crankycanuck.ca>
` Re: High Performance/High Reliability File system on SuSE64
  2004-01-23 19:05 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: High Performance/High Reliability File system on SuSE64
  2004-01-23 20:50 UTC  Andrew Sullivan <ajs@crankycanuck.ca>
` Re: High Performance/High Reliability File system on SuSE64
  2004-01-23 20:56 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: High Performance/High Reliability File system on SuSE64
  2004-01-23 21:39 UTC  Christopher Browne <cbbrowne@libertyrms.info>
` Re: High Performance/High Reliability File system on SuSE64
  2004-01-23 22:57 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: High Performance/High Reliability File system on SuSE64
  2004-01-23 23:30 UTC  Christopher Browne <cbbrowne@libertyrms.info>
` Re: High Performance/High Reliability File system on SuSE64
  2004-01-24 01:22 UTC  Christopher Weimann <cweimann@k12hq.com>
` Re: High Performance/High Reliability File system on SuSE64
  2004-01-24 01:26 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: High Performance/High Reliability File system on SuSE64
  2004-01-24 03:27 UTC  Mark Kirkwood <markir@paradise.net.nz>
` Re: High Performance/High Reliability File system on SuSE64
  2004-01-24 17:11 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: High Performance/High Reliability File system on SuSE64
  2004-01-24 17:31 UTC  Paul Ganainm <paulsnewsgroups@hotmail.com>
` Re: High Performance/High Reliability File system on SuSE64
  2004-01-24 20:15 UTC  Doug McNaught <doug@mcnaught.org>
` Re: High Performance/High Reliability File system on SuSE64
  2004-01-24 21:56 UTC  Mark Kirkwood <markir@paradise.net.nz>
` Re: High Performance/High Reliability File system on SuSE64
  2004-01-26 16:16 UTC  Greg Stark <gsstark@mit.edu>
` Re: High Performance/High Reliability File system on SuSE64
  2004-01-27 17:52 UTC  George Essig <george_essig@yahoo.com>
` Re: High Performance/High Reliability File system on
  2004-01-28 18:36 UTC  markw@osdl.org
` Re: High Performance/High Reliability File system on SuSE64
  2004-01-31 05:07 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: High Performance/High Reliability File system on SuSE64
  2004-01-31 18:40 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
  [23+ messages in thread]

Unique index and estimated rows.
  2004-01-30 09:15 UTC  Kari Lavikka <tuner@bdb.fi>
` Re: Unique index and estimated rows.
  2004-01-31 01:45 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Unique index and estimated rows.
  2004-01-31 08:52 UTC  Kari Lavikka <tuner@bdb.fi>
  [3+ messages in thread]

query optimization differs between view and explicit query
  2004-01-30 00:31 UTC  Reece Hart <reece@in-machina.com>
` Re: query optimization differs between view and explicit
  2004-01-30 00:52 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: query optimization differs between view and explicit
  2004-01-30 01:20 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: query optimization differs between view and explicit
  2004-01-30 05:26 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: query optimization differs between view and explicit
  2004-01-30 19:27 UTC  Reece Hart <reece@in-machina.com>
  [5+ messages in thread]

query optimization question
  2004-01-29 01:05 UTC  Jack Coates <jack@lyris.com>
` Re: query optimization question
  2004-01-29 02:04 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: query optimization question
  2004-01-29 17:23 UTC  Jack Coates <jack@lyris.com>
` Re: query optimization question
  2004-01-29 18:05 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: query optimization question
  2004-01-29 19:04 UTC  Jack Coates <jack@lyris.com>
` Re: query optimization question
  2004-01-29 19:31 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: query optimization question
  2004-01-29 21:23 UTC  Jack Coates <jack@lyris.com>
` Re: query optimization question
  2004-01-29 22:01 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: query optimization question
  2004-01-29 22:26 UTC  Jack Coates <jack@lyris.com>
` Re: query optimization question
  2004-01-30 07:19 UTC  Dennis Bjorklund <db@zigo.dhs.org>
` Re: query optimization question
  2004-01-30 07:23 UTC  Dennis Bjorklund <db@zigo.dhs.org>
` Re: query optimization question
  2004-01-30 10:00 UTC  Greg Stark <gsstark@mit.edu>
` Re: query optimization question
  2004-01-30 14:51 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: query optimization question
  2004-01-30 17:13 UTC  Jack Coates <jack@lyris.com>
  [14+ messages in thread]

Cost of indexscan
  2004-01-30 08:16 UTC  Kari Lavikka <tuner@bdb.fi>
` Re: Cost of indexscan
  2004-01-30 15:07 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

Re: limit 1 and functional indexes: SOLVED
  2004-01-30 09:06 UTC  Alexandra Birch <alexandra@trymedia.com>
` Re: limit 1 and functional indexes: SOLVED
  2004-01-30 09:56 UTC  Greg Stark <gsstark@mit.edu>
  [2+ messages in thread]

Re: Explain plan for 2 column index : timestamps and time zones
  2004-01-30 08:47 UTC  lnd@hnit.is

On the performance of views
  2004-01-26 15:19 UTC  Bill Moran <wmoran@potentialtech.com>
` Re: On the performance of views
  2004-01-26 15:29 UTC  Shridhar Daithankar <shridhar@frodo.hserus.net>
` Re: On the performance of views
  2004-01-26 16:43 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: On the performance of views
  2004-01-26 17:09 UTC  Josh Berkus <josh@agliodbs.com>
` Re: On the performance of views
  2004-01-26 17:17 UTC  Bill Moran <wmoran@potentialtech.com>
` Re: On the performance of views
  2004-01-27 19:39 UTC  Bill Moran <wmoran@potentialtech.com>
` Re: On the performance of views
  2004-01-27 20:07 UTC  Josh Berkus <josh@agliodbs.com>
` Re: On the performance of views
  2004-01-28 08:43 UTC  Shridhar Daithankar <shridhar@frodo.hserus.net>
` Re: On the performance of views
  2004-01-28 16:02 UTC  Bill Moran <wmoran@potentialtech.com>
` Re: On the performance of views
  2004-01-29 18:41 UTC  Josh Berkus <josh@agliodbs.com>
` Re: On the performance of views
  2004-01-29 19:12 UTC  Bill Moran <wmoran@potentialtech.com>
` Re: On the performance of views
  2004-01-30 07:03 UTC  Shridhar Daithankar <shridhar@frodo.hserus.net>
  [12+ messages in thread]

limit 1 and functional indexes
  2004-01-28 11:23 UTC  Alexandra Birch <alexandra@trymedia.com>
` Re: limit 1 and functional indexes
  2004-01-29 12:52 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: limit 1 and functional indexes
  2004-01-29 15:02 UTC  Alexandra Birch <alexandra@trymedia.com>
` Re: limit 1 and functional indexes
  2004-01-29 15:11 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: [SQL] limit 1 and functional indexes
  2004-01-29 15:43 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: limit 1 and functional indexes
  2004-01-30 06:07 UTC  Greg Stark <gsstark@mit.edu>
  [6+ messages in thread]

Re: [PERFORM] Set-Returning Functions WAS: On the performance of views
  2004-01-29 19:21 UTC  Josh Berkus <josh@agliodbs.com>
` Re: [PERFORM] Set-Returning Functions WAS: On the performance of
  2004-01-29 19:44 UTC  Bill Moran <wmoran@potentialtech.com>
` Re: [PERFORM] Set-Returning Functions WAS: On the performance of views
  2004-01-29 23:17 UTC  Josh Berkus <josh@agliodbs.com>
` Re: [PERFORM] Set-Returning Functions WAS: On the performance of
  2004-01-30 01:07 UTC  Bill Moran <wmoran@potentialtech.com>
  [4+ messages in thread]

Explain plan for 2 column index
  2004-01-29 19:29 UTC  lnd@hnit.is
` Re: Explain plan for 2 column index
  2004-01-29 21:37 UTC  Richard Huxton <dev@archonet.com>
` Re: Explain plan for 2 column index
  2004-01-29 22:07 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [3+ messages in thread]

Linux / Clariion
  2004-01-28 21:32 UTC  Cott Lang <cott@internetstaff.com>
` Re: Linux / Clariion
  2004-01-28 22:08 UTC  Nick Barr <nicky@chuckie.co.uk>
  [2+ messages in thread]

Optimization questions
  2004-01-28 19:49 UTC  Greg Spiegelberg <gspiegelberg@cranel.com>

postgres timeout.
  2004-01-28 10:11 UTC  Stef <svb@ucs.co.za>
` Re: postgres timeout.
  2004-01-28 10:12 UTC  Stef <svb@ucs.co.za>
` Re: [SQL] postgres timeout.
  2004-01-28 16:49 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [3+ messages in thread]

Re: postgres timeout. [SOLVED]
  2004-01-28 10:47 UTC  Stef <svb@ucs.co.za>

pl/pgSQL versus pl/Python
  2004-01-27 18:52 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: pl/pgSQL versus pl/Python
  2004-01-28 00:56 UTC  Joe Conway <mail@joeconway.com>
  [2+ messages in thread]

(partial?) indexes, LIKE and NULL
  2004-01-27 19:26 UTC  Marinos J. Yannikos <mjy@geizhals.at>
` Re: (partial?) indexes, LIKE and NULL
  2004-01-27 19:51 UTC  PC Drew <drewpc@ibsncentral.com>
` Re: (partial?) indexes, LIKE and NULL
  2004-01-27 22:46 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [3+ messages in thread]

Insert Times
  2004-01-26 21:00 UTC  PC Drew <drewpc@ibsncentral.com>
` Re: Insert Times
  2004-01-27 03:15 UTC  Brad Gawne <bgawne@bralar.on.ca>
` Re: Insert Times
  2004-01-27 07:38 UTC  Leeuw van der, Tim <tim.leeuwvander@nl.unisys.com>
` Re: Insert Times
  2004-01-27 14:06 UTC  PC Drew <drewpc@ibsncentral.com>
` Re: Insert Times
  2004-01-27 15:58 UTC  Alan Stange <stange@rentec.com>
  [5+ messages in thread]

help with dual indexing
  2004-01-23 18:58 UTC  Orion Henry <orion@trustcommerce.com>
` Re: help with dual indexing
  2004-01-24 01:08 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: help with dual indexing
  2004-01-26 20:53 UTC  Orion Henry <orion@trustcommerce.com>
  [3+ messages in thread]

Queries with timestamp II
  2004-01-26 14:12 UTC  Arnau <arnaulist@andromeiberica.com>
` Re: Queries with timestamp II
  2004-01-26 14:38 UTC  Shridhar Daithankar <shridhar@frodo.hserus.net>
` Re: Queries with timestamp II
  2004-01-26 15:01 UTC  Tomasz Myrta <jasiek@klaster.net>
  [3+ messages in thread]

query slows under load
  2004-01-24 01:34 UTC  Jenny Zhang <jenny@osdl.org>
` Re: query slows under load
  2004-01-25 21:14 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
  [2+ messages in thread]

Benchmarking PostgreSQL?
  2004-01-25 01:01 UTC  Ivan Voras <ivoras@geri.cc.fer.hr>
` Re: Benchmarking PostgreSQL?
  2004-01-25 02:55 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Benchmarking PostgreSQL?
  2004-01-25 12:23 UTC  Ivan Voras <ivoras@geri.cc.fer.hr>
  [3+ messages in thread]

Slow delete times??
  2004-01-24 00:38 UTC  Octavio Alvarez <alvarezp@alvarezp.ods.org>
` Re: Slow delete times??
  2004-01-24 00:55 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: Slow delete times??
  2004-01-24 01:44 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow delete times??
  2004-01-25 02:12 UTC  Octavio Alvarez <alvarezp@alvarezp.ods.org>
  [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