pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedCPU Usage
2007-02-13 18:36 UTC Campbell, Lance <lance@uiuc.edu>
` Re: CPU Usage
2007-02-13 18:48 UTC Alan Hodgson <ahodgson@simkin.ca>
[2+ messages in thread]
many instances or many databases or many users?
2007-02-13 08:55 UTC ismo.tuononen@solenovo.fi
` Re: many instances or many databases or many users?
2007-02-13 10:07 UTC Heikki Linnakangas <heikki@enterprisedb.com>
[2+ messages in thread]
limit + order by is slow if no rows in result set
2007-02-12 21:36 UTC Brian Cox <brian.cox@ca.com>
` Re: limit + order by is slow if no rows in result set
2007-02-12 23:26 UTC Heikki Linnakangas <heikki@enterprisedb.com>
` Re: limit + order by is slow if no rows in result set
2007-02-13 00:24 UTC Brian Cox <brian.cox@ca.com>
` Re: limit + order by is slow if no rows in result set
2007-02-13 03:36 UTC Tom Lane <tgl@sss.pgh.pa.us>
[4+ messages in thread]
Is there an equivalent for Oracle's user_tables.num_rows
2007-02-10 00:00 UTC Virag Saksena <virag@auptyma.com>
` Re: Is there an equivalent for Oracle's user_tables.num_rows
2007-02-10 00:45 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Is there an equivalent for Oracle's user_tables.num_rows
2007-02-10 01:08 UTC Virag Saksena <virag@auptyma.com>
[3+ messages in thread]
Re: Is there an equivalent for Oracle'suser_tables.num_rows
2007-02-10 01:06 UTC Simon Riggs <simon@2ndquadrant.com>
Re: Can anyone make this code tighter? Too slow, Please help!
2007-02-09 21:04 UTC Mark Stosberg <mark@summersault.com>
Recreate big table
2007-02-09 18:24 UTC Gábriel Ákos <akos.gabriel@i-logic.hu>
` Re: Recreate big table
2007-02-09 19:10 UTC Daniel Cristian Cruz <danielcristian@gmail.com>
[2+ messages in thread]
Disk saturation
2007-02-08 17:19 UTC Carlos H. Reimer <carlos.reimer@opendb.com.br>
Re: Speed up this query
2007-02-08 17:11 UTC Mark Stosberg <mark@summersault.com>
tip: faster sorting for proximity queries by using cube_distance()
2007-02-07 21:30 UTC Mark Stosberg <mark@summersault.com>
Help Needed
2007-02-07 14:15 UTC Muruganantham M <msgtoanand@gmail.com>
` Re: Help Needed
2007-02-07 15:03 UTC Richard Huxton <dev@archonet.com>
[2+ messages in thread]
index scan through a subquery
2007-02-02 01:44 UTC Bill Howe <howew@stccmop.org>
` Re: index scan through a subquery
2007-02-06 06:52 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: index scan through a subquery
2007-02-06 19:18 UTC Bill Howe <howew@stccmop.org>
[3+ messages in thread]
Re: explain analyze output for review (was: optimizing a geo_distance()...)
2007-02-06 14:39 UTC Mark Stosberg <mark@summersault.com>
` Re: explain analyze output for review (was: optimizing a geo_distance()...)
2007-02-06 14:50 UTC Hiltibidal, Robert <Robert.Hiltibidal@argushealth.com>
` Re: explain analyze output for review (was: optimizing a geo_distance()...)
2007-02-06 14:53 UTC Adam Rich <adam.r@sbcglobal.net>
` Re: explain analyze output for review (was: optimizing a geo_distance()...)
2007-02-06 15:04 UTC Hiltibidal, Robert <Robert.Hiltibidal@argushealth.com>
` Re: explain analyze output for review (was: optimizing a geo_distance()...)
2007-02-06 15:45 UTC Bruno Wolff III <bruno@wolff.to>
[5+ messages in thread]
Re: explain analyze output: vacuuming made a big difference.
2007-02-06 14:54 UTC Mark Stosberg <mark@summersault.com>
optimizing a geo_distance() proximity query
2007-02-03 19:00 UTC Mark Stosberg <mark@summersault.com>
` Re: optimizing a geo_distance() proximity query
2007-02-03 19:11 UTC Oleg Bartunov <oleg@sai.msu.su>
` Re: optimizing a geo_distance() proximity query
2007-02-04 05:16 UTC Bruno Wolff III <bruno@wolff.to>
` Re: optimizing a geo_distance() proximity query
2007-02-05 19:47 UTC Mark Stosberg <mark@summersault.com>
` Re: optimizing a geo_distance() proximity query
2007-02-05 20:15 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: optimizing a geo_distance() proximity query
2007-02-05 20:22 UTC Bruno Wolff III <bruno@wolff.to>
` Re: optimizing a geo_distance() proximity query (example and benchmark)
2007-02-05 23:01 UTC Mark Stosberg <mark@summersault.com>
` Re: optimizing a geo_distance() proximity query (example and benchmark)
2007-02-06 05:40 UTC Bruno Wolff III <bruno@wolff.to>
` Re: optimizing a geo_distance() proximity query (example and benchmark)
2007-02-06 12:58 UTC Merlin Moncure <mmoncure@gmail.com>
[9+ messages in thread]
tuning
2005-05-26 20:54 UTC list <list@vbp2.vbp2.com>
` Re: tuning
2005-05-30 22:41 UTC Mark Kirkwood <markir@paradise.net.nz>
` Tuning
2007-01-26 11:28 UTC John Parnefjord <John.Parnefjord@kib.ki.se>
` Re: Tuning
2007-01-26 14:07 UTC Dave Cramer <pg@fastcrypt.com>
` Re: Tuning
2007-01-26 15:17 UTC Anton Rommerskirchen <atr@atrsoft.de>
` Re: Tuning
2007-01-28 23:24 UTC Josh Berkus <josh@agliodbs.com>
` Re: Tuning
2007-01-28 23:38 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Tuning
2007-01-29 16:14 UTC Ron <rjpeace@earthlink.net>
` Re: Tuning
2007-01-30 10:05 UTC John Parnefjord <John.Parnefjord@kib.ki.se>
` Re: Tuning
2007-01-31 17:25 UTC Mischa Sandberg <mischas@ca.sophos.com>
` Re: Tuning
2007-02-06 10:21 UTC Harald Armin Massa <haraldarminmassa@gmail.com>
[11+ messages in thread]
trouble with a join on OS X
2007-02-02 13:52 UTC Kirk Wythers <kwythers@umn.edu>
` Re: trouble with a join on OS X
2007-02-02 14:41 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: trouble with a join on OS X
2007-02-02 14:45 UTC Richard Huxton <dev@archonet.com>
` Re: trouble with a join on OS X
2007-02-02 14:50 UTC Gábriel Ákos <akos.gabriel@i-logic.hu>
` Re: trouble with a join on OS X
2007-02-02 15:46 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: trouble with a join on OS X
2007-02-02 15:59 UTC Kirk Wythers <kwythers@umn.edu>
` Re: trouble with a join on OS X
2007-02-02 16:05 UTC Kirk Wythers <kwythers@umn.edu>
` Re: trouble with a join on OS X
2007-02-02 16:09 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: trouble with a join on OS X
2007-02-02 16:11 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: trouble with a join on OS X
2007-02-02 16:53 UTC Kirk Wythers <kwythers@umn.edu>
` Re: trouble with a join on OS X
2007-02-02 17:54 UTC Kirk Wythers <kwythers@umn.edu>
` Re: trouble with a join on OS X
2007-02-02 17:59 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: trouble with a join on OS X
2007-02-02 18:06 UTC Kirk Wythers <kwythers@umn.edu>
` Re: trouble with a join on OS X
2007-02-02 22:18 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: trouble with a join on OS X
2007-02-03 01:39 UTC Luke Lonergan <llonergan@greenplum.com>
` Re: trouble with a join on OS X
2007-02-03 01:48 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: trouble with a join on OS X
2007-02-03 01:53 UTC Luke Lonergan <llonergan@greenplum.com>
` Re: trouble with a join on OS X
2007-02-03 02:01 UTC Kirk Wythers <kwythers@umn.edu>
` Re: trouble with a join on OS X
2007-02-03 02:03 UTC Kirk Wythers <kwythers@umn.edu>
` Re: trouble with a join on OS X
2007-02-03 02:05 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: trouble with a join on OS X
2007-02-03 02:10 UTC Geoffrey <esoteric@3times25.net>
` Re: trouble with a join on OS X
2007-02-03 02:32 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: trouble with a join on OS X
2007-02-03 02:32 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: trouble with a join on OS X
2007-02-03 03:19 UTC Kirk Wythers <kwythers@umn.edu>
` Re: trouble with a join on OS X
2007-02-03 03:25 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: trouble with a join on OS X
2007-02-03 03:31 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: trouble with a join on OS X
2007-02-03 15:59 UTC Shane Ambler <pgsql@007Marketing.com>
` Re: trouble with a join on OS X
2007-02-05 04:29 UTC Kirk Wythers <kwythers@umn.edu>
` Re: trouble with a join on OS X
2007-02-05 17:50 UTC Shane Ambler <pgsql@007Marketing.com>
[29+ messages in thread]
OT: Mac OS X disk buffer cache
2007-02-02 19:26 UTC Kevin Murphy <murphy@genome.chop.edu>
drive configuration for a new server
2007-02-02 00:41 UTC Ben <bench@silentmedia.com>
` Re: drive configuration for a new server
2007-02-02 18:16 UTC Jeff Frost <jeff@frostconsultingllc.com>
` Re: drive configuration for a new server
2007-02-02 18:49 UTC Ben <bench@silentmedia.com>
[3+ messages in thread]
Subselect query enhancement
2007-02-01 16:42 UTC Michael Artz <mlartz@gmail.com>
` Re: Subselect query enhancement
2007-02-01 17:23 UTC Richard Huxton <dev@archonet.com>
` Re: Subselect query enhancement
2007-02-01 17:28 UTC Ted Allen <tallen@blackducksoftware.com>
` Re: Subselect query enhancement
2007-02-01 18:14 UTC Michael Artz <mlartz@gmail.com>
` Re: Subselect query enhancement
2007-02-01 18:20 UTC Frank Wiles <frank@wiles.org>
` Re: Subselect query enhancement
2007-02-01 18:27 UTC Michael Artz <mlartz@gmail.com>
` Re: Subselect query enhancement
2007-02-01 19:02 UTC Richard Huxton <dev@archonet.com>
` Re: Subselect query enhancement
2007-02-01 19:06 UTC Michael Artz <mlartz@gmail.com>
` Re: Subselect query enhancement
2007-02-01 22:37 UTC Andrew Lazarus <andrew@pillette.com>
` Re: Subselect query enhancement
2007-02-02 09:51 UTC Richard Huxton <dev@archonet.com>
[10+ messages in thread]
int4 vs varchar to store ip addr
2007-01-29 16:22 UTC Pomarede Nicolas <npomarede@corp.free.fr>
` Re: int4 vs varchar to store ip addr
2007-01-29 16:26 UTC Florian Weimer <fweimer@bfk.de>
` Re: int4 vs varchar to store ip addr
2007-01-29 16:44 UTC Cosimo Streppone <cosimo@streppone.it>
` Re: int4 vs varchar to store ip addr
2007-01-30 10:54 UTC Pomarede Nicolas <npomarede@corp.free.fr>
` Re: int4 vs varchar to store ip addr
2007-02-01 19:30 UTC Michael Artz <mlartz@gmail.com>
[5+ messages in thread]
Using statement_timeout as a performance tool?
2007-02-01 14:10 UTC Mark Stosberg <mark@summersault.com>
Very slow queries
2007-01-30 21:09 UTC Sidar López Cruz <sidarlopez@hotmail.com>
` Re: Very slow queries
2007-01-30 21:14 UTC Ted Allen <tallen@blackducksoftware.com>
` Re: Very slow queries
2007-01-30 21:19 UTC Sidar López Cruz <sidarlopez@hotmail.com>
` Re: Very slow queries
2007-01-30 22:37 UTC Chad Wagner <chad.wagner@gmail.com>
` Re: Very slow queries
2007-01-31 14:19 UTC Sidar López Cruz <sidarlopez@hotmail.com>
` Re: Very slow queries
2007-01-31 14:32 UTC Ted Allen <tallen@blackducksoftware.com>
` Re: Very slow queries
2007-01-31 14:58 UTC Sidar López Cruz <sidarlopez@hotmail.com>
` Re: Very slow queries
2007-01-31 15:28 UTC Sidar López Cruz <sidarlopez@hotmail.com>
` Re: Very slow queries
2007-02-01 01:29 UTC Chad Wagner <chad.wagner@gmail.com>
[9+ messages in thread]
Querying distinct values from a large table
2007-01-30 08:33 UTC Igor Lobanov <ilobanov@swsoft.com>
` Re: Querying distinct values from a large table
2007-01-30 09:12 UTC Richard Huxton <dev@archonet.com>
` Re: Querying distinct values from a large table
2007-01-30 09:33 UTC Igor Lobanov <ilobanov@swsoft.com>
` Re: Querying distinct values from a large table
2007-01-30 09:36 UTC Igor Lobanov <ilobanov@swsoft.com>
` Re: Querying distinct values from a large table
2007-01-30 10:02 UTC Richard Huxton <dev@archonet.com>
` Re: Querying distinct values from a large table
2007-01-30 11:39 UTC imad <immaad@gmail.com>
` Re: Querying distinct values from a large table
2007-01-30 14:04 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: Querying distinct values from a large table
2007-01-30 14:11 UTC Richard Huxton <dev@archonet.com>
` Re: Querying distinct values from a large table
2007-01-30 14:13 UTC Chad Wagner <chad.wagner@gmail.com>
` Re: Querying distinct values from a large table
2007-01-30 14:38 UTC Brian Herlihy <btherl@yahoo.com.au>
` Re: Querying distinct values from a large table
2007-01-30 14:56 UTC Luke Lonergan <llonergan@greenplum.com>
` Re: Querying distinct values from a large table
2007-01-30 15:03 UTC Chad Wagner <chad.wagner@gmail.com>
` Re: Querying distinct values from a large table
2007-01-30 16:34 UTC Luke Lonergan <llonergan@greenplum.com>
` Re: Querying distinct values from a large table
2007-01-30 16:38 UTC Gregory Stark <gsstark@mit.edu>
` Re: Querying distinct values from a large table
2007-01-30 16:44 UTC Bruno Wolff III <bruno@wolff.to>
` Re: Querying distinct values from a large table
2007-01-30 17:04 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: Querying distinct values from a large table
2007-01-30 18:20 UTC Luke Lonergan <llonergan@greenplum.com>
` Re: Querying distinct values from a large table
2007-01-30 21:01 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Querying distinct values from a large table
2007-01-30 21:03 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: Querying distinct values from a large table
2007-01-30 23:00 UTC Josh Berkus <josh@agliodbs.com>
` Re: Querying distinct values from a large table
2007-01-30 23:17 UTC Luke Lonergan <llonergan@greenplum.com>
` Re: Querying distinct values from a large table
2007-01-31 05:55 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Querying distinct values from a large table
2007-01-31 06:58 UTC Luke Lonergan <llonergan@greenplum.com>
` Re: Querying distinct values from a large table
2007-01-31 13:24 UTC Gregory Stark <gsstark@mit.edu>
` Re: Querying distinct values from a large table
2007-01-31 14:46 UTC Ron <rjpeace@earthlink.net>
` Re: Querying distinct values from a large table
2007-01-31 15:15 UTC Tom Lane <tgl@sss.pgh.pa.us>
[26+ messages in thread]
Bad Row Count Estimate on View with 8.2
2007-01-23 22:08 UTC Dave Dutcher <dave@tridecap.com>
` Re: Bad Row Count Estimate on View with 8.2
2007-01-24 07:44 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Bad Row Count Estimate on View with 8.2
2007-01-28 17:02 UTC Dave Dutcher <dave@tridecap.com>
` Re: Bad Row Count Estimate on View with 8.2
2007-01-28 18:47 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Bad Row Count Estimate on View with 8.2
2007-01-30 14:54 UTC Dave Dutcher <dave@tridecap.com>
[5+ 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