Mailing List Archive For pgsql-performance@postgresql.org Sep 2007 By Thread

• [PERFORM] Non-blocking vacuum full Peter Schuller (Fri Sep 28 2007 - 14:06:50 EDT)
  • Re: [PERFORM] Non-blocking vacuum full Heikki Linnakangas (Fri Sep 28 2007 - 15:31:33 EDT)
    • Re: [PERFORM] Non-blocking vacuum full Ron Mayer (Fri Sep 28 2007 - 22:46:28 EDT)
      • Re: [PERFORM] Non-blocking vacuum full Heikki Linnakangas (Sat Sep 29 2007 - 04:05:18 EDT)
• [PERFORM] OOM Errors as a result of table inheritance and a bad plan(?) Arctic Toucan (Fri Sep 28 2007 - 13:50:32 EDT)
  • Re: [PERFORM] OOM Errors as a result of table inheritance and a bad plan(?) Tom Lane (Fri Sep 28 2007 - 16:56:49 EDT)
• [PERFORM] Postgres 7.4.2 hanging when vacuum full is run Radhika S (Fri Sep 28 2007 - 10:28:03 EDT)
  • Re: [PERFORM] Postgres 7.4.2 hanging when vacuum full is run Vivek Khera (Fri Sep 28 2007 - 10:53:20 EDT)
  • Re: [PERFORM] Postgres 7.4.2 hanging when vacuum full is run Scott Marlowe (Fri Sep 28 2007 - 11:28:39 EDT)
• [PERFORM] sequence query performance issues Peter Koczan (Thu Sep 27 2007 - 18:04:35 EDT)
  • Re: [PERFORM] sequence query performance issues Richard Huxton (Fri Sep 28 2007 - 04:06:11 EDT)
    • Re: [PERFORM] sequence query performance issues Tom Lane (Fri Sep 28 2007 - 10:16:19 EDT)
      • Re: [PERFORM] sequence query performance issues Richard Huxton (Fri Sep 28 2007 - 10:43:41 EDT)
      • Re: [PERFORM] sequence query performance issues Peter Koczan (Fri Sep 28 2007 - 13:33:35 EDT)
• [PERFORM] Tuning for warm standby Kevin Kempter (Thu Sep 27 2007 - 13:42:06 EDT)
  • Re: [PERFORM] Tuning for warm standby Merlin Moncure (Fri Sep 28 2007 - 09:17:51 EDT)
• [PERFORM] Difference in query plan when using = or > in where clause Radhika S (Wed Sep 26 2007 - 14:00:42 EDT)
  • Re: [PERFORM] Difference in query plan when using = or > in where clause Heikki Linnakangas (Thu Sep 27 2007 - 08:39:07 EDT)
• [PERFORM] Incorrect row estimates in plan? pgdba (Wed Sep 26 2007 - 10:22:45 EDT)
  • Re: [PERFORM] Incorrect row estimates in plan? Tom Lane (Wed Sep 26 2007 - 10:45:14 EDT)
    • Re: [PERFORM] Incorrect row estimates in plan? pgdba (Wed Sep 26 2007 - 11:24:01 EDT)
      • Re: [PERFORM] Incorrect row estimates in plan? Tom Lane (Wed Sep 26 2007 - 12:38:09 EDT)
      • Re: [PERFORM] Incorrect row estimates in plan? pgdba (Wed Sep 26 2007 - 12:56:33 EDT)
• Re: [PERFORM] Effects of cascading references in foreign keys Bruce Momjian (Wed Sep 26 2007 - 04:21:12 EDT)
• [PERFORM] Attempting to disable count triggers on cleanup Dave Cramer (Tue Sep 25 2007 - 07:08:42 EDT)
  • Re: [PERFORM] Attempting to disable count triggers on cleanup hubert depesz lubaczewski (Tue Sep 25 2007 - 07:21:49 EDT)
    • Re: [PERFORM] Attempting to disable count triggers on cleanup Dave Cramer (Tue Sep 25 2007 - 07:39:42 EDT)
• [PERFORM] Acceptable level of over-estimation? Carlo Stonebanks (Mon Sep 24 2007 - 15:37:41 EDT)
  • Re: [PERFORM] Acceptable level of over-estimation? Gregory Stark (Mon Sep 24 2007 - 16:18:25 EDT)
• [PERFORM] TEXT or LONGTEXT? Fabiola Fernández (Mon Sep 24 2007 - 11:21:25 EDT)
  • Re: [PERFORM] TEXT or LONGTEXT? Alexander Staubo (Mon Sep 24 2007 - 11:29:48 EDT)
  • Re: [PERFORM] TEXT or LONGTEXT? Niklas Johansson (Mon Sep 24 2007 - 12:00:29 EDT)
• [PERFORM] select count(*) performance (vacuum did not help) Gábor Farkas (Mon Sep 24 2007 - 10:07:16 EDT)
  • Re: [PERFORM] select count(*) performance (vacuum did not help) Pavan Deolasee (Mon Sep 24 2007 - 10:23:49 EDT)
  • Re: [PERFORM] select count(*) performance (vacuum did not help) Heikki Linnakangas (Mon Sep 24 2007 - 10:30:09 EDT)
    • Re: [PERFORM] select count(*) performance (vacuum did not help) Gábor Farkas (Mon Sep 24 2007 - 11:04:39 EDT)
      • Re: [PERFORM] select count(*) performance (vacuum did not help) Heikki Linnakangas (Mon Sep 24 2007 - 11:07:51 EDT)
      • Re: [PERFORM] select count(*) performance (vacuum did not help) Gábor Farkas (Mon Sep 24 2007 - 11:14:27 EDT)
      • Re: [PERFORM] select count(*) performance (vacuum did not help) Bill Moran (Mon Sep 24 2007 - 11:29:07 EDT)
      • Re: [PERFORM] select count(*) performance (vacuum did not help) Csaba Nagy (Mon Sep 24 2007 - 11:34:16 EDT)
      • Re: [PERFORM] select count(*) performance (vacuum did not help) Dave Dutcher (Mon Sep 24 2007 - 11:37:42 EDT)
• [PERFORM] zero value in statistics collector's result Yinan Li (Sun Sep 23 2007 - 13:00:24 EDT)
• [PERFORM] Possible explanations for catastrophic performace deterioration? Carlos Moreno (Sun Sep 23 2007 - 12:45:15 EDT)
  • Re: [PERFORM] Possible explanations for catastrophic performace deterioration? Jonah H. Harris (Sun Sep 23 2007 - 12:56:35 EDT)
    • Re: [PERFORM] Possible explanations for catastrophic performace deterioration? Tom Lane (Sun Sep 23 2007 - 13:27:35 EDT)
    • Re: [PERFORM] Possible explanations for catastrophic performace deterioration? Carlos Moreno (Sun Sep 23 2007 - 14:15:09 EDT)
      • Re: [PERFORM] Possible explanations for catastrophic performace deterioration? Alvaro Herrera (Sun Sep 23 2007 - 14:23:49 EDT)
      • Re: [PERFORM] Possible explanations for catastrophic performace deterioration? Carlos Moreno (Sun Sep 23 2007 - 15:12:02 EDT)
      • Re: [PERFORM] Possible explanations for catastrophic performace deterioration? Jonah H. Harris (Sun Sep 23 2007 - 15:24:10 EDT)
      • Re: [PERFORM] Possible explanations for catastrophic performance deterioration? Carlos Moreno (Sun Sep 23 2007 - 16:33:30 EDT)
      • Re: [PERFORM] Possible explanations for catastrophic performance deterioration? Alvaro Herrera (Sun Sep 23 2007 - 16:57:59 EDT)
      • Re: [PERFORM] Possible explanations for catastrophic performance deterioration? Carlos Moreno (Sun Sep 23 2007 - 17:55:49 EDT)
      • Re: [PERFORM] Possible explanations for catastrophic performance deterioration? Jonah H. Harris (Sun Sep 23 2007 - 18:29:02 EDT)
      • Re: [PERFORM] Possible explanations for catastrophic performance deterioration? Gregory Stark (Sun Sep 23 2007 - 19:05:31 EDT)
• [PERFORM] Query planner unaware of possibly best plan Denes Daniel (Fri Sep 21 2007 - 11:36:25 EDT)
  • Re: [PERFORM] Query planner unaware of possibly best plan Simon Riggs (Fri Sep 21 2007 - 13:49:33 EDT)
    • Re: [PERFORM] Query planner unaware of possibly best plan Denes Daniel (Fri Sep 21 2007 - 15:29:55 EDT)
      • Re: [PERFORM] Query planner unaware of possibly best plan Alvaro Herrera (Fri Sep 21 2007 - 15:56:44 EDT)
      • Re: [PERFORM] Query planner unaware of possibly best plan Denes Daniel (Fri Sep 21 2007 - 16:05:29 EDT)
  • Re: [PERFORM] Query planner unaware of possibly best plan Denes Daniel (Fri Sep 21 2007 - 20:08:43 EDT)
    • Re: [PERFORM] Query planner unaware of possibly best plan Tom Lane (Sat Sep 22 2007 - 02:07:28 EDT)
      • Re: [PERFORM] Query planner unaware of possibly best plan Denes Daniel (Sat Sep 22 2007 - 08:33:21 EDT)
• [PERFORM] Searching for the cause of a bad plan Csaba Nagy (Fri Sep 21 2007 - 06:03:44 EDT)
  • Re: [PERFORM] Searching for the cause of a bad plan Simon Riggs (Fri Sep 21 2007 - 06:59:25 EDT)
    • Re: [PERFORM] Searching for the cause of a bad plan Csaba Nagy (Fri Sep 21 2007 - 07:29:26 EDT)
      • Re: [PERFORM] Searching for the cause of a bad plan Simon Riggs (Fri Sep 21 2007 - 07:34:38 EDT)
      • Re: [PERFORM] Searching for the cause of a bad plan Csaba Nagy (Fri Sep 21 2007 - 08:12:24 EDT)
      • Re: [PERFORM] Searching for the cause of a bad plan Simon Riggs (Fri Sep 21 2007 - 09:36:17 EDT)
      • Re: [PERFORM] Searching for the cause of a bad plan Csaba Nagy (Fri Sep 21 2007 - 10:26:39 EDT)
      • Re: [PERFORM] Searching for the cause of a bad plan Csaba Nagy (Fri Sep 21 2007 - 11:48:09 EDT)
      • Re: [PERFORM] Searching for the cause of a bad plan Simon Riggs (Fri Sep 21 2007 - 13:18:09 EDT)
  • Re: [PERFORM] Searching for the cause of a bad plan Tom Lane (Fri Sep 21 2007 - 12:08:33 EDT)
    • Re: [PERFORM] Searching for the cause of a bad plan Simon Riggs (Fri Sep 21 2007 - 13:39:12 EDT)
      • Re: [PERFORM] Searching for the cause of a bad plan Tom Lane (Fri Sep 21 2007 - 13:53:40 EDT)
      • Re: [PERFORM] Searching for the cause of a bad plan Simon Riggs (Fri Sep 21 2007 - 14:37:59 EDT)
      • Re: [PERFORM] Searching for the cause of a bad plan Tom Lane (Fri Sep 21 2007 - 19:30:34 EDT)
      • Re: [PERFORM] Searching for the cause of a bad plan Simon Riggs (Mon Sep 24 2007 - 09:27:09 EDT)
      • Re: [PERFORM] Searching for the cause of a bad plan Csaba Nagy (Mon Sep 24 2007 - 10:04:42 EDT)
      • Re: [PERFORM] Searching for the cause of a bad plan Simon Riggs (Mon Sep 24 2007 - 13:55:22 EDT)
      • Re: [PERFORM] Searching for the cause of a bad plan Csaba Nagy (Wed Sep 26 2007 - 10:52:37 EDT)
      • Re: [PERFORM] Searching for the cause of a bad plan Tom Lane (Wed Sep 26 2007 - 11:22:17 EDT)
      • Re: [PERFORM] Searching for the cause of a bad plan Csaba Nagy (Thu Sep 27 2007 - 07:53:24 EDT)
      • Re: [PERFORM] Searching for the cause of a bad plan Tom Lane (Thu Sep 27 2007 - 10:40:25 EDT)
      • Re: [PERFORM] Searching for the cause of a bad plan Csaba Nagy (Thu Sep 27 2007 - 11:16:06 EDT)
      • Re: [PERFORM] Searching for the cause of a bad plan Ron Mayer (Thu Sep 27 2007 - 14:07:48 EDT)
      • Re: [PERFORM] Searching for the cause of a bad plan Csaba Nagy (Fri Sep 28 2007 - 04:12:10 EDT)
      • Re: [PERFORM] Searching for the cause of a bad plan Simon Riggs (Thu Sep 27 2007 - 11:24:37 EDT)
  • Re: [PERFORM] Searching for the cause of a bad plan Csaba Nagy (Fri Sep 28 2007 - 08:33:52 EDT)
• [PERFORM] Linux mis-reporting memory Decibel! (Thu Sep 20 2007 - 19:04:01 EDT)
  • Re: [PERFORM] Linux mis-reporting memory Tom Lane (Thu Sep 20 2007 - 19:12:14 EDT)
    • Re: [PERFORM] Linux mis-reporting memory Gregory Stark (Fri Sep 21 2007 - 04:03:04 EDT)
      • Re: [PERFORM] Linux mis-reporting memory Csaba Nagy (Fri Sep 21 2007 - 04:30:01 EDT)
      • Re: [PERFORM] Linux mis-reporting memory Gregory Stark (Fri Sep 21 2007 - 05:43:07 EDT)
      • Re: [PERFORM] Linux mis-reporting memory Csaba Nagy (Fri Sep 21 2007 - 06:08:45 EDT)
      • Re: [PERFORM] Linux mis-reporting memory Heikki Linnakangas (Fri Sep 21 2007 - 06:34:53 EDT)
      • Re: [PERFORM] Linux mis-reporting memory Csaba Nagy (Fri Sep 21 2007 - 07:34:22 EDT)
      • Re: [PERFORM] Linux mis-reporting memory Simon Riggs (Fri Sep 21 2007 - 07:01:18 EDT)
  • Re: [PERFORM] Linux mis-reporting memory Adam Tauno Williams (Thu Sep 20 2007 - 20:22:36 EDT)
  • Re: [PERFORM] Linux mis-reporting memory Dimitri Fontaine (Fri Sep 21 2007 - 05:48:50 EDT)
  • Re: [PERFORM] Linux mis-reporting memory Greg Smith (Fri Sep 21 2007 - 15:24:06 EDT)
• [PERFORM] query io stats and finding a slow query Kamen Stanev (Thu Sep 20 2007 - 17:36:59 EDT)
  • Re: [PERFORM] query io stats and finding a slow query Kevin Grittner (Fri Sep 21 2007 - 12:35:15 EDT)
    • Re: [PERFORM] query io stats and finding a slow query Kamen Stanev (Tue Sep 25 2007 - 15:41:03 EDT)
      • Re: [PERFORM] query io stats and finding a slow query Bryan Murphy (Tue Sep 25 2007 - 15:58:53 EDT)
• [PERFORM] Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! smiley2211 (Thu Sep 20 2007 - 15:10:23 EDT)
  • Re: [PERFORM] Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! Carlos Moreno (Thu Sep 20 2007 - 15:34:58 EDT)
    • Re: [PERFORM] Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! smiley2211 (Thu Sep 20 2007 - 16:32:07 EDT)
      • Re: [PERFORM] Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! Scott Marlowe (Thu Sep 20 2007 - 17:25:19 EDT)
      • Re: [PERFORM] Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! Scott Marlowe (Thu Sep 20 2007 - 17:25:42 EDT)
      • Re: [PERFORM] Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! smiley2211 (Thu Sep 20 2007 - 19:25:43 EDT)
      • Re: [PERFORM] Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! Scott Marlowe (Thu Sep 20 2007 - 20:52:52 EDT)
      • Re: [PERFORM] Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! smiley2211 (Thu Sep 20 2007 - 23:25:44 EDT)
  • Re: [PERFORM] Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! db(at)zigo.dhs.org (Fri Sep 21 2007 - 01:58:27 EDT)
    • Re: [PERFORM] Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! smiley2211 (Fri Sep 21 2007 - 09:14:22 EDT)
      • Re: [PERFORM] Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! Bill Moran (Fri Sep 21 2007 - 09:25:30 EDT)
      • Re: [PERFORM] Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! Dave Dutcher (Fri Sep 21 2007 - 10:07:49 EDT)
  • Re: [PERFORM] Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! Jeff Harris (Fri Sep 21 2007 - 09:28:46 EDT)
• [PERFORM] REPOST: Performance improves only after repeated VACUUM/ANALYZE Carlo Stonebanks (Thu Sep 20 2007 - 10:59:54 EDT)
• [PERFORM] REPOST: Nested loops row estimates always too high Carlo Stonebanks (Thu Sep 20 2007 - 11:02:55 EDT)
  • Re: [PERFORM] REPOST: Nested loops row estimates always too high Ow Mun Heng (Mon Sep 24 2007 - 02:46:16 EDT)
    • Re: [PERFORM] REPOST: Nested loops row estimates always too high Carlo Stonebanks (Mon Sep 24 2007 - 14:12:01 EDT)
      • Re: [PERFORM] REPOST: Nested loops row estimates always too high Ow Mun Heng (Mon Sep 24 2007 - 20:50:40 EDT)
      • Re: [PERFORM] REPOST: Nested loops row estimates always too high Carlo Stonebanks (Tue Sep 25 2007 - 00:53:55 EDT)
      • Re: [PERFORM] REPOST: Nested loops row estimates always too high Ow Mun Heng (Tue Sep 25 2007 - 01:15:58 EDT)
      • Re: [PERFORM] REPOST: Nested loops row estimates always too high Steinar H. Gunderson (Tue Sep 25 2007 - 05:31:33 EDT)
      • Re: [PERFORM] REPOST: Nested loops row estimates always too high Ow Mun Heng (Tue Sep 25 2007 - 23:50:46 EDT)
      • Re: [PERFORM] REPOST: Nested loops row estimates always too high Tom Lane (Wed Sep 26 2007 - 00:02:58 EDT)
      • Re: [PERFORM] REPOST: Nested loops row estimates always too high Ow Mun Heng (Thu Sep 27 2007 - 02:59:13 EDT)
• [PERFORM] Low CPU Usage brauagustin-susc(at)yahoo.com.ar (Wed Sep 19 2007 - 13:38:13 EDT)
  • Re: [PERFORM] Low CPU Usage Heikki Linnakangas (Wed Sep 19 2007 - 13:52:51 EDT)
  • Re: [PERFORM] Low CPU Usage Mark Lewis (Wed Sep 19 2007 - 14:03:06 EDT)
  • Re: [PERFORM] Low CPU Usage brauagustin-susc(at)yahoo.com.ar (Wed Sep 19 2007 - 15:13:33 EDT)
    • Re: [PERFORM] Low CPU Usage Scott Marlowe (Wed Sep 19 2007 - 15:41:45 EDT)
  • Re: [PERFORM] Low CPU Usage brauagustin-susc(at)yahoo.com.ar (Wed Sep 19 2007 - 15:52:43 EDT)
    • Re: [PERFORM] Low CPU Usage Scott Marlowe (Wed Sep 19 2007 - 16:15:34 EDT)
  • Re: [PERFORM] Low CPU Usage brauagustin-susc(at)yahoo.com.ar (Thu Sep 20 2007 - 07:30:53 EDT)
    • Re: [PERFORM] Low CPU Usage Jean-David Beyer (Thu Sep 20 2007 - 08:31:36 EDT)
  • Re: [PERFORM] Low CPU Usage brauagustin-susc(at)yahoo.com.ar (Thu Sep 20 2007 - 13:28:37 EDT)
    • Re: [PERFORM] Low CPU Usage Greg Smith (Sat Sep 22 2007 - 02:29:17 EDT)
  • Re: [PERFORM] Low CPU Usage brauagustin-susc(at)yahoo.com.ar (Fri Sep 21 2007 - 13:30:45 EDT)
    • Re: [PERFORM] Low CPU Usage Kevin Grittner (Fri Sep 21 2007 - 13:51:57 EDT)
  • Re: [PERFORM] Low CPU Usage brauagustin-susc(at)yahoo.com.ar (Fri Sep 21 2007 - 13:51:57 EDT)
  • Re: [PERFORM] Low CPU Usage brauagustin-susc(at)yahoo.com.ar (Fri Sep 21 2007 - 14:20:30 EDT)
    • Re: [PERFORM] Low CPU Usage Bill Moran (Fri Sep 21 2007 - 14:33:54 EDT)
  • Re: [PERFORM] Low CPU Usage brauagustin-susc(at)yahoo.com.ar (Fri Sep 21 2007 - 15:01:34 EDT)
    • Re: [PERFORM] Low CPU Usage Bill Moran (Fri Sep 21 2007 - 15:11:38 EDT)
  • Re: [PERFORM] Low CPU Usage brauagustin-susc(at)yahoo.com.ar (Fri Sep 21 2007 - 15:33:46 EDT)
    • Re: [PERFORM] Low CPU Usage Luiz K. Matsumura (Fri Sep 21 2007 - 16:40:52 EDT)
      • Re: [PERFORM] Low CPU Usage Kevin Grittner (Fri Sep 21 2007 - 16:57:34 EDT)
      • Re: [PERFORM] Low CPU Usage Craig James (Fri Sep 21 2007 - 17:15:40 EDT)
    • Re: [PERFORM] Low CPU Usage Dave Dutcher (Fri Sep 21 2007 - 16:55:36 EDT)
  • Re: [PERFORM] Low CPU Usage brauagustin-susc(at)yahoo.com.ar (Fri Sep 21 2007 - 17:45:27 EDT)
  • Re: [PERFORM] Low CPU Usage brauagustin-susc(at)yahoo.com.ar (Mon Sep 24 2007 - 09:59:26 EDT)
  • Re: [PERFORM] Low CPU Usage brauagustin-susc(at)yahoo.com.ar (Mon Sep 24 2007 - 10:16:38 EDT)
• [PERFORM] Tablespaces and NFS Carlos Moreno (Wed Sep 19 2007 - 11:58:18 EDT)
  • Re: [PERFORM] Tablespaces and NFS Craig James (Wed Sep 19 2007 - 16:49:51 EDT)
  • Re: [PERFORM] Tablespaces and NFS Peter Koczan (Wed Sep 19 2007 - 17:54:22 EDT)
    • Re: [PERFORM] Tablespaces and NFS Carlos Moreno (Thu Sep 20 2007 - 09:20:40 EDT)
      • Re: [PERFORM] Tablespaces and NFS Peter Koczan (Thu Sep 20 2007 - 14:50:21 EDT)
      • Re: [PERFORM] Tablespaces and NFS Carlos Moreno (Thu Sep 20 2007 - 15:24:39 EDT)
• [PERFORM] Query works when kludged, but would prefer "best practice" solution Carlo Stonebanks (Mon Sep 17 2007 - 16:22:50 EDT)
  • Re: [PERFORM] Query works when kludged, but would prefer "best practice" solution Merlin Moncure (Mon Sep 17 2007 - 20:03:19 EDT)
    • Re: [PERFORM] Query works when kludged, but would prefer "best practice" solution Carlo Stonebanks (Mon Sep 17 2007 - 20:13:18 EDT)
      • Re: [PERFORM] Query works when kludged, but would prefer "best practice" solution Merlin Moncure (Mon Sep 17 2007 - 20:17:49 EDT)
      • Re: [PERFORM] Query works when kludged, but would prefer "best practice" solution Carlo Stonebanks (Mon Sep 17 2007 - 20:38:58 EDT)
    • Re: [PERFORM] Query works when kludged, but would prefer "best practice" solution Tom Lane (Mon Sep 17 2007 - 23:29:51 EDT)
      • Re: [PERFORM] Query works when kludged, but would prefer "best practice" solution Carlo Stonebanks (Tue Sep 18 2007 - 02:29:17 EDT)
      • Re: [PERFORM] Query works when kludged, but would prefer "best practice" solution Tom Lane (Tue Sep 18 2007 - 10:08:39 EDT)
      • Re: [PERFORM] Query works when kludged, but would prefer "best practice" solution Dave Dutcher (Tue Sep 18 2007 - 10:11:27 EDT)
      • [PERFORM] Performance improves only after repeated VACUUM/ANALYZE Carlo Stonebanks (Tue Sep 18 2007 - 15:59:44 EDT)
      • [PERFORM] Nested loops row estimates always too high Carlo Stonebanks (Tue Sep 18 2007 - 16:07:33 EDT)
• [PERFORM] DELETE queries slow down Galantucci Giovanni (Mon Sep 17 2007 - 03:48:09 EDT)
  • Re: [PERFORM] DELETE queries slow down Heikki Linnakangas (Mon Sep 17 2007 - 05:18:46 EDT)
    • Re: [PERFORM] DELETE queries slow down Gregory Stark (Mon Sep 17 2007 - 06:21:44 EDT)
      • [PERFORM] R: DELETE queries slow down Galantucci Giovanni (Tue Sep 18 2007 - 03:17:01 EDT)
      • Re: [PERFORM] R: DELETE queries slow down Bill Moran (Tue Sep 18 2007 - 12:18:45 EDT)
      • R: [PERFORM] R: DELETE queries slow down Galantucci Giovanni (Wed Sep 19 2007 - 05:46:48 EDT)
      • Re: R: [PERFORM] R: DELETE queries slow down Bill Moran (Wed Sep 19 2007 - 07:14:51 EDT)
      • Re: R: [PERFORM] R: DELETE queries slow down Gregory Williamson (Wed Sep 19 2007 - 07:25:29 EDT)
• [PERFORM] Regarding COPY command from Postgres 8.2.0 soni de (Fri Sep 14 2007 - 06:21:51 EDT)
  • Re: [PERFORM] Regarding COPY command from Postgres 8.2.0 Ansgar -59cobalt- Wiechers (Fri Sep 14 2007 - 08:03:21 EDT)
    • Re: [PERFORM] Regarding COPY command from Postgres 8.2.0 soni de (Tue Sep 18 2007 - 00:31:46 EDT)
      • Re: [PERFORM] Regarding COPY command from Postgres 8.2.0 Evan Carroll (Tue Sep 18 2007 - 10:53:28 EDT)
      • Re: [PERFORM] Regarding COPY command from Postgres 8.2.0 Scott Marlowe (Tue Sep 18 2007 - 11:04:52 EDT)
• [PERFORM] Index files Harsh Azad (Thu Sep 13 2007 - 22:50:17 EDT)
  • Re: [PERFORM] Index files Ow Mun Heng (Thu Sep 13 2007 - 22:57:24 EDT)
    • Re: [PERFORM] Index files Harsh Azad (Thu Sep 13 2007 - 23:03:12 EDT)
      • Re: [PERFORM] Index files Ow Mun Heng (Thu Sep 13 2007 - 23:09:49 EDT)
      • Re: [PERFORM] Index files Philippe Amelant (Fri Sep 14 2007 - 04:34:13 EDT)
  • Re: [PERFORM] Index files Tom Lane (Thu Sep 13 2007 - 23:33:23 EDT)
  • Re: [PERFORM] Index files Jean-David Beyer (Fri Sep 14 2007 - 09:22:08 EDT)
    • Re: [PERFORM] Index files Harsh Azad (Fri Sep 14 2007 - 16:21:06 EDT)
      • Re: [PERFORM] Index files Mark Lewis (Fri Sep 14 2007 - 16:25:51 EDT)
      • Re: [PERFORM] Index files Alan Hodgson (Fri Sep 14 2007 - 16:29:01 EDT)
• [PERFORM] Long Running Commits - Not Checkpoints Brad Nicholson (Thu Sep 13 2007 - 10:15:15 EDT)
  • Re: [PERFORM] Long Running Commits - Not Checkpoints Brad Nicholson (Thu Sep 13 2007 - 11:03:22 EDT)
    • Re: [PERFORM] Long Running Commits - Not Checkpoints Tom Lane (Thu Sep 13 2007 - 11:10:09 EDT)
      • Re: [PERFORM] Long Running Commits - Not Checkpoints Brad Nicholson (Thu Sep 13 2007 - 11:35:59 EDT)
  • Re: [PERFORM] Long Running Commits - Not Checkpoints Greg Smith (Thu Sep 13 2007 - 12:12:06 EDT)
    • Re: [PERFORM] Long Running Commits - Not Checkpoints Brad Nicholson (Thu Sep 13 2007 - 12:19:45 EDT)
      • Re: [PERFORM] Long Running Commits - Not Checkpoints Brad Nicholson (Thu Sep 13 2007 - 12:52:21 EDT)
      • Re: [PERFORM] Long Running Commits - Not Checkpoints Alvaro Herrera (Thu Sep 13 2007 - 13:07:19 EDT)
      • Re: [PERFORM] Long Running Commits - Not Checkpoints Greg Smith (Thu Sep 13 2007 - 14:42:17 EDT)
      • Re: [PERFORM] Long Running Commits - Not Checkpoints Peter Childs (Fri Sep 14 2007 - 03:02:23 EDT)
      • Re: [PERFORM] Long Running Commits - Not Checkpoints Peter Childs (Fri Sep 14 2007 - 03:42:59 EDT)
      • Re: [PERFORM] Long Running Commits - Not Checkpoints Greg Smith (Fri Sep 14 2007 - 12:22:03 EDT)
    • Re: [PERFORM] Long Running Commits - Not Checkpoints Brad Nicholson (Thu Sep 13 2007 - 13:58:19 EDT)
  • Re: [PERFORM] Long Running Commits - Not Checkpoints db(at)zigo.dhs.org (Fri Sep 14 2007 - 07:31:45 EDT)
• [PERFORM] Clustered tables improves perfs ? Patrice Castet (Thu Sep 13 2007 - 09:03:54 EDT)
  • Re: [PERFORM] Clustered tables improves perfs ? Alexander Staubo (Thu Sep 13 2007 - 09:31:58 EDT)
  • Re: [PERFORM] Clustered tables improves perfs ? Chris Browne (Thu Sep 13 2007 - 10:49:57 EDT)
• [PERFORM] Index usage when bitwise operator is used W.Alphonse HAROUNY (Thu Sep 13 2007 - 08:30:20 EDT)
  • Re: [PERFORM] Index usage when bitwise operator is used Valentine Gogichashvili (Sun Sep 16 2007 - 06:08:33 EDT)
  • Re: [PERFORM] Index usage when bitwise operator is used Kevin Grittner (Sun Sep 16 2007 - 19:58:21 EDT)
    • Re: [PERFORM] Index usage when bitwise operator is used valgog (Mon Sep 17 2007 - 03:49:28 EDT)
      • Re: [PERFORM] Index usage when bitwise operator is used Kevin Grittner (Mon Sep 17 2007 - 08:27:15 EDT)
      • Re: [PERFORM] Index usage when bitwise operator is used Tom Lane (Mon Sep 17 2007 - 09:37:09 EDT)
      • Re: [PERFORM] Index usage when bitwise operator is used Kevin Grittner (Mon Sep 17 2007 - 10:30:26 EDT)
      • Re: [PERFORM] Index usage when bitwise operator is used W.Alphonse HAROUNY (Mon Sep 17 2007 - 10:40:49 EDT)
      • Re: [PERFORM] Index usage when bitwise operator is used valgog (Tue Sep 18 2007 - 06:36:23 EDT)
  • Re: [PERFORM] Index usage when bitwise operator is used valgog (Mon Sep 17 2007 - 03:47:32 EDT)
• [PERFORM] db performance/design question Matt Chambers (Wed Sep 12 2007 - 16:33:25 EDT)
  • Re: [PERFORM] db performance/design question Scott Marlowe (Wed Sep 12 2007 - 17:58:34 EDT)
• [PERFORM] pg_dump blocking create database? Dan Harris (Wed Sep 12 2007 - 15:58:36 EDT)
  • Re: [PERFORM] pg_dump blocking create database? Tom Lane (Wed Sep 12 2007 - 23:21:13 EDT)
• [PERFORM] efficient pattern queries (using LIKE, ~) Fernan Aguero (Tue Sep 11 2007 - 14:54:42 EDT)
  • Re: [PERFORM] efficient pattern queries (using LIKE, ~) Mario Weilguni (Tue Sep 11 2007 - 15:08:37 EDT)
  • Re: [PERFORM] Re: 500rows = 1min/2.5k rows=20min/6K rows 2 hours and still running Tom Lane (Tue Sep 11 2007 - 14:23:20 EDT)
    • Re: [PERFORM] 500rows = 1min/2.5k rows=20min/6K rows 2 hours and still running Nis Jørgensen (Wed Sep 12 2007 - 09:14:25 EDT)
      • Re: [PERFORM] 500rows = 1min/2.5k rows=20min/6K rows 2 hours and still running Ow Mun Heng (Fri Sep 14 2007 - 02:30:27 EDT)
• Re: [PERFORM] Re: 500rows = 1min/2.5k rows=20min/6K rows 2 hours and still running Tom Lane (Wed Sep 12 2007 - 10:41:16 EDT)
• [PERFORM] More Vacuum questions... Kevin Kempter (Tue Sep 11 2007 - 12:24:58 EDT)
  • Re: [PERFORM] More Vacuum questions... Heikki Linnakangas (Tue Sep 11 2007 - 13:29:08 EDT)
• Re: [PERFORM] More Vacuum questions... Decibel! (Tue Sep 11 2007 - 19:04:21 EDT)
• [PERFORM] Barcelona vs Tigerton Mindaugas (Tue Sep 11 2007 - 03:57:43 EDT)
  • Re: [PERFORM] Barcelona vs Tigerton Luke Lonergan (Tue Sep 11 2007 - 04:31:14 EDT)
  • Re: [PERFORM] Barcelona vs Tigerton Greg Smith (Tue Sep 11 2007 - 11:11:56 EDT)
  • Re: [PERFORM] Barcelona vs Tigerton Guy Rouillier (Tue Sep 11 2007 - 15:52:40 EDT)
    • Re: [PERFORM] Barcelona vs Tigerton Joshua D. Drake (Tue Sep 11 2007 - 15:59:51 EDT)
  • Re: [PERFORM] Barcelona vs Tigerton Decibel! (Tue Sep 11 2007 - 19:00:22 EDT)
• [PERFORM] [Again] Postgres performance problem Ruben Rubio (Tue Sep 11 2007 - 02:33:47 EDT)
  • Re: [PERFORM] [Again] Postgres performance problem db(at)zigo.dhs.org (Tue Sep 11 2007 - 03:31:23 EDT)
    • Re: [PERFORM] [Again] Postgres performance problem Ruben Rubio (Tue Sep 11 2007 - 03:49:37 EDT)
      • Re: [PERFORM] [Again] Postgres performance problem Decibel! (Tue Sep 11 2007 - 18:52:42 EDT)
      • Re: [PERFORM] [Again] Postgres performance problem ruben(at)rentalia.com (Wed Sep 12 2007 - 03:42:29 EDT)
      • Re: [PERFORM] [Again] Postgres performance problem Scott Marlowe (Wed Sep 12 2007 - 14:28:14 EDT)
      • Re: [PERFORM] [Again] Postgres performance problem Brian Hurt (Wed Sep 12 2007 - 14:46:01 EDT)
      • Re: [PERFORM] [Again] Postgres performance problem Mikko Partio (Wed Sep 12 2007 - 14:56:13 EDT)
      • Re: [PERFORM] [Again] Postgres performance problem Scott Marlowe (Wed Sep 12 2007 - 15:07:01 EDT)
      • Re: [PERFORM] [Again] Postgres performance problem Frank Schoep (Wed Sep 12 2007 - 15:19:50 EDT)
      • Re: [PERFORM] [Again] Postgres performance problem Scott Marlowe (Wed Sep 12 2007 - 15:27:14 EDT)
      • Re: [PERFORM] [Again] Postgres performance problem Erik Jones (Wed Sep 12 2007 - 16:01:12 EDT)
      • Re: [PERFORM] [Again] Postgres performance problem Decibel! (Mon Sep 17 2007 - 08:24:14 EDT)
      • Re: [PERFORM] [Again] Postgres performance problem Alvaro Herrera (Wed Sep 12 2007 - 15:40:36 EDT)
      • Re: [PERFORM] [Again] Postgres performance problem Greg Smith (Thu Sep 13 2007 - 01:58:10 EDT)
      • Re: [PERFORM] [Again] Postgres performance problem Scott Marlowe (Thu Sep 13 2007 - 10:29:34 EDT)
      • Re: [PERFORM] [Again] Postgres performance problem Greg Smith (Fri Sep 14 2007 - 03:19:51 EDT)
      • Re: [PERFORM] [Again] Postgres performance problem Erik Jones (Thu Sep 13 2007 - 12:03:20 EDT)
      • Re: [PERFORM] [Again] Postgres performance problem Scott Marlowe (Thu Sep 13 2007 - 12:39:55 EDT)
      • Re: [PERFORM] [Again] Postgres performance problem Adam Tauno Williams (Fri Sep 14 2007 - 10:00:59 EDT)
      • Re: [PERFORM] [Again] Postgres performance problem Decibel! (Mon Sep 17 2007 - 08:27:39 EDT)
      • [OT] Re: [PERFORM] [Again] Postgres performance problem Ow Mun Heng (Mon Sep 24 2007 - 02:58:36 EDT)
  • Re: [PERFORM] [Again] Postgres performance problem Gavin M. Roy (Thu Sep 13 2007 - 11:31:05 EDT)
    • Re: [PERFORM] [Again] Postgres performance problem Ruben Rubio (Mon Sep 17 2007 - 08:00:59 EDT)
• [PERFORM] What to vacuum after deleting lots of tables Craig James (Tue Sep 11 2007 - 00:12:10 EDT)
  • Re: [PERFORM] What to vacuum after deleting lots of tables Tom Lane (Tue Sep 11 2007 - 00:23:11 EDT)
• [PERFORM] random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Carlo Stonebanks (Mon Sep 10 2007 - 15:25:41 EDT)
  • Re: [PERFORM] random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Luke Lonergan (Mon Sep 10 2007 - 16:19:03 EDT)
    • Re: [PERFORM] random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Mark Mielke (Mon Sep 10 2007 - 16:52:56 EDT)
    • Re: [PERFORM] random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Josh Berkus (Mon Sep 10 2007 - 17:26:40 EDT)
      • Re: [PERFORM] random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Luke Lonergan (Mon Sep 10 2007 - 18:46:56 EDT)
    • Re: [PERFORM] random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Gregory Stark (Mon Sep 10 2007 - 17:44:05 EDT)
      • Re: [PERFORM] random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Scott Marlowe (Mon Sep 10 2007 - 17:59:38 EDT)
      • Re: [PERFORM] random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Mark Mielke (Mon Sep 10 2007 - 18:22:06 EDT)
      • Re: [PERFORM] random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Decibel! (Tue Sep 11 2007 - 17:26:34 EDT)
      • Re: [PERFORM] random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Mark Mielke (Tue Sep 11 2007 - 17:50:24 EDT)
      • Re: [PERFORM] random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Jeff Davis (Mon Sep 10 2007 - 18:03:31 EDT)
      • Re: [PERFORM] random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Mark Mielke (Mon Sep 10 2007 - 18:08:26 EDT)
      • Re: [PERFORM] random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Luke Lonergan (Mon Sep 10 2007 - 18:45:26 EDT)
      • Re: [PERFORM] random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Gregory Stark (Tue Sep 11 2007 - 03:28:59 EDT)
      • Re: [PERFORM] random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Luke Lonergan (Tue Sep 11 2007 - 03:33:47 EDT)
      • Re: [PERFORM] random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Jean-David Beyer (Tue Sep 11 2007 - 07:07:02 EDT)
      • Re: [PERFORM] random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Gregory Stark (Tue Sep 11 2007 - 14:16:03 EDT)
      • Re: [PERFORM] random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Jean-David Beyer (Tue Sep 11 2007 - 14:49:28 EDT)
      • Re: [PERFORM] random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Decibel! (Tue Sep 11 2007 - 17:31:05 EDT)
      • Re: [PERFORM] random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Gregory Stark (Tue Sep 11 2007 - 19:02:46 EDT)
      • Re: [PERFORM] random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Decibel! (Tue Sep 11 2007 - 19:49:41 EDT)
      • Re: [PERFORM] random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Greg Smith (Tue Sep 11 2007 - 20:10:50 EDT)
      • Re: [PERFORM] random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Joshua D. Drake (Tue Sep 11 2007 - 20:46:09 EDT)
      • Re: [PERFORM] random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Rafael Barrera Oro (Wed Sep 12 2007 - 14:01:07 EDT)
      • Re: [PERFORM] random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Gregory Stark (Thu Sep 13 2007 - 13:46:42 EDT)
      • Re: [PERFORM] random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Heikki Linnakangas (Tue Sep 11 2007 - 05:00:46 EDT)
  • Re: [PERFORM] random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Kevin Grittner (Sun Sep 16 2007 - 16:00:48 EDT)
• [PERFORM] DRBD and Postgres: how to improve the perfomance? Maila Fatticcioni (Fri Sep 07 2007 - 05:37:40 EDT)
  • Re: [PERFORM] DRBD and Postgres: how to improve the perfomance? Heikki Linnakangas (Fri Sep 07 2007 - 06:12:06 EDT)
  • Re: [PERFORM] DRBD and Postgres: how to improve the perfomance? Merlin Moncure (Fri Sep 07 2007 - 08:56:15 EDT)
  • Re: [PERFORM] DRBD and Postgres: how to improve the perfomance? Simon Riggs (Fri Sep 07 2007 - 15:00:16 EDT)
    • Re: [PERFORM] DRBD and Postgres: how to improve the perfomance? Maila Fatticcioni (Tue Sep 11 2007 - 10:47:40 EDT)
      • Re: [PERFORM] DRBD and Postgres: how to improve the perfomance? Steinar H. Gunderson (Tue Sep 11 2007 - 10:57:24 EDT)
      • Re: [PERFORM] DRBD and Postgres: how to improve the perfomance? Decibel! (Tue Sep 11 2007 - 17:22:02 EDT)
      • Re: [PERFORM] DRBD and Postgres: how to improve the perfomance? Markus Schiltknecht (Mon Sep 17 2007 - 11:19:31 EDT)
    • Re: [PERFORM] DRBD and Postgres: how to improve the perfomance? Mario Weilguni (Tue Sep 11 2007 - 14:26:02 EDT)
  • Re: [PERFORM] DRBD and Postgres: how to improve the perfomance? Bernd Helmle (Fri Sep 07 2007 - 17:54:12 EDT)
    • Re: [PERFORM] DRBD and Postgres: how to improve the perfomance? Simon Riggs (Sat Sep 08 2007 - 02:28:24 EDT)
      • Re: [PERFORM] DRBD and Postgres: how to improve the perfomance? Gregory Stark (Sat Sep 08 2007 - 06:04:41 EDT)
      • Re: [PERFORM] DRBD and Postgres: how to improve the perfomance? Joshua D. Drake (Sat Sep 08 2007 - 12:15:43 EDT)
      • Re: [PERFORM] DRBD and Postgres: how to improve the perfomance? Stefan Kaltenbrunner (Sat Sep 08 2007 - 12:33:55 EDT)
      • Re: [PERFORM] DRBD and Postgres: how to improve the perfomance? Joshua D. Drake (Sat Sep 08 2007 - 12:53:30 EDT)
      • Re: [PERFORM] DRBD and Postgres: how to improve the perfomance? Stefan Kaltenbrunner (Sat Sep 08 2007 - 13:25:24 EDT)
      • Re: [PERFORM] DRBD and Postgres: how to improve the perfomance? Joshua D. Drake (Sat Sep 08 2007 - 17:25:13 EDT)
      • Re: [PERFORM] DRBD and Postgres: how to improve the perfomance? Joshua D. Drake (Sat Sep 08 2007 - 17:30:59 EDT)
      • Re: [PERFORM] DRBD and Postgres: how to improve the perfomance? Tom Lane (Sat Sep 08 2007 - 12:39:37 EDT)
      • Re: [PERFORM] DRBD and Postgres: how to improve the perfomance? Bernd Helmle (Sat Sep 08 2007 - 14:22:24 EDT)
      • Re: [PERFORM] DRBD and Postgres: how to improve the perfomance? Gregory Stark (Sat Sep 08 2007 - 12:49:09 EDT)
      • Re: [PERFORM] DRBD and Postgres: how to improve the perfomance? Joshua D. Drake (Sat Sep 08 2007 - 13:02:33 EDT)
      • Re: [PERFORM] DRBD and Postgres: how to improve the perfomance? Gregory Stark (Sat Sep 08 2007 - 13:32:13 EDT)
      • Re: [PERFORM] DRBD and Postgres: how to improve the perfomance? Greg Smith (Mon Sep 10 2007 - 00:06:40 EDT)
      • Re: [PERFORM] DRBD and Postgres: how to improve the perfomance? Tom Lane (Mon Sep 10 2007 - 00:54:37 EDT)
      • Re: [PERFORM] DRBD and Postgres: how to improve the perfomance? Decibel! (Tue Sep 11 2007 - 17:20:15 EDT)
      • Re: [PERFORM] DRBD and Postgres: how to improve the perfomance? Jean-David Beyer (Tue Sep 11 2007 - 22:28:05 EDT)
      • Re: [PERFORM] DRBD and Postgres: how to improve the perfomance? Decibel! (Tue Sep 11 2007 - 17:12:33 EDT)
• [PERFORM] postgres memory management issues? Richard Yen (Thu Sep 06 2007 - 12:06:53 EDT)
  • Re: [PERFORM] postgres memory management issues? Richard Huxton (Fri Sep 07 2007 - 04:42:59 EDT)
  • Re: [PERFORM] postgres memory management issues? Claus Guttesen (Fri Sep 07 2007 - 05:01:47 EDT)
  • Re: [PERFORM] postgres memory management issues? Gregory Stark (Fri Sep 07 2007 - 05:31:34 EDT)
    • Re: [PERFORM] postgres memory management issues? Florian Weimer (Fri Sep 07 2007 - 05:38:25 EDT)
  • Re: [PERFORM] postgres memory management issues? Michael Stone (Fri Sep 07 2007 - 06:11:21 EDT)
  • Re: [PERFORM] postgres memory management issues? Tom Lane (Fri Sep 07 2007 - 10:56:47 EDT)
• [PERFORM] How planner decides left-anchored LIKE can use index Carlo Stonebanks (Thu Sep 06 2007 - 20:06:44 EDT)
  • Re: [PERFORM] How planner decides left-anchored LIKE can use index Tom Lane (Thu Sep 06 2007 - 20:28:16 EDT)
• [PERFORM] Reasonable amount of indices Patric (Thu Sep 06 2007 - 16:08:45 EDT)
  • Re: [PERFORM] Reasonable amount of indices Alvaro Herrera (Thu Sep 06 2007 - 18:09:40 EDT)
    • Re: [PERFORM] Reasonable amount of indices Tom Lane (Thu Sep 06 2007 - 19:18:46 EDT)
• Re: [PERFORM] [ADMIN] ADO -PostgreSQL OLE DB Provider Richard Broersma Jr (Thu Sep 06 2007 - 12:08:29 EDT)
• Re: [PERFORM] Hardware spec] Jean-David Beyer (Thu Sep 06 2007 - 11:00:21 EDT)
• [PERFORM] SAN vs Internal Disks Harsh Azad (Thu Sep 06 2007 - 08:35:02 EDT)
  • Re: [PERFORM] SAN vs Internal Disks Scott Marlowe (Thu Sep 06 2007 - 12:25:58 EDT)
    • Re: [PERFORM] SAN vs Internal Disks Harsh Azad (Thu Sep 06 2007 - 13:03:49 EDT)
      • Re: [PERFORM] SAN vs Internal Disks Joshua D. Drake (Thu Sep 06 2007 - 13:12:22 EDT)
      • Re: [PERFORM] SAN vs Internal Disks Scott Marlowe (Thu Sep 06 2007 - 14:07:43 EDT)
      • Re: [PERFORM] SAN vs Internal Disks Harsh Azad (Thu Sep 06 2007 - 14:15:07 EDT)
      • Re: [PERFORM] SAN vs Internal Disks Scott Marlowe (Thu Sep 06 2007 - 14:42:41 EDT)
      • Re: [PERFORM] SAN vs Internal Disks Joe Uhl (Thu Sep 06 2007 - 15:02:53 EDT)
      • Re: [PERFORM] SAN vs Internal Disks Joel Fradkin (Thu Sep 06 2007 - 15:14:04 EDT)
      • Re: [PERFORM] SAN vs Internal Disks Scott Marlowe (Thu Sep 06 2007 - 18:35:11 EDT)
      • Re: [PERFORM] SAN vs Internal Disks Arjen van der Meijden (Thu Sep 06 2007 - 15:38:02 EDT)
      • Re: [PERFORM] SAN vs Internal Disks Florian Weimer (Fri Sep 07 2007 - 04:14:50 EDT)
      • Re: [PERFORM] SAN vs Internal Disks Vivek Khera (Fri Sep 07 2007 - 16:35:09 EDT)
      • Re: [PERFORM] SAN vs Internal Disks Greg Smith (Fri Sep 07 2007 - 00:26:23 EDT)
      • Re: [PERFORM] SAN vs Internal Disks Michael Stone (Fri Sep 07 2007 - 06:04:49 EDT)
      • Re: [PERFORM] SAN vs Internal Disks Tobias Brox (Fri Sep 07 2007 - 06:33:41 EDT)
      • Re: [PERFORM] SAN vs Internal Disks Michael Stone (Fri Sep 07 2007 - 09:16:03 EDT)
      • Re: [PERFORM] SAN vs Internal Disks Matthew Schumacher (Fri Sep 07 2007 - 13:21:10 EDT)
      • Re: [PERFORM] SAN vs Internal Disks Bryan Murphy (Fri Sep 07 2007 - 13:56:20 EDT)
      • Re: [PERFORM] SAN vs Internal Disks Alan Hodgson (Fri Sep 07 2007 - 14:18:42 EDT)
      • Re: [PERFORM] SAN vs Internal Disks Joshua D. Drake (Fri Sep 07 2007 - 14:21:58 EDT)
      • Re: [PERFORM] SAN vs Internal Disks Brian Hurt (Fri Sep 07 2007 - 14:21:52 EDT)
      • Re: [PERFORM] SAN vs Internal Disks Greg Smith (Fri Sep 07 2007 - 16:04:41 EDT)
      • Re: [PERFORM] SAN vs Internal Disks david(at)lang.hm (Fri Sep 07 2007 - 17:10:32 EDT)
      • Re: [PERFORM] SAN vs Internal Disks Joshua D. Drake (Fri Sep 07 2007 - 17:15:43 EDT)
      • Re: [PERFORM] SAN vs Internal Disks Decibel! (Tue Sep 11 2007 - 16:55:51 EDT)
      • Re: [PERFORM] SAN vs Internal Disks Michael Stone (Tue Sep 11 2007 - 17:09:00 EDT)
      • Re: [PERFORM] SAN vs Internal Disks Decibel! (Tue Sep 11 2007 - 19:07:44 EDT)
      • Re: [PERFORM] SAN vs Internal Disks david(at)lang.hm (Tue Sep 11 2007 - 19:51:40 EDT)
      • Re: [PERFORM] SAN vs Internal Disks Harsh Azad (Wed Sep 12 2007 - 01:44:27 EDT)
      • Re: [PERFORM] SAN vs Internal Disks Tobias Brox (Wed Sep 12 2007 - 01:50:58 EDT)
      • Re: [PERFORM] SAN vs Internal Disks Michael Stone (Thu Sep 13 2007 - 14:27:09 EDT)
  • Re: [PERFORM] SAN vs Internal Disks Mark Lewis (Thu Sep 06 2007 - 10:42:34 EDT)
    • Re: [PERFORM] SAN vs Internal Disks Harsh Azad (Thu Sep 06 2007 - 12:58:45 EDT)
      • Re: [PERFORM] SAN vs Internal Disks Mark Lewis (Thu Sep 06 2007 - 14:29:20 EDT)
      • Re: [PERFORM] SAN vs Internal Disks Arjen van der Meijden (Thu Sep 06 2007 - 15:40:25 EDT)
  • Re: [PERFORM] SAN vs Internal Disks Arjen van der Meijden (Thu Sep 06 2007 - 13:39:51 EDT)
• [PERFORM] Hardware spec Willo van der Merwe (Thu Sep 06 2007 - 02:54:52 EDT)
  • Re: [PERFORM] Hardware spec Richard Huxton (Thu Sep 06 2007 - 04:17:34 EDT)
    • Re: [PERFORM] Hardware spec Willo van der Merwe (Thu Sep 06 2007 - 05:26:46 EDT)
      • Re: [PERFORM] Hardware spec Jean-David Beyer (Thu Sep 06 2007 - 07:16:00 EDT)
      • Re: [PERFORM] Hardware spec Willo van der Merwe (Thu Sep 06 2007 - 07:37:24 EDT)
      • Re: [PERFORM] Hardware spec Florian Weimer (Thu Sep 06 2007 - 10:19:03 EDT)
      • Re: [PERFORM] Hardware spec Willo van der Merwe (Thu Sep 06 2007 - 10:33:00 EDT)
      • Re: [PERFORM] Hardware spec Florian Weimer (Thu Sep 06 2007 - 11:21:35 EDT)
      • Re: [PERFORM] Hardware spec Decibel! (Tue Sep 11 2007 - 16:35:55 EDT)
      • Re: [PERFORM] Hardware spec Willo van der Merwe (Wed Sep 12 2007 - 03:01:18 EDT)
      • Re: [PERFORM] Hardware spec Claus Guttesen (Wed Sep 12 2007 - 03:17:23 EDT)
• [PERFORM] utilising multi-cpu/core machines? Thomas Finneid (Wed Sep 05 2007 - 18:41:06 EDT)
  • Re: [PERFORM] utilising multi-cpu/core machines? Jonah H. Harris (Wed Sep 05 2007 - 19:02:36 EDT)
  • Re: [PERFORM] utilising multi-cpu/core machines? Trevor Talbot (Wed Sep 05 2007 - 20:07:57 EDT)
  • Re: [PERFORM] utilising multi-cpu/core machines? Kevin Grittner (Thu Sep 06 2007 - 09:46:40 EDT)
  • Re: [PERFORM] utilising multi-cpu/core machines? Sven Geisler (Fri Sep 07 2007 - 05:50:15 EDT)
• [PERFORM] RESEND:Postgres with Sun Cluster HA/Solaris 10 Subbiah Stalin-XCGF84 (Wed Sep 05 2007 - 18:48:52 EDT)
• [PERFORM] Re : optimize query with a maximum(date) extraction JS Ubei (Wed Sep 05 2007 - 09:11:31 EDT)
• [PERFORM] optimize query with a maximum(date) extraction JS Ubei (Wed Sep 05 2007 - 05:53:22 EDT)
  • FW: [PERFORM] optimize query with a maximum(date) extraction Gregory Williamson (Wed Sep 05 2007 - 07:06:43 EDT)
  • Re: [PERFORM] optimize query with a maximum(date) extraction Gregory Stark (Wed Sep 05 2007 - 07:30:21 EDT)
    • Re: [PERFORM] optimize query with a maximum(date) extraction Gregory Stark (Wed Sep 05 2007 - 08:06:01 EDT)
      • Re: [PERFORM] optimize query with a maximum(date) extraction Peter Childs (Wed Sep 05 2007 - 08:43:24 EDT)
      • Re: [PERFORM] optimize query with a maximum(date) extraction Pavel Stehule (Wed Sep 05 2007 - 08:48:18 EDT)
      • Re: [PERFORM] optimize query with a maximum(date) extraction Gregory Stark (Wed Sep 05 2007 - 10:28:53 EDT)
      • Re: [PERFORM] optimize query with a maximum(date) extraction Tom Lane (Wed Sep 05 2007 - 11:23:38 EDT)
      • Re: [PERFORM] optimize query with a maximum(date) extraction Gregory Stark (Wed Sep 05 2007 - 10:23:23 EDT)
    • Re: [PERFORM] optimize query with a maximum(date) extraction hubert depesz lubaczewski (Wed Sep 05 2007 - 09:22:50 EDT)
      • Re: [PERFORM] optimize query with a maximum(date) extraction Gregory Stark (Wed Sep 05 2007 - 10:14:00 EDT)
  • Re: [PERFORM] optimize query with a maximum(date) extraction Dimitri (Sat Sep 08 2007 - 04:00:22 EDT)
• [PERFORM] Performance on 8CPU's and 32GB of RAM Carlo Stonebanks (Tue Sep 04 2007 - 18:45:24 EDT)
  • Re: [PERFORM] Performance on 8CPU's and 32GB of RAM Scott Marlowe (Tue Sep 04 2007 - 19:03:11 EDT)
  • Re: [PERFORM] Performance on 8CPU's and 32GB of RAM Alvaro Herrera (Tue Sep 04 2007 - 19:06:39 EDT)
    • Re: [PERFORM] Performance on 8CPU's and 32GB of RAM Scott Marlowe (Tue Sep 04 2007 - 19:15:16 EDT)
      • Re: [PERFORM] Performance on 8CPU's and 32GB of RAM Hannes Dorbath (Wed Sep 05 2007 - 04:20:31 EDT)
      • Re: [PERFORM] Performance on 8CPU's and 32GB of RAM Carlo Stonebanks (Wed Sep 05 2007 - 11:23:05 EDT)
      • Re: [PERFORM] Performance on 8CPU's and 32GB of RAM Scott Marlowe (Wed Sep 05 2007 - 11:45:24 EDT)
      • Re: [PERFORM] Performance on 8CPU's and 32GB of RAM Trevor Talbot (Wed Sep 05 2007 - 13:16:51 EDT)
      • Re: [PERFORM] Performance on 8CPU's and 32GB of RAM Ron Mayer (Wed Sep 05 2007 - 14:09:44 EDT)
      • Re: [PERFORM] Performance on 8CPU's and 32GB of RAM Scott Marlowe (Wed Sep 05 2007 - 15:29:25 EDT)
      • Re: [PERFORM] Performance on 8CPU's and 32GB of RAM Scott Marlowe (Wed Sep 05 2007 - 15:36:43 EDT)
      • Re: [PERFORM] Performance on 8CPU's and 32GB of RAM Trevor Talbot (Wed Sep 05 2007 - 17:08:41 EDT)
      • Re: [PERFORM] Performance on 8CPU's and 32GB of RAM Ansgar -59cobalt- Wiechers (Wed Sep 05 2007 - 17:02:12 EDT)
      • Re: [PERFORM] Performance on 8CPU's and 32GB of RAM Scott Marlowe (Wed Sep 05 2007 - 17:59:17 EDT)
      • Re: [PERFORM] Performance on 8CPU's and 32GB of RAM Ansgar -59cobalt- Wiechers (Wed Sep 05 2007 - 19:19:21 EDT)
      • Re: [PERFORM] Performance on 8CPU's and 32GB of RAM Scott Marlowe (Wed Sep 05 2007 - 20:12:04 EDT)
      • Re: [PERFORM] Performance on 8CPU's and 32GB of RAM Ansgar -59cobalt- Wiechers (Thu Sep 06 2007 - 02:47:46 EDT)
      • Re: [PERFORM] Performance on 8CPU's and 32GB of RAM Adam Tauno Williams (Wed Sep 05 2007 - 18:15:58 EDT)
      • Re: [PERFORM] Performance on 8CPU's and 32GB of RAM James Mansion (Thu Sep 06 2007 - 16:30:55 EDT)
      • Re: [PERFORM] Performance on 8CPU's and 32GB of RAM Scott Marlowe (Thu Sep 06 2007 - 16:59:34 EDT)
      • Re: [PERFORM] Performance on 8CPU's and 32GB of RAM Florian Weimer (Fri Sep 07 2007 - 04:17:11 EDT)
      • Re: [PERFORM] Performance on 8CPU's and 32GB of RAM Scott Marlowe (Fri Sep 07 2007 - 12:16:38 EDT)
      • Re: [PERFORM] Performance on 8CPU's and 32GB of RAM Harald Armin Massa (Fri Sep 07 2007 - 13:32:53 EDT)
      • Re: [PERFORM] Performance on 8CPU's and 32GB of RAM Carlo Stonebanks (Wed Sep 05 2007 - 11:06:03 EDT)
      • Re: [PERFORM] Performance on 8CPU's and 32GB of RAM Scott Marlowe (Wed Sep 05 2007 - 11:15:42 EDT)
      • Re: [PERFORM] Performance on 8CPU's and 32GB of RAM James Mansion (Thu Sep 06 2007 - 16:39:26 EDT)
      • Re: [PERFORM] Performance on 8CPU's and 32GB of RAM Alvaro Herrera (Thu Sep 06 2007 - 17:21:16 EDT)
      • Re: [PERFORM] Performance on 8CPU's and 32GB of RAM Carlo Stonebanks (Thu Sep 06 2007 - 16:46:27 EDT)
      • Re: [PERFORM] Performance on 8CPU's and 32GB of RAM James Mansion (Thu Sep 06 2007 - 16:55:11 EDT)
      • Re: [PERFORM] Performance on 8CPU's and 32GB of RAM Carlo Stonebanks (Thu Sep 06 2007 - 19:18:40 EDT)
      • Re: [PERFORM] Performance on 8CPU's and 32GB of RAM Joshua D. Drake (Wed Sep 05 2007 - 22:50:34 EDT)
      • Re: [PERFORM] Performance on 8CPU's and 32GB of RAM Decibel! (Tue Sep 11 2007 - 16:32:42 EDT)
    • Re: [PERFORM] Performance on 8CPU's and 32GB of RAM Carlo Stonebanks (Wed Sep 05 2007 - 11:57:19 EDT)
      • Re: [PERFORM] Performance on 8CPU's and 32GB of RAM Alvaro Herrera (Wed Sep 05 2007 - 12:03:48 EDT)
      • Re: [PERFORM] Performance on 8CPU's and 32GB of RAM Scott Marlowe (Wed Sep 05 2007 - 12:06:07 EDT)
• [PERFORM] join tables vs. denormalization by trigger Walter Mauritz (Tue Sep 04 2007 - 14:53:21 EDT)
  • Re: [PERFORM] join tables vs. denormalization by trigger Mark Lewis (Tue Sep 04 2007 - 15:18:00 EDT)
  • Re: [PERFORM] join tables vs. denormalization by trigger Marc Mamin (Tue Sep 04 2007 - 18:48:41 EDT)
• [PERFORM] About autovacuum Jean-David Beyer (Tue Sep 04 2007 - 14:39:44 EDT)
  • Re: [PERFORM] About autovacuum Bill Moran (Tue Sep 04 2007 - 15:01:02 EDT)
• [PERFORM] Vacum Analyze problem rafael(at)akyasociados.com.ar (Tue Sep 04 2007 - 13:27:07 EDT)
  • Re: [PERFORM] Vacum Analyze problem Mikko Partio (Tue Sep 04 2007 - 13:33:29 EDT)
    • Re: [PERFORM] Vacum Analyze problem rafael(at)akyasociados.com.ar (Tue Sep 04 2007 - 13:46:37 EDT)
      • Re: [PERFORM] Vacum Analyze problem Gregory Stark (Tue Sep 04 2007 - 19:24:32 EDT)
  • Re: [PERFORM] Vacum Analyze problem Kevin Kempter (Tue Sep 04 2007 - 13:45:21 EDT)
    • Re: [PERFORM] Vacum Analyze problem rafael(at)akyasociados.com.ar (Tue Sep 04 2007 - 14:46:20 EDT)
      • Re: [PERFORM] Vacum Analyze problem Richard Broersma Jr (Tue Sep 04 2007 - 14:52:31 EDT)
  • Re: [PERFORM] Vacum Analyze problem Bill Moran (Tue Sep 04 2007 - 13:55:59 EDT)
• [PERFORM] Slow Query Shawn (Sat Sep 01 2007 - 13:29:47 EDT)
  • Re: [PERFORM] Slow Query Tom Lane (Sat Sep 01 2007 - 14:09:54 EDT)
    • Re: [PERFORM] Slow Query Shawn (Sat Sep 01 2007 - 16:18:16 EDT)
      • Re: [PERFORM] Slow Query Shawn (Sat Sep 01 2007 - 20:35:19 EDT)
      • Re: [PERFORM] Slow Query Tom Lane (Sat Sep 01 2007 - 23:00:10 EDT)
      • Re: [PERFORM] Slow Query Shawn (Mon Sep 03 2007 - 12:57:49 EDT)
      • Re: [PERFORM] Slow Query Kevin Grittner (Mon Sep 03 2007 - 14:32:13 EDT)
  • Re: [PERFORM] Slow Query Kevin Grittner (Sun Sep 02 2007 - 11:49:09 EDT)
    • Re: [PERFORM] Slow Query Shawn (Mon Sep 03 2007 - 12:15:58 EDT)
      • Re: [PERFORM] Slow Query Kevin Grittner (Mon Sep 03 2007 - 14:07:41 EDT)
      • Re: [PERFORM] Slow Query Shawn (Mon Sep 03 2007 - 19:53:34 EDT)
      • Re: [PERFORM] Slow Query Tom Lane (Mon Sep 03 2007 - 20:49:42 EDT)
      • Re: [PERFORM] Slow Query Kevin Grittner (Mon Sep 03 2007 - 22:40:33 EDT)
  • Re: [PERFORM] Slow Query Shawn (Sun Sep 09 2007 - 21:31:13 EDT)
  • Re: [PERFORM] schemas to limit data access Merlin Moncure (Mon Sep 03 2007 - 21:08:48 EDT)
  • Re: [PERFORM] [GENERAL] Performance issue with nested loop Decibel! (Sat Sep 01 2007 - 19:50:41 EDT)
  • Re: [PERFORM] When/if to Reindex Bruce Momjian (Fri Sep 14 2007 - 00:23:00 EDT)