pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
OSX & Performance
  2005-08-26 18:58 UTC  Jeff Trout <threshar@torgo.978.org>
` Re: OSX & Performance
  2005-08-28 20:00 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: OSX & Performance
  2005-08-29 17:27 UTC  Jeff Trout <threshar@torgo.978.org>
` Re: OSX & Performance
  2005-08-29 17:57 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: OSX & Performance
  2005-08-30 14:04 UTC  Jeff Trout <threshar@torgo.978.org>
  [5+ messages in thread]

How to improve Postgres performance
  2005-08-30 04:35 UTC  Hemant Pandey <hemant.pandey@flextronicssoftware.com>
` Re: How to improve Postgres performance
  2005-08-30 06:04 UTC  Dennis Bjorklund <db@zigo.dhs.org>
  [2+ messages in thread]

Weird performance drop after VACUUM
  2005-08-26 22:04 UTC  Ümit Öztosun <umit@likyabilisim.com>
` Re: Weird performance drop after VACUUM
  2005-08-26 22:52 UTC  asif ali <asif_icrossing@yahoo.com>
` Re: Weird performance drop after VACUUM
  2005-08-26 23:13 UTC  Philip Hallstrom <postgresql@philip.pjkh.com>
` Re: Weird performance drop after VACUUM
  2005-08-26 23:26 UTC  Michael Fuhr <mike@fuhr.org>
` Re: Weird performance drop after VACUUM
  2005-08-26 23:31 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Weird performance drop after VACUUM
  2005-08-27 00:10 UTC  asif ali <asif_icrossing@yahoo.com>
` Re: Weird performance drop after VACUUM
  2005-08-27 01:41 UTC  Michael Fuhr <mike@fuhr.org>
` Re: Weird performance drop after VACUUM
  2005-08-27 09:31 UTC  Umit Oztosun <umit@likyabilisim.com>
` Re: Weird performance drop after VACUUM
  2005-08-27 10:19 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Weird performance drop after VACUUM
  2005-08-27 15:05 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Weird performance drop after VACUUM
  2005-08-27 15:26 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Weird performance drop after VACUUM
  2005-08-27 15:40 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Weird performance drop after VACUUM
  2005-08-29 18:07 UTC  asif ali <asif_icrossing@yahoo.com>
` Re: Weird performance drop after VACUUM
  2005-08-29 20:28 UTC  Michael Fuhr <mike@fuhr.org>
` Re: Weird performance drop after VACUUM
  2005-08-29 22:59 UTC  asif ali <asif_icrossing@yahoo.com>
  [15+ messages in thread]

Performance for relative large DB
  2005-08-23 12:14 UTC  tobbe <tobbe@tripnet.se>
` Re: Performance for relative large DB
  2005-08-23 15:12 UTC  Chris Browne <cbbrowne@acm.org>
` Re: Performance for relative large DB
  2005-08-24 06:25 UTC  tobbe <tobbe@tripnet.se>
` Re: Performance for relative large DB
  2005-08-24 16:34 UTC  Chris Browne <cbbrowne@acm.org>
` Re: Performance for relative large DB
  2005-08-27 06:30 UTC  Chris Travers <chris@travelamericas.com>
` Re: Performance for relative large DB
  2005-08-29 21:09 UTC  Jim C. Nasby <jnasby@pervasive.com>
  [6+ messages in thread]

getting an index to work with partial indices ...
  2005-08-29 19:56 UTC  Marc G. Fournier <scrappy@postgresql.org>
` Re: getting an index to work with partial indices ...
  2005-08-29 20:19 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

Limit + group + join
  2005-08-26 00:27 UTC  Tobias Brox <tobias@nordicbet.com>
` Re: Limit + group + join
  2005-08-26 01:56 UTC  Jeffrey W. Baker <jwbaker@acm.org>
` Re: Limit + group + join
  2005-08-26 02:06 UTC  Tobias Brox <tobias@nordicbet.com>
` Re: Limit + group + join
  2005-08-26 02:31 UTC  Jeffrey W. Baker <jwbaker@acm.org>
` Re: Limit + group + join
  2005-08-26 03:01 UTC  Mark Kirkwood <markir@paradise.net.nz>
` Re: Limit + group + join
  2005-08-26 06:20 UTC  Tobias Brox <tobias@nordicbet.com>
` Re: Limit + group + join
  2005-08-26 14:18 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: Limit + group + join
  2005-08-26 14:49 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: Limit + group + join
  2005-08-26 15:46 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Limit + group + join
  2005-08-26 23:29 UTC  Mark Kirkwood <markir@paradise.net.nz>
` Re: Limit + group + join
  2005-08-26 23:48 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Limit + group + join
  2005-08-27 02:55 UTC  Mark Kirkwood <markir@paradise.net.nz>
` Re: Limit + group + join
  2005-08-27 03:03 UTC  Greg Stark <gsstark@mit.edu>
` Re: Limit + group + join
  2005-08-27 22:17 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Limit + group + join
  2005-08-28 00:48 UTC  Mark Kirkwood <markir@paradise.net.nz>
` Re: Limit + group + join
  2005-08-28 01:42 UTC  Tobias Brox <tobias@nordicbet.com>
` Re: Limit + group + join
  2005-08-29 18:41 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
  [17+ messages in thread]

Bitmap scan when it is not needed
  2005-08-28 20:48 UTC  Ilia Kantor <ilia@obnovlenie.ru>
` Re: Bitmap scan when it is not needed
  2005-08-28 22:49 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

Planner improvement suggestion
  2005-08-28 20:59 UTC  Ilia Kantor <ilia@obnovlenie.ru>
` Re: Planner improvement suggestion
  2005-08-28 21:30 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

intarray is broken ? (8.1b1)
  2005-08-28 20:41 UTC  Ilia Kantor <ilia@obnovlenie.ru>
` Re: intarray is broken ? (8.1b1)
  2005-08-28 21:24 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

Inefficient queryplan for query with intersectable subselects/joins
  2005-08-26 11:08 UTC  Arjen van der Meijden <acmmailing@tweakers.net>
` Re: Inefficient queryplan for query with intersectable
  2005-08-26 13:05 UTC  Richard Huxton <dev@archonet.com>
` Re: Inefficient queryplan for query with intersectable
  2005-08-26 21:16 UTC  Arjen van der Meijden <acmmailing@tweakers.net>
` Re: Inefficient queryplan for query with intersectable
  2005-08-26 22:56 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Inefficient queryplan for query with intersectable
  2005-08-27 10:50 UTC  Arjen van der Meijden <acmmailing@tweakers.net>
` Re: Inefficient queryplan for query with intersectable
  2005-08-27 14:27 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Inefficient queryplan for query with intersectable
  2005-08-28 14:44 UTC  Arjen van der Meijden <acmmailing@tweakers.net>
  [7+ messages in thread]

Re: Inefficient queryplan for query with
  2005-08-27 15:07 UTC  Ron <rjpeace@earthlink.net>

Sending a select to multiple servers.
  2005-08-26 15:24 UTC  Ligesh <gxlists@gmail.com>
` Re: Sending a select to multiple servers.
  2005-08-26 16:04 UTC  Frank Wiles <frank@wiles.org>
` Re: Sending a select to multiple servers.
  2005-08-26 16:11 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: Sending a select to multiple servers.
  2005-08-26 22:45 UTC  Ligesh <gxlists@gmail.com>
` Re: Sending a select to multiple servers.
  2005-08-26 22:51 UTC  Ligesh <gxlists@gmail.com>
  [5+ messages in thread]

How does the planner execute unions?
  2005-08-26 20:14 UTC  Chris Hoover <revoohc@gmail.com>
` Re: How does the planner execute unions?
  2005-08-26 20:45 UTC  Bruno Wolff III <bruno@wolff.to>
  [2+ messages in thread]

difference in plan between 8.0 and 8.1?
  2005-08-26 14:45 UTC  Alan Stange <stange@rentec.com>
` Re: difference in plan between 8.0 and 8.1?
  2005-08-26 15:12 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: difference in plan between 8.0 and 8.1?
  2005-08-26 15:16 UTC  Michael Fuhr <mike@fuhr.org>
` Re: difference in plan between 8.0 and 8.1?
  2005-08-26 15:16 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: difference in plan between 8.0 and 8.1?
  2005-08-26 19:01 UTC  Alan Stange <stange@rentec.com>
  [5+ messages in thread]

Performance indexing of a simple query
  2005-08-24 20:43 UTC  Mark Fox <mark.fox@gmail.com>
` Re: Performance indexing of a simple query
  2005-08-24 21:22 UTC  Jim C. Nasby <jnasby@pervasive.com>
` Re: Performance indexing of a simple query
  2005-08-24 23:42 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance indexing of a simple query
  2005-08-26 16:28 UTC  Jim C. Nasby <jnasby@pervasive.com>
` Re: Performance indexing of a simple query
  2005-08-26 16:42 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [5+ messages in thread]

postmaster memory keep going up????
  2005-08-26 06:08 UTC  Chun Yit(Chronos) <ivanbeh@chronos.com.my>
` Re: postmaster memory keep going up????
  2005-08-26 08:34 UTC  Richard Huxton <dev@archonet.com>
  [2+ messages in thread]

Re: Read/Write block sizes
  2005-08-23 22:09 UTC  Chris Browne <cbbrowne@acm.org>
` Re: Read/Write block sizes
  2005-08-23 23:24 UTC  Michael Stone <mstone+postgres@mathom.us>
` Re: Read/Write block sizes
  2005-08-23 23:36 UTC  Jim C. Nasby <jnasby@pervasive.com>
` Re: Read/Write block sizes
  2005-08-24 01:25 UTC  Steve Poe <spoe@sfnet.cc>
` Re: Read/Write block sizes
  2005-08-24 02:22 UTC  Jignesh K. Shah <J.K.Shah@Sun.COM>
` Re: Read/Write block sizes
  2005-08-24 02:31 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Read/Write block sizes
  2005-08-24 03:07 UTC  Jeffrey W. Baker <jwbaker@acm.org>
` Re: Read/Write block sizes
  2005-08-24 04:00 UTC  Alan Stange <stange@rentec.com>
` Re: Read/Write block sizes
  2005-08-24 05:10 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Read/Write block sizes
  2005-08-24 05:20 UTC  Guy Thornley <guy@esphion.com>
` Re: Read/Write block sizes
  2005-08-24 05:25 UTC  Jeffrey W. Baker <jwbaker@acm.org>
` Re: Read/Write block sizes
  2005-08-24 05:56 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Read/Write block sizes
  2005-08-24 06:22 UTC  Jeffrey W. Baker <jwbaker@acm.org>
` Re: Read/Write block sizes
  2005-08-24 10:35 UTC  PFC <lists@boutiquenumerique.com>
` Re: Read/Write block sizes
  2005-08-24 13:52 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: Read/Write block sizes
  2005-08-24 16:12 UTC  Chris Browne <cbbrowne@acm.org>
` Re: Read/Write block sizes
  2005-08-24 16:26 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Read/Write block sizes
  2005-08-24 20:10 UTC  Lance Obermeyer <LObermey@pervasive.com>
` Re: Read/Write block sizes
  2005-08-24 20:20 UTC  Jignesh Shah <J.K.Shah@Sun.COM>
` Re: Read/Write block sizes
  2005-08-24 20:57 UTC  Jim C. Nasby <jnasby@pervasive.com>
` Re: Read/Write block sizes
  2005-08-25 19:45 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Read/Write block sizes
  2005-08-25 20:26 UTC  Ron <rjpeace@earthlink.net>
` Re: Read/Write block sizes
  2005-08-25 20:49 UTC  Chris Browne <cbbrowne@acm.org>
` Re: Read/Write block sizes
  2005-08-25 23:46 UTC  Ron <rjpeace@earthlink.net>
  [24+ messages in thread]

Re: What *_mem to increase when running CLUSTER
  2005-08-25 13:56 UTC  Steve Poe <spoe@sfnet.cc>
` What *_mem to increase when running CLUSTER
  2005-08-25 19:24 UTC  Andrew Lazarus <andrew@pillette.com>
` Re: What *_mem to increase when running CLUSTER
  2005-08-25 20:19 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [3+ messages in thread]

Caching by Postgres
  2005-08-23 17:10 UTC  gokulnathbabu manoharan <gokulnathbabu@yahoo.com>
` Re: Caching by Postgres
  2005-08-23 17:25 UTC  John A Meinel <john@arbash-meinel.com>
` Re: Caching by Postgres
  2005-08-23 17:41 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Caching by Postgres
  2005-08-23 17:43 UTC  Frank Wiles <frank@wiles.org>
` Re: Caching by Postgres
  2005-08-23 17:57 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Caching by Postgres
  2005-08-23 18:41 UTC  Donald Courtney <Donald.Courtney@Sun.COM>
` Re: Caching by Postgres
  2005-08-23 19:23 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Caching by Postgres
  2005-08-23 19:38 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Caching by Postgres
  2005-08-23 20:03 UTC  mark@mark.mielke.cc
` Re: Caching by Postgres
  2005-08-23 20:29 UTC  Michael Stone <mstone+postgres@mathom.us>
` Re: Caching by Postgres
  2005-08-23 20:41 UTC  Chris Browne <cbbrowne@acm.org>
` Re: Caching by Postgres
  2005-08-23 21:17 UTC  Chris Browne <cbbrowne@acm.org>
` Re: Caching by Postgres
  2005-08-23 21:59 UTC  William Yu <wyu@talisys.com>
` Re: Caching by Postgres
  2005-08-23 23:29 UTC  PFC <lists@boutiquenumerique.com>
` Re: Caching by Postgres
  2005-08-24 02:11 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Caching by Postgres
  2005-08-24 04:38 UTC  Gavin Sherry <swm@alcove.com.au>
` Re: Caching by Postgres
  2005-08-24 05:07 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Caching by Postgres
  2005-08-24 05:24 UTC  Gavin Sherry <swm@alcove.com.au>
` Re: Caching by Postgres
  2005-08-24 13:21 UTC  Donald Courtney <Donald.Courtney@Sun.COM>
` Re: Caching by Postgres
  2005-08-24 14:55 UTC  Stephen Frost <sfrost@snowman.net>
` Re: Caching by Postgres
  2005-08-24 15:36 UTC  PFC <lists@boutiquenumerique.com>
` Re: Caching by Postgres
  2005-08-24 17:30 UTC  mark@mark.mielke.cc
` Re: Caching by Postgres
  2005-08-24 18:47 UTC  Alan Stange <stange@rentec.com>
` Re: Caching by Postgres
  2005-08-24 18:54 UTC  William Yu <wyu@talisys.com>
` Re: Caching by Postgres
  2005-08-24 19:34 UTC  mark@mark.mielke.cc
` Re: Caching by Postgres
  2005-08-24 20:03 UTC  PFC <lists@boutiquenumerique.com>
` Re: Caching by Postgres
  2005-08-24 21:09 UTC  Alan Stange <stange@rentec.com>
` Re: Caching by Postgres
  2005-08-24 21:09 UTC  Michael Stone <mstone+postgres@mathom.us>
` Re: Caching by Postgres
  2005-08-25 00:13 UTC  mark@mark.mielke.cc
` Re: Caching by Postgres
  2005-08-25 00:21 UTC  mark@mark.mielke.cc
` Re: Caching by Postgres
  2005-08-25 13:23 UTC  Thomas Ganss <tganss_at_t_dash_online_dot_de-remove-all-after-first-real-dash@yahoo.com>
  [31+ messages in thread]

Some ideas for comment
  2005-08-24 16:56 UTC  Chris Hoover <revoohc@gmail.com>
` Re: Some ideas for comment
  2005-08-24 18:59 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: Some ideas for comment
  2005-08-24 19:51 UTC  Alvaro Herrera <alvherre@alvh.no-ip.org>
` Re: Some ideas for comment
  2005-08-24 20:00 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Some ideas for comment
  2005-08-24 20:26 UTC  Chris Hoover <revoohc@gmail.com>
` Re: Some ideas for comment
  2005-08-25 07:18 UTC  Jens-Wolfhard Schicke <ml+pgsql-performance@asco.de>
  [6+ messages in thread]

RAID arrays (and vendors)
  2005-08-25 00:17 UTC  Jim C. Nasby <jnasby@pervasive.com>

performance drop on RAID5
  2005-08-24 14:43 UTC  Alexandre Barros <alexandre@vectorx.com.br>
` Re: performance drop on RAID5
  2005-08-24 15:52 UTC  Frank Wiles <frank@wiles.org>
` Re: performance drop on RAID5
  2005-08-24 16:02 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: performance drop on RAID5
  2005-08-24 16:17 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: performance drop on RAID5
  2005-08-24 16:32 UTC  Arjen van der Meijden <acmmailing@tweakers.net>
` Re: performance drop on RAID5
  2005-08-24 16:35 UTC  Rosser Schwarz <rosser.schwarz@gmail.com>
  [6+ messages in thread]

Re: Read/Write block sizes (Was: Caching by Postgres)
  2005-08-23 21:29 UTC  Jignesh Shah <J.K.Shah@Sun.COM>
` Re: Read/Write block sizes (Was: Caching by Postgres)
  2005-08-23 23:12 UTC  Michael Stone <mstone+postgres@mathom.us>
` Re: Read/Write block sizes (Was: Caching by Postgres)
  2005-08-23 23:44 UTC  Jeffrey W. Baker <jwbaker@acm.org>
  [3+ messages in thread]

complex query performance assistance request
  2005-08-21 03:48 UTC  John Mendenhall <john@surfutopia.net>
` Re: complex query performance assistance request
  2005-08-22 18:21 UTC  John Mendenhall <john@surfutopia.net>
` Re: complex query performance assistance request
  2005-08-22 20:15 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: complex query performance assistance request
  2005-08-22 21:07 UTC  John Mendenhall <john@surfutopia.net>
` Re: complex query performance assistance request
  2005-08-23 00:54 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: complex query performance assistance request
  2005-08-23 19:05 UTC  John Mendenhall <john@surfutopia.net>
  [6+ messages in thread]

fake condition causes far better plan
  2005-08-23 14:50 UTC  Szűcs Gábor <surrano@gmail.com>
` Re: fake condition causes far better plan
  2005-08-23 15:14 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ 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