pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Acceptable level of over-estimation?
  2007-09-24 19:37 UTC  Carlo Stonebanks <stonec.register@sympatico.ca>
` Re: Acceptable level of over-estimation?
  2007-09-24 20:18 UTC  Gregory Stark <stark@enterprisedb.com>
  [2+ messages in thread]

TEXT or LONGTEXT?
  2007-09-24 15:21 UTC  Fabiola Fernández <fabiola.fg@gmail.com>
` Re: TEXT or LONGTEXT?
  2007-09-24 15:29 UTC  Alexander Staubo <alex@purefiction.net>
` Re: TEXT or LONGTEXT?
  2007-09-24 16:00 UTC  Niklas Johansson <spot@tele2.se>
  [3+ messages in thread]

select count(*) performance (vacuum did not help)
  2007-09-24 14:07 UTC  Gábor Farkas <gabor@nekomancer.net>
` Re: select count(*) performance (vacuum did not help)
  2007-09-24 14:23 UTC  Pavan Deolasee <pavan.deolasee@gmail.com>
` Re: select count(*) performance (vacuum did not help)
  2007-09-24 14:30 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
` Re: select count(*) performance (vacuum did not help)
  2007-09-24 15:04 UTC  Gábor Farkas <gabor@nekomancer.net>
` Re: select count(*) performance (vacuum did not help)
  2007-09-24 15:07 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
` Re: select count(*) performance (vacuum did not help)
  2007-09-24 15:14 UTC  Gábor Farkas <gabor@nekomancer.net>
` Re: select count(*) performance (vacuum did not help)
  2007-09-24 15:29 UTC  Bill Moran <wmoran@collaborativefusion.com>
` Re: select count(*) performance (vacuum did not help)
  2007-09-24 15:34 UTC  Csaba Nagy <nagy@ecircle-ag.com>
` Re: select count(*) performance (vacuum did not help)
  2007-09-24 15:37 UTC  Dave Dutcher <dave@tridecap.com>
  [9+ messages in thread]

Low CPU Usage
  2007-09-19 17:38 UTC  brauagustin-susc@yahoo.com.ar
` Re: Low CPU Usage
  2007-09-19 17:52 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
` Re: Low CPU Usage
  2007-09-19 18:03 UTC  Mark Lewis <mark.lewis@mir3.com>
` Re: Low CPU Usage
  2007-09-19 19:13 UTC  brauagustin-susc@yahoo.com.ar
` Re: Low CPU Usage
  2007-09-19 19:41 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Low CPU Usage
  2007-09-19 19:52 UTC  brauagustin-susc@yahoo.com.ar
` Re: Low CPU Usage
  2007-09-19 20:15 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Low CPU Usage
  2007-09-20 11:30 UTC  brauagustin-susc@yahoo.com.ar
` Re: Low CPU Usage
  2007-09-20 12:31 UTC  Jean-David Beyer <jeandavid8@verizon.net>
` Re: Low CPU Usage
  2007-09-20 17:28 UTC  brauagustin-susc@yahoo.com.ar
` Re: Low CPU Usage
  2007-09-21 17:30 UTC  brauagustin-susc@yahoo.com.ar
` Re: Low CPU Usage
  2007-09-21 17:51 UTC  brauagustin-susc@yahoo.com.ar
` Re: Low CPU Usage
  2007-09-21 17:51 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Low CPU Usage
  2007-09-21 18:20 UTC  brauagustin-susc@yahoo.com.ar
` Re: Low CPU Usage
  2007-09-21 18:33 UTC  Bill Moran <wmoran@collaborativefusion.com>
` Re: Low CPU Usage
  2007-09-21 19:01 UTC  brauagustin-susc@yahoo.com.ar
` Re: Low CPU Usage
  2007-09-21 19:11 UTC  Bill Moran <wmoran@collaborativefusion.com>
` Re: Low CPU Usage
  2007-09-21 19:33 UTC  brauagustin-susc@yahoo.com.ar
` Re: Low CPU Usage
  2007-09-21 20:40 UTC  Luiz K. Matsumura <luiz@planit.com.br>
` Re: Low CPU Usage
  2007-09-21 20:55 UTC  Dave Dutcher <dave@tridecap.com>
` Re: Low CPU Usage
  2007-09-21 20:57 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Low CPU Usage
  2007-09-21 21:15 UTC  Craig James <craig_james@emolecules.com>
` Re: Low CPU Usage
  2007-09-21 21:45 UTC  brauagustin-susc@yahoo.com.ar
` Re: Low CPU Usage
  2007-09-22 06:29 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: Low CPU Usage
  2007-09-24 13:59 UTC  brauagustin-susc@yahoo.com.ar
` Re: Low CPU Usage
  2007-09-24 14:16 UTC  brauagustin-susc@yahoo.com.ar
  [26+ messages in thread]

Postgres performance problem
  2007-08-27 11:41 UTC  Ruben Rubio <ruben@rentalia.com>
` Re: Postgres performance problem
  2007-08-27 12:33 UTC  Chris Mair <chris@1006.org>
` Re: Postgres performance problem
  2007-08-27 12:52 UTC  ruben@rentalia.com
` Re: Postgres performance problem
  2007-08-27 13:29 UTC  Bill Moran <wmoran@collaborativefusion.com>
` Re: Postgres performance problem
  2007-08-28 18:36 UTC  Anton Melser <melser.anton@gmail.com>
` Re: Postgres performance problem
  2007-08-30 07:52 UTC  ruben@rentalia.com
` Re: [Solved] Postgres performance problem
  2007-08-30 09:50 UTC  Ruben Rubio <ruben@rentalia.com>
` Re: [Solved] Postgres performance problem
  2007-08-30 17:31 UTC  Decibel! <decibel@decibel.org>
` Re: [Solved] Postgres performance problem
  2007-08-30 18:07 UTC  Richard Huxton <dev@archonet.com>
` Re: [Solved] Postgres performance problem
  2007-08-30 18:08 UTC  Mark Lewis <mark.lewis@mir3.com>
` Re: [Solved] Postgres performance problem
  2007-08-31 19:36 UTC  Vivek Khera <vivek@khera.org>
` [Again] Postgres performance problem
  2007-09-11 06:33 UTC  Ruben Rubio <ruben@rentalia.com>
` Re: [Again] Postgres performance problem
  2007-09-11 07:31 UTC  db@zigo.dhs.org
` Re: [Again] Postgres performance problem
  2007-09-11 07:49 UTC  Ruben Rubio <ruben@rentalia.com>
` Re: [Again] Postgres performance problem
  2007-09-11 22:52 UTC  Decibel! <decibel@decibel.org>
` Re: [Again] Postgres performance problem
  2007-09-12 07:42 UTC  ruben@rentalia.com
` Re: [Again] Postgres performance problem
  2007-09-12 18:28 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: [Again] Postgres performance problem
  2007-09-12 18:46 UTC  Brian Hurt <bhurt@janestcapital.com>
` Re: [Again] Postgres performance problem
  2007-09-12 18:56 UTC  Mikko Partio <mpartio@gmail.com>
` Re: [Again] Postgres performance problem
  2007-09-12 19:07 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: [Again] Postgres performance problem
  2007-09-12 19:19 UTC  Frank Schoep <frank@ffnn.nl>
` Re: [Again] Postgres performance problem
  2007-09-12 19:27 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: [Again] Postgres performance problem
  2007-09-12 19:40 UTC  Alvaro Herrera <alvherre@commandprompt.com>
` Re: [Again] Postgres performance problem
  2007-09-12 20:01 UTC  Erik Jones <erik@myemma.com>
` Re: [Again] Postgres performance problem
  2007-09-13 05:58 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: [Again] Postgres performance problem
  2007-09-13 07:20 UTC  El-Lotso <el.lotso@gmail.com>
` Re: [Again] Postgres performance problem
  2007-09-13 14:29 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: [Again] Postgres performance problem
  2007-09-13 15:31 UTC  Gavin M. Roy <gmr@ehpg.net>
` Re: [Again] Postgres performance problem
  2007-09-13 16:03 UTC  Erik Jones <erik@myemma.com>
` Re: [Again] Postgres performance problem
  2007-09-13 16:39 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: [Again] Postgres performance problem
  2007-09-14 07:19 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: [Again] Postgres performance problem
  2007-09-14 14:00 UTC  Adam Tauno Williams <adamtaunowilliams@gmail.com>
` Re: [Again] Postgres performance problem
  2007-09-17 12:00 UTC  Ruben Rubio <ruben@rentalia.com>
` Re: [Again] Postgres performance problem
  2007-09-17 12:24 UTC  Decibel! <decibel@decibel.org>
` Re: [Again] Postgres performance problem
  2007-09-17 12:27 UTC  Decibel! <decibel@decibel.org>
` [OT] Re: [Again] Postgres performance problem
  2007-09-24 06:58 UTC  Ow Mun Heng <Ow.Mun.Heng@wdc.com>
  [36+ messages in thread]

Possible explanations for catastrophic performace deterioration?
  2007-09-23 16:45 UTC  Carlos Moreno <moreno_pg@mochima.com>
` Re: Possible explanations for catastrophic performace deterioration?
  2007-09-23 16:56 UTC  Jonah H. Harris <jonah.harris@gmail.com>
` Re: Possible explanations for catastrophic performace deterioration?
  2007-09-23 17:27 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Possible explanations for catastrophic performace deterioration?
  2007-09-23 18:15 UTC  Carlos Moreno <moreno_pg@mochima.com>
` Re: Possible explanations for catastrophic performace deterioration?
  2007-09-23 18:23 UTC  Alvaro Herrera <alvherre@commandprompt.com>
` Re: Possible explanations for catastrophic performace	deterioration?
  2007-09-23 19:12 UTC  Carlos Moreno <moreno_pg@mochima.com>
` Re: Possible explanations for catastrophic performace deterioration?
  2007-09-23 19:24 UTC  Jonah H. Harris <jonah.harris@gmail.com>
` Re: Possible explanations for catastrophic performance deterioration?
  2007-09-23 20:33 UTC  Carlos Moreno <moreno_pg@mochima.com>
` Re: Possible explanations for catastrophic performance deterioration?
  2007-09-23 20:57 UTC  Alvaro Herrera <alvherre@commandprompt.com>
` Re: Possible explanations for catastrophic performance deterioration?
  2007-09-23 21:55 UTC  Carlos Moreno <moreno_pg@mochima.com>
` Re: Possible explanations for catastrophic performance deterioration?
  2007-09-23 22:29 UTC  Jonah H. Harris <jonah.harris@gmail.com>
` Re: Possible explanations for catastrophic performance deterioration?
  2007-09-23 23:05 UTC  Gregory Stark <stark@enterprisedb.com>
  [12+ messages in thread]

zero value in statistics collector's result
  2007-09-23 17:00 UTC  Yinan Li <yinanli@cse.ust.hk>

Query planner unaware of possibly best plan
  2007-09-21 15:36 UTC  Denes Daniel <panther-d@freemail.hu>
` Re: Query planner unaware of possibly best plan
  2007-09-21 17:49 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: Query planner unaware of possibly best plan
  2007-09-21 19:29 UTC  Denes Daniel <panther-d@freemail.hu>
` Re: Query planner unaware of possibly best plan
  2007-09-21 19:56 UTC  Alvaro Herrera <alvherre@commandprompt.com>
` Re: Query planner unaware of possibly best plan
  2007-09-21 20:05 UTC  Denes Daniel <panther-d@freemail.hu>
` Re: Query planner unaware of possibly best plan
  2007-09-22 00:08 UTC  Denes Daniel <panther-d@freemail.hu>
` Re: Query planner unaware of possibly best plan
  2007-09-22 06:07 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query planner unaware of possibly best plan
  2007-09-22 12:33 UTC  Denes Daniel <panther-d@freemail.hu>
  [8+ messages in thread]

Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!!
  2007-09-20 19:10 UTC  smiley2211 <smiley2211@yahoo.com>
` Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!!
  2007-09-20 19:34 UTC  Carlos Moreno <moreno_pg@mochima.com>
` Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!!
  2007-09-20 20:32 UTC  smiley2211 <smiley2211@yahoo.com>
` Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!!
  2007-09-20 21:25 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!!
  2007-09-20 21:25 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!!
  2007-09-20 23:25 UTC  smiley2211 <smiley2211@yahoo.com>
` Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!!
  2007-09-21 00:52 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!!
  2007-09-21 03:25 UTC  smiley2211 <smiley2211@yahoo.com>
` Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!!
  2007-09-21 05:58 UTC  db@zigo.dhs.org
` Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!!
  2007-09-21 13:14 UTC  smiley2211 <smiley2211@yahoo.com>
` Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!!
  2007-09-21 13:25 UTC  Bill Moran <wmoran@collaborativefusion.com>
` Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!!
  2007-09-21 13:28 UTC  Jeff Harris <jeffharris@tkontheweb.com>
` Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!!
  2007-09-21 14:07 UTC  Dave Dutcher <dave@tridecap.com>
  [13+ messages in thread]

Tablespaces and NFS
  2007-09-19 15:58 UTC  Carlos Moreno <moreno_pg@mochima.com>
` Re: Tablespaces and NFS
  2007-09-19 20:49 UTC  Craig James <craig_james@emolecules.com>
` Re: Tablespaces and NFS
  2007-09-19 21:54 UTC  Peter Koczan <pjkoczan@gmail.com>
` Re: Tablespaces and NFS
  2007-09-20 13:20 UTC  Carlos Moreno <moreno_pg@mochima.com>
` Re: Tablespaces and NFS
  2007-09-20 18:50 UTC  Peter Koczan <pjkoczan@gmail.com>
` Re: Tablespaces and NFS
  2007-09-20 19:24 UTC  Carlos Moreno <moreno_pg@mochima.com>
  [6+ messages in thread]

REPOST: Performance improves only after repeated VACUUM/ANALYZE
  2007-09-20 14:59 UTC  Carlo Stonebanks <stonec.register@sympatico.ca>

R: R: DELETE queries slow down
  2007-09-19 09:46 UTC  Galantucci Giovanni <Giovanni.Galantucci@italtel.it>
` Re: R: R: DELETE queries slow down
  2007-09-19 11:14 UTC  Bill Moran <wmoran@collaborativefusion.com>
` Re: R: R: DELETE queries slow down
  2007-09-19 11:25 UTC  Gregory Williamson <Gregory.Williamson@digitalglobe.com>
  [3+ messages in thread]

Nested loops row estimates always too high
  2007-09-18 20:07 UTC  Carlo Stonebanks <stonec.register@sympatico.ca>

Performance improves only after repeated VACUUM/ANALYZE
  2007-09-18 19:59 UTC  Carlo Stonebanks <stonec.register@sympatico.ca>

R: DELETE queries slow down
  2007-09-18 07:17 UTC  Galantucci Giovanni <Giovanni.Galantucci@italtel.it>
` Re: R: DELETE queries slow down
  2007-09-18 16:18 UTC  Bill Moran <wmoran@collaborativefusion.com>
  [2+ messages in thread]

Regarding COPY command from Postgres 8.2.0
  2007-09-14 10:21 UTC  soni de <soni.de@gmail.com>
` Re: Regarding COPY command from Postgres 8.2.0
  2007-09-14 12:03 UTC  Ansgar -59cobalt- Wiechers <lists@planetcobalt.net>
` Re: Regarding COPY command from Postgres 8.2.0
  2007-09-18 04:31 UTC  soni de <soni.de@gmail.com>
` Re: Regarding COPY command from Postgres 8.2.0
  2007-09-18 14:53 UTC  Evan Carroll <lists@evancarroll.com>
` Re: Regarding COPY command from Postgres 8.2.0
  2007-09-18 15:04 UTC  Scott Marlowe <scott.marlowe@gmail.com>
  [5+ messages in thread]

Query works when kludged, but would prefer "best practice" solution
  2007-09-17 20:22 UTC  Carlo Stonebanks <stonec.register@sympatico.ca>
` Re: Query works when kludged, but would prefer "best practice" solution
  2007-09-18 00:03 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: Query works when kludged, but would prefer "best practice" solution
  2007-09-18 00:13 UTC  Carlo Stonebanks <stonec.register@sympatico.ca>
` Re: Query works when kludged, but would prefer "best practice" solution
  2007-09-18 00:17 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: Query works when kludged, but would prefer "best practice" solution
  2007-09-18 00:38 UTC  Carlo Stonebanks <stonec.register@sympatico.ca>
` Re: Query works when kludged, but would prefer "best practice" solution
  2007-09-18 03:29 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query works when kludged, but would prefer "best practice" solution
  2007-09-18 06:29 UTC  Carlo Stonebanks <stonec.register@sympatico.ca>
` Re: Query works when kludged, but would prefer "best practice" solution
  2007-09-18 14:08 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query works when kludged, but would prefer "best practice" solution
  2007-09-18 14:11 UTC  Dave Dutcher <dave@tridecap.com>
  [9+ messages in thread]

Index usage when bitwise operator is used
  2007-09-13 12:30 UTC  W.Alphonse HAROUNY <wharouny@gmail.com>
` Re: Index usage when bitwise operator is used
  2007-09-16 10:08 UTC  Valentine Gogichashvili <valgog@gmail.com>
` Re: Index usage when bitwise operator is used
  2007-09-16 23:58 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Index usage when bitwise operator is used
  2007-09-17 07:47 UTC  valgog <valgog@gmail.com>
` Re: Index usage when bitwise operator is used
  2007-09-17 07:49 UTC  valgog <valgog@gmail.com>
` Re: Index usage when bitwise operator is used
  2007-09-17 12:27 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Index usage when bitwise operator is used
  2007-09-17 13:37 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Index usage when bitwise operator is used
  2007-09-17 14:30 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Index usage when bitwise operator is used
  2007-09-17 14:40 UTC  W.Alphonse HAROUNY <wharouny@gmail.com>
` Re: Index usage when bitwise operator is used
  2007-09-18 10:36 UTC  valgog <valgog@gmail.com>
  [10+ messages in thread]

DRBD and Postgres: how to improve the perfomance?
  2007-09-07 09:37 UTC  Maila Fatticcioni <mfatticcioni@mbigroup.it>
` Re: DRBD and Postgres: how to improve the perfomance?
  2007-09-07 10:12 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
` Re: DRBD and Postgres: how to improve the perfomance?
  2007-09-07 12:56 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: DRBD and Postgres: how to improve the perfomance?
  2007-09-07 19:00 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: DRBD and Postgres: how to improve the perfomance?
  2007-09-07 21:54 UTC  Bernd Helmle <mailings@oopsware.de>
` Re: DRBD and Postgres: how to improve the perfomance?
  2007-09-08 06:28 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: DRBD and Postgres: how to improve the perfomance?
  2007-09-08 10:04 UTC  Gregory Stark <stark@enterprisedb.com>
` Re: DRBD and Postgres: how to improve the perfomance?
  2007-09-08 16:15 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: DRBD and Postgres: how to improve the perfomance?
  2007-09-08 16:33 UTC  Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>
` Re: DRBD and Postgres: how to improve the perfomance?
  2007-09-08 16:39 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: DRBD and Postgres: how to improve the perfomance?
  2007-09-08 16:49 UTC  Gregory Stark <stark@enterprisedb.com>
` Re: DRBD and Postgres: how to improve the perfomance?
  2007-09-08 16:53 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: DRBD and Postgres: how to improve the perfomance?
  2007-09-08 17:02 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: DRBD and Postgres: how to improve the perfomance?
  2007-09-08 17:25 UTC  Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>
` Re: DRBD and Postgres: how to improve the perfomance?
  2007-09-08 17:32 UTC  Gregory Stark <stark@enterprisedb.com>
` Re: DRBD and Postgres: how to improve the perfomance?
  2007-09-08 18:22 UTC  Bernd Helmle <mailings@oopsware.de>
` Re: DRBD and Postgres: how to improve the perfomance?
  2007-09-08 21:25 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: DRBD and Postgres: how to improve the perfomance?
  2007-09-08 21:30 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: DRBD and Postgres: how to improve the perfomance?
  2007-09-10 04:06 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: DRBD and Postgres: how to improve the perfomance?
  2007-09-10 04:54 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: DRBD and Postgres: how to improve the perfomance?
  2007-09-11 14:47 UTC  Maila Fatticcioni <mfatticcioni@mbigroup.it>
` Re: DRBD and Postgres: how to improve the perfomance?
  2007-09-11 14:57 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: DRBD and Postgres: how to improve the perfomance?
  2007-09-11 18:26 UTC  Mario Weilguni <mweilguni@sime.com>
` Re: DRBD and Postgres: how to improve the perfomance?
  2007-09-11 21:12 UTC  Decibel! <decibel@decibel.org>
` Re: DRBD and Postgres: how to improve the perfomance?
  2007-09-11 21:20 UTC  Decibel! <decibel@decibel.org>
` Re: DRBD and Postgres: how to improve the perfomance?
  2007-09-11 21:22 UTC  Decibel! <decibel@decibel.org>
` Re: DRBD and Postgres: how to improve the perfomance?
  2007-09-12 02:28 UTC  Jean-David Beyer <jeandavid8@verizon.net>
` Re: DRBD and Postgres: how to improve the perfomance?
  2007-09-17 15:19 UTC  Markus Schiltknecht <markus@bluegap.ch>
  [28+ messages in thread]

DELETE queries slow down
  2007-09-17 07:48 UTC  Galantucci Giovanni <Giovanni.Galantucci@italtel.it>
` Re: DELETE queries slow down
  2007-09-17 09:18 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
` Re: DELETE queries slow down
  2007-09-17 10:21 UTC  Gregory Stark <stark@enterprisedb.com>
  [3+ messages in thread]

random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1
  2007-09-10 19:25 UTC  Carlo Stonebanks <stonec.register@sympatico.ca>
` Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1
  2007-09-10 20:19 UTC  Luke Lonergan <llonergan@greenplum.com>
` Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1
  2007-09-10 20:52 UTC  Mark Mielke <mark@mark.mielke.cc>
` Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1
  2007-09-10 21:26 UTC  Josh Berkus <josh@agliodbs.com>
` Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1
  2007-09-10 21:44 UTC  Gregory Stark <stark@enterprisedb.com>
` Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1
  2007-09-10 21:59 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1
  2007-09-10 22:03 UTC  Jeff Davis <pgsql@j-davis.com>
` Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1
  2007-09-10 22:08 UTC  Mark Mielke <mark@mark.mielke.cc>
` Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1
  2007-09-10 22:22 UTC  Mark Mielke <mark@mark.mielke.cc>
` Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1
  2007-09-10 22:45 UTC  Luke Lonergan <llonergan@greenplum.com>
` Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1
  2007-09-10 22:46 UTC  Luke Lonergan <llonergan@greenplum.com>
` Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1
  2007-09-11 07:28 UTC  Gregory Stark <stark@enterprisedb.com>
` Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1
  2007-09-11 07:33 UTC  Luke Lonergan <LLonergan@greenplum.com>
` Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1
  2007-09-11 09:00 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
` Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1
  2007-09-11 11:07 UTC  Jean-David Beyer <jeandavid8@verizon.net>
` Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1
  2007-09-11 18:16 UTC  Gregory Stark <stark@enterprisedb.com>
` Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1
  2007-09-11 18:49 UTC  Jean-David Beyer <jeandavid8@verizon.net>
` Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1
  2007-09-11 21:26 UTC  Decibel! <decibel@decibel.org>
` Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1
  2007-09-11 21:31 UTC  Decibel! <decibel@decibel.org>
` Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1
  2007-09-11 21:50 UTC  Mark Mielke <mark@mark.mielke.cc>
` Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1
  2007-09-11 23:02 UTC  Gregory Stark <stark@enterprisedb.com>
` Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1
  2007-09-11 23:49 UTC  Decibel! <decibel@decibel.org>
` Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1
  2007-09-12 00:10 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1
  2007-09-12 00:46 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1
  2007-09-12 18:01 UTC  Rafael Barrera Oro <rafael@akyasociados.com.ar>
` Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1
  2007-09-13 17:46 UTC  Gregory Stark <stark@enterprisedb.com>
` Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1
  2007-09-16 20:00 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
  [27+ messages in thread]

Index files
  2007-09-14 02:50 UTC  Harsh Azad <harsh.azad@gmail.com>
` Re: Index files
  2007-09-14 02:57 UTC  Ow Mun Heng <Ow.Mun.Heng@wdc.com>
` Re: Index files
  2007-09-14 03:03 UTC  Harsh Azad <harsh.azad@gmail.com>
` Re: Index files
  2007-09-14 03:09 UTC  Ow Mun Heng <Ow.Mun.Heng@wdc.com>
` Re: Index files
  2007-09-14 03:33 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Index files
  2007-09-14 08:34 UTC  Philippe Amelant <pamelant@companeo.com>
` Re: Index files
  2007-09-14 13:22 UTC  Jean-David Beyer <jeandavid8@verizon.net>
` Re: Index files
  2007-09-14 20:21 UTC  Harsh Azad <harsh.azad@gmail.com>
` Re: Index files
  2007-09-14 20:25 UTC  Mark Lewis <mark.lewis@mir3.com>
` Re: Index files
  2007-09-14 20:29 UTC  Alan Hodgson <ahodgson@simkin.ca>
  [10+ messages in thread]

Long Running Commits - Not Checkpoints
  2007-09-13 14:15 UTC  Brad Nicholson <bnichols@ca.afilias.info>
` Re: Long Running Commits - Not Checkpoints
  2007-09-13 15:03 UTC  Brad Nicholson <bnichols@ca.afilias.info>
` Re: Long Running Commits - Not Checkpoints
  2007-09-13 15:10 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Long Running Commits - Not Checkpoints
  2007-09-13 15:35 UTC  Brad Nicholson <bnichols@ca.afilias.info>
` Re: Long Running Commits - Not Checkpoints
  2007-09-13 16:12 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: Long Running Commits - Not Checkpoints
  2007-09-13 16:19 UTC  Brad Nicholson <bnichols@ca.afilias.info>
` Re: Long Running Commits - Not Checkpoints
  2007-09-13 16:52 UTC  Brad Nicholson <bnichols@ca.afilias.info>
` Re: Long Running Commits - Not Checkpoints
  2007-09-13 17:07 UTC  Alvaro Herrera <alvherre@commandprompt.com>
` Re: Long Running Commits - Not Checkpoints
  2007-09-13 17:58 UTC  Brad Nicholson <bnichols@ca.afilias.info>
` Re: Long Running Commits - Not Checkpoints
  2007-09-13 18:42 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: Long Running Commits - Not Checkpoints
  2007-09-14 07:02 UTC  Peter Childs <peterachilds@gmail.com>
` Re: Long Running Commits - Not Checkpoints
  2007-09-14 07:42 UTC  Peter Childs <peterachilds@gmail.com>
` Re: Long Running Commits - Not Checkpoints
  2007-09-14 11:31 UTC  db@zigo.dhs.org
` Re: Long Running Commits - Not Checkpoints
  2007-09-14 16:22 UTC  Greg Smith <gsmith@gregsmith.com>
  [14+ messages in thread]

500rows = 1min/2.5k rows=20min/6K rows 2 hours and still running
  2007-09-11 16:57 UTC  El-Lotso <el.lotso@gmail.com>
` Re: 500rows = 1min/2.5k rows=20min/6K rows 2 hours and still running
  2007-09-11 17:02 UTC  El-Lotso <el.lotso@gmail.com>
` Re: Re: 500rows = 1min/2.5k rows=20min/6K rows 2 hours and still running
  2007-09-11 18:23 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Re: 500rows = 1min/2.5k rows=20min/6K rows 2 hours and still running
  2007-09-12 02:15 UTC  El-Lotso <el.lotso@gmail.com>
` Re: Re: 500rows = 1min/2.5k rows=20min/6K rows 2 hours and still running
  2007-09-12 02:48 UTC  El-Lotso <el.lotso@gmail.com>
` Re: Re: 500rows = 1min/2.5k rows=20min/6K rows 2 hours and still running
  2007-09-12 08:09 UTC  El-Lotso <el.lotso@gmail.com>
` Re: 500rows = 1min/2.5k rows=20min/6K rows 2 hours and still running
  2007-09-12 13:14 UTC  Nis Jørgensen <nis@superlativ.dk>
` Re: Re: 500rows = 1min/2.5k rows=20min/6K rows 2 hours and still running
  2007-09-12 14:41 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Re: 500rows = 1min/2.5k rows=20min/6K rows 2 hours and still running
  2007-09-14 05:51 UTC  El-Lotso <el.lotso@gmail.com>
` Re: 500rows = 1min/2.5k rows=20min/6K rows 2 hours   and still running
  2007-09-14 06:30 UTC  Ow Mun Heng <Ow.Mun.Heng@wdc.com>
  [10+ messages in thread]

When/if to Reindex
  2007-07-18 17:08 UTC  Steven Flatt <steven.flatt@gmail.com>
` Re: When/if to Reindex
  2007-07-18 18:52 UTC  Jim C. Nasby <decibel@decibel.org>
` Re: When/if to Reindex
  2007-08-08 17:42 UTC  Vivek Khera <vivek@khera.org>
` Re: When/if to Reindex
  2007-08-08 19:12 UTC  Steven Flatt <steven.flatt@gmail.com>
` Re: When/if to Reindex
  2007-08-08 19:27 UTC  Bill Moran <wmoran@collaborativefusion.com>
` Re: When/if to Reindex
  2007-08-08 20:35 UTC  Decibel! <decibel@decibel.org>
` Re: When/if to Reindex
  2007-08-09 01:51 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: When/if to Reindex
  2007-08-09 13:04 UTC  Bill Moran <wmoran@collaborativefusion.com>
` Re: When/if to Reindex
  2007-08-09 13:51 UTC  Steven Flatt <steven.flatt@gmail.com>
` Re: When/if to Reindex
  2007-08-22 16:55 UTC  Steven Flatt <steven.flatt@gmail.com>
` Re: When/if to Reindex
  2007-08-22 23:50 UTC  Gregory Stark <stark@enterprisedb.com>
` Re: When/if to Reindex
  2007-08-23 22:25 UTC  Steven Flatt <steven.flatt@gmail.com>
` Re: When/if to Reindex
  2007-08-24 03:59 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: When/if to Reindex
  2007-08-24 05:11 UTC  Mark Kirkwood <markir@paradise.net.nz>
` Re: When/if to Reindex
  2007-08-24 06:49 UTC  Gregory Stark <stark@enterprisedb.com>
` Re: When/if to Reindex
  2007-08-24 14:22 UTC  Steven Flatt <steven.flatt@gmail.com>
` Re: When/if to Reindex
  2007-08-24 16:15 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: When/if to Reindex
  2007-08-24 16:56 UTC  Steven Flatt <steven.flatt@gmail.com>
` Re: When/if to Reindex
  2007-08-24 17:28 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: When/if to Reindex
  2007-08-24 17:49 UTC  Steven Flatt <steven.flatt@gmail.com>
` Re: When/if to Reindex
  2007-08-24 20:06 UTC  Gregory Stark <stark@enterprisedb.com>
` Re: When/if to Reindex
  2007-08-24 21:43 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: When/if to Reindex
  2007-09-14 04:23 UTC  Bruce Momjian <bruce@momjian.us>
  [23+ 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