pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedOSX & 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