pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
SQL Monitoring
  2007-10-09 14:11 UTC  Campbell, Lance <lance@uiuc.edu>
` Re: SQL Monitoring
  2007-10-09 14:36 UTC  Marcin Stępnicki <mstepnicki@gmail.com>
` Re: SQL Monitoring
  2007-10-09 15:07 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
` Re: SQL Monitoring
  2007-10-09 19:00 UTC  Gregory Stark <stark@enterprisedb.com>
` Re: SQL Monitoring
  2007-10-10 10:41 UTC  Tomáš Vondra <tv@fuzzy.cz>
` Re: SQL Monitoring
  2007-10-10 14:58 UTC  Rodrigo De León <rdeleonp@gmail.com>
` Re: SQL Monitoring
  2007-10-10 17:25 UTC  Josh Trutwin <josh@trutwins.homeip.net>
  [7+ messages in thread]

Postgres running Very slowly
  2007-10-09 20:00 UTC  Radhika S <radhika.sambamurti@gmail.com>
` Re: Postgres running Very slowly
  2007-10-09 20:18 UTC  Bill Moran <wmoran@collaborativefusion.com>
  [2+ messages in thread]

Apache2 PostgreSQL http authentication
  2007-10-07 13:14 UTC  Jeffrey Brower <Jeff@PointHere.net>
` Re: Apache2 PostgreSQL http authentication
  2007-10-07 15:19 UTC  A.M. <agentm@themactionfaction.com>
` Re: Apache2 PostgreSQL http authentication
  2007-10-07 19:07 UTC  Jeffrey Brower <Jeff@PointHere.net>
` Re: Apache2 PostgreSQL http authentication
  2007-10-07 20:28 UTC  Jeffrey Brower <Jeff@PointHere.net>
` Re: Apache2 PostgreSQL http authentication
  2007-10-07 20:44 UTC  D'Arcy J.M. Cain <darcy@druid.net>
` Re: Apache2 PostgreSQL http authentication
  2007-10-07 20:58 UTC  Jeffrey Brower <Jeff@PointHere.net>
` Re: Apache2 PostgreSQL http authentication
  2007-10-08 00:29 UTC  Jeffrey Brower <Jeff@PointHere.net>
` Re: Apache2 PostgreSQL http authentication
  2007-10-08 06:12 UTC  Magnus Hagander <magnus@hagander.net>
` Re: Apache2 PostgreSQL http authentication
  2007-10-08 17:09 UTC  Tino Wildenhain <tino@wildenhain.de>
` Re: Apache2 PostgreSQL http authentication
  2007-10-08 17:12 UTC  Magnus Hagander <magnus@hagander.net>
  [10+ messages in thread]

postgresql on NFS.. recommended? not recommended?
  2007-10-08 12:39 UTC  Gábor Farkas <gabor@nekomancer.net>
` Re: postgresql on NFS.. recommended? not recommended?
  2007-10-08 13:43 UTC  Josh Tolley <eggyknap@gmail.com>
  [2+ messages in thread]

query plan worse after analyze
  2007-10-06 02:02 UTC  Jeff Frost <jeff@frostconsultingllc.com>
` Re: query plan worse after analyze
  2007-10-06 03:14 UTC  Stephen Frost <sfrost@snowman.net>
` Re: query plan worse after analyze
  2007-10-06 03:58 UTC  Rodrigo De León <rdeleonp@gmail.com>
` Re: query plan worse after analyze
  2007-10-06 04:12 UTC  Jeff Frost <jeff@frostconsultingllc.com>
` Re: query plan worse after analyze
  2007-10-06 05:50 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: query plan worse after analyze
  2007-10-06 06:41 UTC  Jeff Frost <jeff@frostconsultingllc.com>
` Re: query plan worse after analyze
  2007-10-06 15:11 UTC  Alvaro Herrera <alvherre@commandprompt.com>
` Re: query plan worse after analyze
  2007-10-07 16:06 UTC  Richard Broersma Jr <rabroersma@yahoo.com>
  [8+ messages in thread]

Problems with + 1 million record table
  2007-10-05 14:34 UTC  Cláudia Macedo Amorim <claudia.amorim@pcinformatica.com.br>
` Re: Problems with + 1 million record table
  2007-10-05 15:01 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Problems with + 1 million record table
  2007-10-05 16:38 UTC  Arjen van der Meijden <acmmailing@tweakers.net>
` Re: Problems with + 1 million record table
  2007-10-05 17:45 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: Problems with + 1 million record table
  2007-10-06 01:19 UTC  Shane Ambler <pgsql@Sheeky.Biz>
  [5+ messages in thread]

Partitioning in postgres - basic question
  2007-10-04 17:51 UTC  Tore Lukashaugen <tore@lukashaugen.freeserve.co.uk>
` Re: Partitioning in postgres - basic question
  2007-10-05 05:19 UTC  Chris <dmagick@gmail.com>
  [2+ messages in thread]

quickly getting the top N rows
  2007-10-04 18:00 UTC  Ben <bench@silentmedia.com>
` Re: quickly getting the top N rows
  2007-10-04 18:10 UTC  Mark Lewis <mark.lewis@mir3.com>
` Re: quickly getting the top N rows
  2007-10-04 18:14 UTC  Bill Moran <wmoran@collaborativefusion.com>
` Re: quickly getting the top N rows
  2007-10-04 18:22 UTC  Andreas Kretschmer <akretschmer@spamfence.net>
` Re: quickly getting the top N rows
  2007-10-04 18:33 UTC  Ben <bench@silentmedia.com>
` Re: quickly getting the top N rows
  2007-10-04 18:52 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: quickly getting the top N rows
  2007-10-04 19:52 UTC  Ben <bench@silentmedia.com>
` Re: quickly getting the top N rows
  2007-10-04 20:23 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: quickly getting the top N rows
  2007-10-04 20:32 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: quickly getting the top N rows
  2007-10-04 20:34 UTC  Ben <bench@silentmedia.com>
` Re: quickly getting the top N rows
  2007-10-04 20:35 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: quickly getting the top N rows
  2007-10-04 21:01 UTC  Richard Huxton <dev@archonet.com>
` Re: quickly getting the top N rows
  2007-10-04 21:04 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: quickly getting the top N rows
  2007-10-04 21:16 UTC  Ben <bench@silentmedia.com>
  [14+ messages in thread]

Tuning Help - What did I do wrong?
  2007-10-04 15:28 UTC  Josh Trutwin <josh@trutwins.homeip.net>
` Re: Tuning Help - What did I do wrong?
  2007-10-04 16:19 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Tuning Help - What did I do wrong?
  2007-10-04 16:22 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Tuning Help - What did I do wrong?
  2007-10-04 17:00 UTC  Josh Trutwin <josh@trutwins.homeip.net>
` Re: Tuning Help - What did I do wrong?
  2007-10-04 17:42 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Tuning Help - What did I do wrong?
  2007-10-04 19:03 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Tuning Help - What did I do wrong?
  2007-10-04 19:28 UTC  Josh Trutwin <josh@trutwins.homeip.net>
  [7+ messages in thread]

can't shrink relation
  2007-10-04 09:43 UTC  Sabin Coanda <sabin.coanda@deuromedia.ro>
` Re: can't shrink relation
  2007-10-04 09:46 UTC  Sabin Coanda <sabin.coanda@deuromedia.ro>
` Re: can't shrink relation
  2007-10-04 10:11 UTC  Guillaume Cottenceau <gc@mnc.ch>
` Re: can't shrink relation
  2007-10-04 10:34 UTC  Richard Huxton <dev@archonet.com>
  [4+ messages in thread]

Newbie question about degraded performance on delete statement.
  2007-10-02 21:55 UTC  Giulio Cesare Solaroli <giulio.cesare@gmail.com>
` Re: Newbie question about degraded performance on delete statement.
  2007-10-02 22:02 UTC  Dan Langille <dan@langille.org>
` Re: Newbie question about degraded performance on delete statement.
  2007-10-02 22:39 UTC  Greg Williamson <Gregory.Williamson@digitalglobe.com>
` Re: Newbie question about degraded performance on delete statement.
  2007-10-03 06:56 UTC  Giulio Cesare Solaroli <giulio.cesare@gmail.com>
` Re: Newbie question about degraded performance on delete statement. (SOLVED)
  2007-10-03 07:00 UTC  Giulio Cesare Solaroli <giulio.cesare@gmail.com>
  [5+ messages in thread]

Difference between Vacuum and Vacuum full
  2007-10-03 01:45 UTC  Radhika S <radhika.sambamurti@gmail.com>
` Re: Difference between Vacuum and Vacuum full
  2007-10-03 01:55 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Difference between Vacuum and Vacuum full
  2007-10-03 01:56 UTC  Rodrigo De León <rdeleonp@gmail.com>
` Re: Difference between Vacuum and Vacuum full
  2007-10-03 02:02 UTC  D'Arcy J.M. Cain <darcy@druid.net>
` Re: Difference between Vacuum and Vacuum full
  2007-10-03 03:05 UTC  Radhika S <radhika.sambamurti@gmail.com>
  [5+ messages in thread]

Linux mis-reporting memory
  2007-09-20 23:04 UTC  Decibel! <decibel@decibel.org>
` Re: Linux mis-reporting memory
  2007-09-20 23:12 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Linux mis-reporting memory
  2007-09-21 00:22 UTC  Adam Tauno Williams <adamtaunowilliams@gmail.com>
` Re: Linux mis-reporting memory
  2007-09-21 08:03 UTC  Gregory Stark <stark@enterprisedb.com>
` Re: Linux mis-reporting memory
  2007-09-21 08:30 UTC  Csaba Nagy <nagy@ecircle-ag.com>
` Re: Linux mis-reporting memory
  2007-09-21 09:43 UTC  Gregory Stark <stark@enterprisedb.com>
` Re: Linux mis-reporting memory
  2007-09-21 09:48 UTC  Dimitri Fontaine <dfontaine@hi-media.com>
` Re: Linux mis-reporting memory
  2007-09-21 10:08 UTC  Csaba Nagy <nagy@ecircle-ag.com>
` Re: Linux mis-reporting memory
  2007-09-21 10:34 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
` Re: Linux mis-reporting memory
  2007-09-21 11:01 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: Linux mis-reporting memory
  2007-09-21 11:34 UTC  Csaba Nagy <nagy@ecircle-ag.com>
` Re: Linux mis-reporting memory
  2007-09-21 19:24 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: Linux mis-reporting memory
  2007-10-02 15:57 UTC  Decibel! <decibel@decibel.org>
` Re: Linux mis-reporting memory
  2007-10-02 16:51 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Linux mis-reporting memory
  2007-10-02 18:37 UTC  Adam Tauno Williams <adamtaunowilliams@gmail.com>
` Re: Linux mis-reporting memory
  2007-10-02 22:17 UTC  Decibel! <decibel@decibel.org>
  [16+ messages in thread]

performance of like queries
  2007-10-02 17:31 UTC  Kevin Kempter <kevin@kevinkempterllc.com>
` Re: performance of like queries
  2007-10-02 21:06 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: performance of like queries
  2007-10-02 21:49 UTC  Marcin Stępnicki <mstepnicki@gmail.com>
` Re: performance of like queries
  2007-10-02 21:55 UTC  Chris Browne <cbbrowne@acm.org>
  [4+ messages in thread]

sequence query performance issues
  2007-09-27 22:04 UTC  Peter Koczan <pjkoczan@gmail.com>
` Re: sequence query performance issues
  2007-09-28 08:06 UTC  Richard Huxton <dev@archonet.com>
` Re: sequence query performance issues
  2007-09-28 14:16 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: sequence query performance issues
  2007-09-28 14:43 UTC  Richard Huxton <dev@archonet.com>
` Re: sequence query performance issues
  2007-09-28 17:33 UTC  Peter Koczan <pjkoczan@gmail.com>
` Re: sequence query performance issues
  2007-10-01 19:23 UTC  Peter Koczan <pjkoczan@gmail.com>
  [6+ messages in thread]

Non-blocking vacuum full
  2007-09-28 18:06 UTC  Peter Schuller <peter.schuller@infidyne.com>
` Re: Non-blocking vacuum full
  2007-09-28 19:31 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
` Re: Non-blocking vacuum full
  2007-09-29 02:46 UTC  Ron Mayer <rm_pg@cheapcomplexdevices.com>
` Re: Non-blocking vacuum full
  2007-09-29 08:05 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
  [4+ messages in thread]

OOM Errors as a result of table inheritance and a bad plan(?)
  2007-09-28 17:50 UTC  Arctic Toucan <arctic_toucan@hotmail.com>
` Re: OOM Errors as a result of table inheritance and a bad plan(?)
  2007-09-28 20:56 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

Postgres 7.4.2 hanging when vacuum full is run
  2007-09-28 14:28 UTC  Radhika S <radhika.sambamurti@gmail.com>
` Re: Postgres 7.4.2 hanging when vacuum full is run
  2007-09-28 14:53 UTC  Vivek Khera <vivek@khera.org>
` Re: Postgres 7.4.2 hanging when vacuum full is run
  2007-09-28 15:28 UTC  Scott Marlowe <scott.marlowe@gmail.com>
  [3+ messages in thread]

Tuning for warm standby
  2007-09-27 17:42 UTC  Kevin Kempter <kevin@kevinkempterllc.com>
` Re: Tuning for warm standby
  2007-09-28 13:17 UTC  Merlin Moncure <mmoncure@gmail.com>
  [2+ messages in thread]

Searching for the cause of a bad plan
  2007-09-21 10:03 UTC  Csaba Nagy <nagy@ecircle-ag.com>
` Re: Searching for the cause of a bad plan
  2007-09-21 10:59 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: Searching for the cause of a bad plan
  2007-09-21 11:29 UTC  Csaba Nagy <nagy@ecircle-ag.com>
` Re: Searching for the cause of a bad plan
  2007-09-21 11:34 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: Searching for the cause of a bad plan
  2007-09-21 12:12 UTC  Csaba Nagy <nagy@ecircle-ag.com>
` Re: Searching for the cause of a bad plan
  2007-09-21 13:36 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: Searching for the cause of a bad plan
  2007-09-21 14:26 UTC  Csaba Nagy <nagy@ecircle-ag.com>
` Re: Searching for the cause of a bad plan
  2007-09-21 15:48 UTC  Csaba Nagy <nagy@ecircle-ag.com>
` Re: Searching for the cause of a bad plan
  2007-09-21 16:08 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Searching for the cause of a bad plan
  2007-09-21 17:18 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: Searching for the cause of a bad plan
  2007-09-21 17:39 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: Searching for the cause of a bad plan
  2007-09-21 17:53 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Searching for the cause of a bad plan
  2007-09-21 18:37 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: Searching for the cause of a bad plan
  2007-09-21 23:30 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Searching for the cause of a bad plan
  2007-09-24 13:27 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: Searching for the cause of a bad plan
  2007-09-24 14:04 UTC  Csaba Nagy <nagy@ecircle-ag.com>
` Re: Searching for the cause of a bad plan
  2007-09-24 17:55 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: Searching for the cause of a bad plan
  2007-09-26 14:52 UTC  Csaba Nagy <nagy@ecircle-ag.com>
` Re: Searching for the cause of a bad plan
  2007-09-26 15:22 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Searching for the cause of a bad plan
  2007-09-27 11:53 UTC  Csaba Nagy <nagy@ecircle-ag.com>
` Re: Searching for the cause of a bad plan
  2007-09-27 14:40 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Searching for the cause of a bad plan
  2007-09-27 15:16 UTC  Csaba Nagy <nagy@ecircle-ag.com>
` Re: Searching for the cause of a bad plan
  2007-09-27 15:24 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: Searching for the cause of a bad plan
  2007-09-27 18:07 UTC  Ron Mayer <rm_pg@cheapcomplexdevices.com>
` Re: Searching for the cause of a bad plan
  2007-09-28 08:12 UTC  Csaba Nagy <nagy@ecircle-ag.com>
` Re: Searching for the cause of a bad plan
  2007-09-28 12:33 UTC  Csaba Nagy <nagy@ecircle-ag.com>
  [26+ messages in thread]

Difference in query plan when using = or > in where clause
  2007-09-26 18:00 UTC  Radhika S <radhika.sambamurti@gmail.com>
` Re: Difference in query plan when using = or > in where clause
  2007-09-27 12:39 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
  [2+ messages in thread]

REPOST: Nested loops row estimates always too high
  2007-09-20 15:02 UTC  Carlo Stonebanks <stonec.register@sympatico.ca>
` Re: REPOST: Nested loops row estimates always too high
  2007-09-24 06:46 UTC  Ow Mun Heng <Ow.Mun.Heng@wdc.com>
` Re: REPOST: Nested loops row estimates always too high
  2007-09-24 18:12 UTC  Carlo Stonebanks <stonec.register@sympatico.ca>
` Re: REPOST: Nested loops row estimates always too high
  2007-09-25 00:50 UTC  Ow Mun Heng <Ow.Mun.Heng@wdc.com>
` Re: REPOST: Nested loops row estimates always too high
  2007-09-25 04:53 UTC  Carlo Stonebanks <stonec.register@sympatico.ca>
` Re: REPOST: Nested loops row estimates always too high
  2007-09-25 05:15 UTC  Ow Mun Heng <Ow.Mun.Heng@wdc.com>
` Re: REPOST: Nested loops row estimates always too high
  2007-09-25 09:31 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: REPOST: Nested loops row estimates always too high
  2007-09-26 03:50 UTC  Ow Mun Heng <Ow.Mun.Heng@wdc.com>
` Re: REPOST: Nested loops row estimates always too high
  2007-09-26 04:02 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: REPOST: Nested loops row estimates always too high
  2007-09-27 06:59 UTC  Ow Mun Heng <Ow.Mun.Heng@wdc.com>
  [10+ messages in thread]

Incorrect row estimates in plan?
  2007-09-26 14:22 UTC  pgdba <postgresql@inbox.com>
` Re: Incorrect row estimates in plan?
  2007-09-26 14:45 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Incorrect row estimates in plan?
  2007-09-26 15:24 UTC  pgdba <postgresql@inbox.com>
` Re: Incorrect row estimates in plan?
  2007-09-26 16:38 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Incorrect row estimates in plan?
  2007-09-26 16:56 UTC  pgdba <postgresql@inbox.com>
  [5+ messages in thread]

query io stats and finding a slow query
  2007-09-20 21:36 UTC  Kamen Stanev <hambai@gmail.com>
` Re: query io stats and finding a slow query
  2007-09-21 16:35 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: query io stats and finding a slow query
  2007-09-25 19:41 UTC  Kamen Stanev <hambai@gmail.com>
` Re: query io stats and finding a slow query
  2007-09-25 19:58 UTC  Bryan Murphy <bryan.murphy@gmail.com>
  [4+ messages in thread]

Attempting to disable count triggers on cleanup
  2007-09-25 11:08 UTC  Dave Cramer <pg@fastcrypt.com>
` Re: Attempting to disable count triggers on cleanup
  2007-09-25 11:21 UTC  hubert depesz lubaczewski <depesz@depesz.com>
` Re: Attempting to disable count triggers on cleanup
  2007-09-25 11:39 UTC  Dave Cramer <pg@fastcrypt.com>
  [3+ 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