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

• [PERFORM] How to install Postgresql 8.2.x on windows XP silently Sachchida Ojha (Thu Jun 28 2007 - 15:09:45 EDT)
  • Re: [PERFORM] How to install Postgresql 8.2.x on windows XP silently Magnus Hagander (Thu Jun 28 2007 - 15:44:59 EDT)
• [PERFORM] PostgreSQL 8.0 occasionally slow down Ho Fat Tsang (Thu Jun 28 2007 - 02:54:31 EDT)
  • Re: [PERFORM] PostgreSQL 8.0 occasionally slow down Andreas Kostyrka (Thu Jun 28 2007 - 03:17:59 EDT)
  • Re: [PERFORM] PostgreSQL 8.0 occasionally slow down Richard Huxton (Thu Jun 28 2007 - 03:22:17 EDT)
    • Re: [PERFORM] PostgreSQL 8.0 occasionally slow down Ho Fat Tsang (Thu Jun 28 2007 - 04:01:30 EDT)
      • Re: [PERFORM] PostgreSQL 8.0 occasionally slow down Richard Huxton (Thu Jun 28 2007 - 04:03:50 EDT)
      • Re: [PERFORM] PostgreSQL 8.0 occasionally slow down Ho Fat Tsang (Thu Jun 28 2007 - 04:17:28 EDT)
      • Re: [PERFORM] PostgreSQL 8.0 occasionally slow down Richard Huxton (Thu Jun 28 2007 - 05:16:00 EDT)
      • Re: [PERFORM] PostgreSQL 8.0 occasionally slow down Ho Fat Tsang (Thu Jun 28 2007 - 22:04:41 EDT)
      • Re: [PERFORM] PostgreSQL 8.0 occasionally slow down Richard Huxton (Fri Jun 29 2007 - 05:21:22 EDT)
      • Re: [PERFORM] PostgreSQL 8.0 occasionally slow down Alvaro Herrera (Fri Jun 29 2007 - 09:33:51 EDT)
      • Re: [PERFORM] PostgreSQL 8.0 occasionally slow down Greg Smith (Thu Jun 28 2007 - 09:52:54 EDT)
      • Re: [PERFORM] PostgreSQL 8.0 occasionally slow down Gregory Stark (Thu Jun 28 2007 - 10:16:49 EDT)
  • Re: [PERFORM] PostgreSQL 8.0 occasionally slow down Kevin Grittner (Thu Jun 28 2007 - 10:19:11 EDT)
• [PERFORM] update query taking too long Chris (Thu Jun 28 2007 - 01:03:32 EDT)
  • Re: [PERFORM] update query taking too long A. Kretschmer (Thu Jun 28 2007 - 01:37:25 EDT)
    • Re: [PERFORM] update query taking too long Chris (Thu Jun 28 2007 - 02:20:59 EDT)
  • Re: [PERFORM] update query taking too long Tom Lane (Thu Jun 28 2007 - 01:41:10 EDT)
    • Re: [PERFORM] update query taking too long Chris (Thu Jun 28 2007 - 02:16:50 EDT)
      • Re: [PERFORM] update query taking too long A. Kretschmer (Thu Jun 28 2007 - 02:28:26 EDT)
      • Re: [PERFORM] update query taking too long Chris (Thu Jun 28 2007 - 02:37:43 EDT)
      • Re: [PERFORM] update query taking too long Richard Huxton (Thu Jun 28 2007 - 02:39:46 EDT)
      • Re: [PERFORM] update query taking too long Chris (Thu Jun 28 2007 - 02:49:58 EDT)
      • Re: [PERFORM] update query taking too long Richard Huxton (Thu Jun 28 2007 - 03:02:44 EDT)
      • Re: [PERFORM] update query taking too long Chris (Thu Jun 28 2007 - 04:18:16 EDT)
      • Re: [PERFORM] update query taking too long Jean-David Beyer (Thu Jun 28 2007 - 07:44:57 EDT)
      • Re: [PERFORM] update query taking too long Heikki Linnakangas (Thu Jun 28 2007 - 08:01:03 EDT)
      • Re: [PERFORM] update query taking too long Richard Huxton (Thu Jun 28 2007 - 08:03:39 EDT)
• [PERFORM] High IOWAIT times, low iops? Need Help with configuration Evan Reiser (Wed Jun 27 2007 - 20:38:11 EDT)
  • Re: [PERFORM] High IOWAIT times, low iops? Need Help with configuration Richard Huxton (Thu Jun 28 2007 - 03:17:38 EDT)
    • Re: [PERFORM] High IOWAIT times, low iops? Need Help with configuration Evan Reiser (Thu Jun 28 2007 - 09:17:59 EDT)
  • Re: [PERFORM] High IOWAIT times, low iops? Need Help with configuration Greg Smith (Thu Jun 28 2007 - 09:39:38 EDT)
• [PERFORM] rtree/gist index taking enormous amount of space in 8.2.3 Dolafi, Tom (Wed Jun 27 2007 - 11:17:48 EDT)
  • Re: [PERFORM] rtree/gist index taking enormous amount of space in 8.2.3 Tom Lane (Thu Jun 28 2007 - 12:08:37 EDT)
    • Re: [PERFORM] rtree/gist index taking enormous amount of space in 8.2.3 Dolafi, Tom (Fri Jun 29 2007 - 09:51:19 EDT)
      • Re: [PERFORM] rtree/gist index taking enormous amount of space in 8.2.3 Craig James (Fri Jun 29 2007 - 12:14:08 EDT)
      • Re: [PERFORM] rtree/gist index taking enormous amount of space in 8.2.3 Dolafi, Tom (Fri Jun 29 2007 - 14:05:30 EDT)
      • Re: [PERFORM] rtree/gist index taking enormous amount of space in 8.2.3 Tom Lane (Fri Jun 29 2007 - 14:30:09 EDT)
      • Re: [PERFORM] rtree/gist index taking enormous amount of space in 8.2.3 Dolafi, Tom (Fri Jun 29 2007 - 14:44:31 EDT)
      • Re: [PERFORM] rtree/gist index taking enormous amount of space in 8.2.3 Tom Lane (Fri Jun 29 2007 - 13:57:44 EDT)
      • Re: [PERFORM] rtree/gist index taking enormous amount of space in 8.2.3 Dolafi, Tom (Fri Jun 29 2007 - 14:13:23 EDT)
      • Re: [PERFORM] rtree/gist index taking enormous amount of space in 8.2.3 Tom Lane (Fri Jun 29 2007 - 14:38:11 EDT)
      • Re: [PERFORM] rtree/gist index taking enormous amount of space in 8.2.3 Dolafi, Tom (Fri Jun 29 2007 - 15:40:30 EDT)
• [PERFORM] Non-optimal query plan with 8.2 Tyrrill, Ed (Mon Jun 25 2007 - 17:48:55 EDT)
• [PERFORM] Tyrrill, Ed (Mon Jun 25 2007 - 17:28:32 EDT)
  • Re: [PERFORM] Stephen Frost (Mon Jun 25 2007 - 17:56:54 EDT)
    • Re: [PERFORM] Ed Tyrrill (Mon Jun 25 2007 - 19:39:02 EDT)
      • Re: [PERFORM] Stephen Frost (Mon Jun 25 2007 - 19:52:09 EDT)
  • Re: [PERFORM] Tom Lane (Mon Jun 25 2007 - 18:10:15 EDT)
    • Re: [PERFORM] Ed Tyrrill (Mon Jun 25 2007 - 20:09:58 EDT)
      • Re: [PERFORM] Stephen Frost (Mon Jun 25 2007 - 20:33:39 EDT)
      • Re: [PERFORM] Tom Lane (Mon Jun 25 2007 - 21:07:14 EDT)
      • Re: [PERFORM] Ed Tyrrill (Fri Jun 29 2007 - 17:01:03 EDT)
• [PERFORM] startup caching suggestions Bryan Murphy (Mon Jun 25 2007 - 16:18:43 EDT)
  • Re: [PERFORM] startup caching suggestions Oleg Bartunov (Mon Jun 25 2007 - 18:16:16 EDT)
    • Re: [PERFORM] startup caching suggestions Bryan Murphy (Mon Jun 25 2007 - 18:20:17 EDT)
• [PERFORM] Is AIX Concurrent IO safe with PostgreSQL? Dawid Kuroczko (Mon Jun 25 2007 - 06:01:44 EDT)
• Re: [PERFORM] Slow indexscan Mikko Partio (Mon Jun 25 2007 - 03:50:48 EDT)
  • Re: [PERFORM] Slow indexscan Tom Lane (Mon Jun 25 2007 - 10:24:30 EDT)
• [PERFORM] PREPARE and stuff PFC (Sat Jun 23 2007 - 17:30:06 EDT)
  • Re: [PERFORM] PREPARE and stuff Heikki Linnakangas (Sat Jun 23 2007 - 17:51:00 EDT)
  • Re: [PERFORM] PREPARE and stuff Andreas Kostyrka (Sat Jun 23 2007 - 17:55:49 EDT)
    • Re: [PERFORM] PREPARE and stuff PFC (Sat Jun 23 2007 - 18:27:32 EDT)
  • Re: [PERFORM] PREPARE and stuff Gregory Stark (Sat Jun 23 2007 - 18:02:25 EDT)
• Re: [PERFORM] Volunteer to build a configuration tool Greg Smith (Sat Jun 23 2007 - 15:28:17 EDT)
  • Re: [PERFORM] Volunteer to build a configuration tool Jim Nasby (Mon Jun 25 2007 - 20:19:01 EDT)
    • Re: [PERFORM] Volunteer to build a configuration tool Gregory Stark (Tue Jun 26 2007 - 04:01:59 EDT)
  • Re: [PERFORM] Volunteer to build a configuration tool Josh Berkus (Wed Jun 27 2007 - 19:19:45 EDT)
• [PERFORM] Slow join query Tom Tamulewicz (Fri Jun 22 2007 - 14:32:15 EDT)
  • Re: [PERFORM] Slow join query Michael Glaesemann (Fri Jun 22 2007 - 15:51:32 EDT)
    • Re: [PERFORM] Slow join query Tom Tamulewicz (Fri Jun 22 2007 - 17:25:37 EDT)
      • Re: [PERFORM] Slow join query Michael Glaesemann (Fri Jun 22 2007 - 17:30:56 EDT)
      • Re: [PERFORM] Slow join query Tom Tamulewicz (Fri Jun 22 2007 - 17:53:17 EDT)
      • Re: [PERFORM] Slow join query Scott Marlowe (Fri Jun 22 2007 - 18:24:07 EDT)
• Re: [PERFORM] PostgreSQL Configuration Tool for Dummies - feedback adjustable control Sabin Coanda (Fri Jun 22 2007 - 09:24:47 EDT)
  • Re: [PERFORM] PostgreSQL Configuration Tool for Dummies - feedback adjustable control david(at)lang.hm (Fri Jun 22 2007 - 14:47:20 EDT)
    • Re: [PERFORM] PostgreSQL Configuration Tool for Dummies - feedback adjustable control Sabin Coanda (Mon Jun 25 2007 - 07:47:43 EDT)
  • Re: [PERFORM] PostgreSQL Configuration Tool for Dummies - feedback adjustable control Greg Smith (Sat Jun 23 2007 - 15:44:04 EDT)
• Re: [PERFORM] PostgreSQL Configuration Tool for Dummies Greg Smith (Fri Jun 22 2007 - 02:32:00 EDT)
  • Re: [PERFORM] PostgreSQL Configuration Tool for Dummies Adam Tauno Williams (Fri Jun 22 2007 - 08:05:46 EDT)
    • Re: [PERFORM] PostgreSQL Configuration Tool for Dummies Greg Smith (Sat Jun 23 2007 - 15:32:45 EDT)
  • Re: [PERFORM] PostgreSQL Configuration Tool for Dummies Josh Berkus (Tue Jun 26 2007 - 11:26:28 EDT)
    • Re: [PERFORM] PostgreSQL Configuration Tool for Dummies Greg Smith (Tue Jun 26 2007 - 14:14:24 EDT)
      • Re: [PERFORM] PostgreSQL Configuration Tool for Dummies Josh Berkus (Tue Jun 26 2007 - 15:26:05 EDT)
      • Re: [PERFORM] PostgreSQL Configuration Tool for Dummies Greg Smith (Tue Jun 26 2007 - 18:05:21 EDT)
      • Re: [PERFORM] PostgreSQL Configuration Tool for Dummies Josh Berkus (Wed Jun 27 2007 - 14:02:35 EDT)
• [PERFORM] PITR Backups Dan Gorman (Thu Jun 21 2007 - 19:31:32 EDT)
  • Re: [PERFORM] PITR Backups Tom Lane (Thu Jun 21 2007 - 20:26:45 EDT)
    • Re: [PERFORM] PITR Backups Toru SHIMOGAKI (Thu Jun 21 2007 - 22:30:49 EDT)
      • Re: [PERFORM] PITR Backups Joshua D. Drake (Thu Jun 21 2007 - 23:10:30 EDT)
      • Re: [PERFORM] PITR Backups Toru SHIMOGAKI (Fri Jun 22 2007 - 03:41:24 EDT)
      • Re: [PERFORM] PITR Backups Joshua D. Drake (Fri Jun 22 2007 - 09:53:14 EDT)
      • Re: [PERFORM] PITR Backups Steve Atkins (Fri Jun 22 2007 - 00:01:41 EDT)
      • Re: [PERFORM] PITR Backups Toru SHIMOGAKI (Fri Jun 22 2007 - 03:30:17 EDT)
      • Re: [PERFORM] PITR Backups Dan Gorman (Fri Jun 22 2007 - 03:43:13 EDT)
      • Re: [PERFORM] PITR Backups Toru SHIMOGAKI (Fri Jun 22 2007 - 04:23:50 EDT)
      • Re: [PERFORM] PITR Backups Simon Riggs (Fri Jun 22 2007 - 08:14:46 EDT)
      • Re: [PERFORM] PITR Backups Joshua D. Drake (Fri Jun 22 2007 - 09:54:01 EDT)
      • Re: [PERFORM] PITR Backups Gregory Stark (Fri Jun 22 2007 - 11:31:42 EDT)
      • Re: [PERFORM] PITR Backups Simon Riggs (Fri Jun 22 2007 - 06:55:47 EDT)
      • Re: [PERFORM] PITR Backups Dan Gorman (Fri Jun 22 2007 - 07:10:36 EDT)
      • Re: [PERFORM] PITR Backups Simon Riggs (Fri Jun 22 2007 - 07:38:09 EDT)
      • Re: [PERFORM] PITR Backups Dan Gorman (Fri Jun 22 2007 - 07:51:19 EDT)
      • Re: [PERFORM] PITR Backups Kurt Overberg (Fri Jun 22 2007 - 08:10:46 EDT)
      • Re: [PERFORM] PITR Backups Andreas Kostyrka (Fri Jun 22 2007 - 08:13:38 EDT)
      • Re: [PERFORM] PITR Backups Tom Lane (Fri Jun 22 2007 - 13:12:02 EDT)
      • Re: [PERFORM] PITR Backups Simon Riggs (Fri Jun 22 2007 - 13:45:57 EDT)
      • Re: [PERFORM] PITR Backups Tom Lane (Fri Jun 22 2007 - 14:02:44 EDT)
      • Re: [PERFORM] PITR Backups Dan Gorman (Mon Jun 25 2007 - 11:26:52 EDT)
      • Re: [PERFORM] PITR Backups Koichi Suzuki (Mon Jun 25 2007 - 06:06:07 EDT)
      • Re: [PERFORM] PITR Backups Simon Riggs (Mon Jun 25 2007 - 09:26:02 EDT)
      • Re: [PERFORM] PITR Backups Dan Gorman (Mon Jun 25 2007 - 11:28:51 EDT)
      • Re: [PERFORM] PITR Backups Gregory Stark (Mon Jun 25 2007 - 12:02:53 EDT)
      • Re: [PERFORM] PITR Backups Dan Gorman (Mon Jun 25 2007 - 12:05:12 EDT)
      • Re: [PERFORM] PITR Backups Simon Riggs (Mon Jun 25 2007 - 12:23:18 EDT)
      • Re: [PERFORM] PITR Backups Tom Lane (Mon Jun 25 2007 - 12:34:18 EDT)
      • Re: [PERFORM] PITR Backups Simon Riggs (Mon Jun 25 2007 - 12:56:06 EDT)
      • Re: [PERFORM] PITR Backups Gregory Stark (Mon Jun 25 2007 - 13:07:24 EDT)
      • Re: [PERFORM] PITR Backups Dan Gorman (Mon Jun 25 2007 - 13:10:55 EDT)
      • Re: [PERFORM] PITR Backups Tom Lane (Mon Jun 25 2007 - 13:10:45 EDT)
      • Re: [PERFORM] PITR Backups Dan Gorman (Mon Jun 25 2007 - 13:04:48 EDT)
      • Re: [PERFORM] PITR Backups Tom Lane (Mon Jun 25 2007 - 13:12:09 EDT)
      • Re: [PERFORM] PITR Backups Tom Lane (Mon Jun 25 2007 - 10:31:49 EDT)
      • Re: [PERFORM] PITR Backups Gregory Stark (Mon Jun 25 2007 - 11:00:25 EDT)
• Re: [PERFORM] Hardware suggestions Scott Marlowe (Thu Jun 21 2007 - 18:29:15 EDT)
  • Re: [PERFORM] Hardware suggestions Greg Smith (Fri Jun 22 2007 - 02:20:18 EDT)
    • Re: [PERFORM] Hardware suggestions Francisco Reyes (Fri Jun 22 2007 - 08:21:22 EDT)
• Re: [PERFORM] Data transfer very slow when connected via DSL Rainer Bauer (Thu Jun 21 2007 - 17:26:43 EDT)
  • Re: [PERFORM] Data transfer very slow when connected via DSL Dimitri (Thu Jun 21 2007 - 17:32:01 EDT)
    • Re: [PERFORM] Data transfer very slow when connected via DSL Rainer Bauer (Thu Jun 21 2007 - 18:09:17 EDT)
      • Re: [PERFORM] Data transfer very slow when connected via DSL Dimitri (Thu Jun 21 2007 - 18:38:40 EDT)
      • Re: [PERFORM] Data transfer very slow when connected via DSL Rainer Bauer (Fri Jun 22 2007 - 05:15:14 EDT)
      • Re: [PERFORM] Data transfer very slow when connected via DSL Dimitri (Fri Jun 22 2007 - 05:37:40 EDT)
      • Re: [PERFORM] Data transfer very slow when connected via DSL Rainer Bauer (Fri Jun 22 2007 - 06:02:15 EDT)
      • Re: [PERFORM] Data transfer very slow when connected via DSL Dimitri (Fri Jun 22 2007 - 08:24:07 EDT)
      • Re: [PERFORM] Data transfer very slow when connected via DSL Rainer Bauer (Fri Jun 22 2007 - 10:01:49 EDT)
      • Re: [PERFORM] Data transfer very slow when connected via DSL Joshua D. Drake (Fri Jun 22 2007 - 10:16:18 EDT)
      • Re: [PERFORM] Data transfer very slow when connected via DSL Rainer Bauer (Fri Jun 22 2007 - 10:38:06 EDT)
      • Re: [PERFORM] Data transfer very slow when connected via DSL Dimitri (Fri Jun 22 2007 - 12:04:18 EDT)
      • Re: [PERFORM] Data transfer very slow when connected via DSL Rainer Bauer (Fri Jun 22 2007 - 17:51:15 EDT)
      • Re: [PERFORM] Data transfer very slow when connected via DSL Scott Marlowe (Thu Jun 21 2007 - 19:23:06 EDT)
  • Re: [PERFORM] Data transfer very slow when connected via DSL Tom Lane (Thu Jun 21 2007 - 21:51:11 EDT)
    • Re: [PERFORM] Data transfer very slow when connected via DSL Dimitri (Fri Jun 22 2007 - 04:06:47 EDT)
    • Re: [PERFORM] Data transfer very slow when connected via DSL Rainer Bauer (Fri Jun 22 2007 - 05:15:12 EDT)
      • Re: [PERFORM] Data transfer very slow when connected via DSL Dave Page (Fri Jun 22 2007 - 06:12:48 EDT)
      • Re: [PERFORM] Data transfer very slow when connected via DSL Dave Page (Fri Jun 22 2007 - 06:16:46 EDT)
  • Re: [PERFORM] Data transfer very slow when connected via DSL Harald Armin Massa (Fri Jun 22 2007 - 06:24:16 EDT)
    • Re: [PERFORM] Data transfer very slow when connected via DSL PFC (Fri Jun 22 2007 - 06:45:13 EDT)
      • Re: [PERFORM] Data transfer very slow when connected via DSL Harald Armin Massa (Fri Jun 22 2007 - 08:45:12 EDT)
• Re: [PERFORM] Database-wide VACUUM ANALYZE Francisco Reyes (Thu Jun 21 2007 - 14:58:33 EDT)
  • Re: [PERFORM] Database-wide VACUUM ANALYZE Steven Flatt (Thu Jun 21 2007 - 15:36:00 EDT)
    • Re: [PERFORM] Database-wide VACUUM ANALYZE Larry Rosenman (Thu Jun 21 2007 - 15:59:53 EDT)
    • Re: [PERFORM] Database-wide VACUUM ANALYZE Bill Moran (Thu Jun 21 2007 - 16:07:32 EDT)
      • Re: [PERFORM] Database-wide VACUUM ANALYZE Steven Flatt (Thu Jun 21 2007 - 16:37:49 EDT)
      • Re: [PERFORM] Database-wide VACUUM ANALYZE Alvaro Herrera (Fri Jun 22 2007 - 09:55:04 EDT)
      • Re: [PERFORM] Database-wide VACUUM ANALYZE Jim Nasby (Mon Jun 25 2007 - 20:00:20 EDT)
      • Re: [PERFORM] Database-wide VACUUM ANALYZE Steven Flatt (Tue Jun 26 2007 - 13:25:44 EDT)
      • Re: [PERFORM] Database-wide VACUUM ANALYZE Alvaro Herrera (Tue Jun 26 2007 - 14:49:06 EDT)
• Re: [PERFORM] Very long SQL strings Heikki Linnakangas (Thu Jun 21 2007 - 14:41:55 EDT)
  • Re: [PERFORM] Very long SQL strings Tom Lane (Thu Jun 21 2007 - 14:45:54 EDT)
    • Re: [PERFORM] Very long SQL strings Chris Browne (Thu Jun 21 2007 - 15:52:24 EDT)
      • Re: [PERFORM] Very long SQL strings Tom Lane (Thu Jun 21 2007 - 16:59:18 EDT)
  • Re: [PERFORM] Very long SQL strings Andreas Kretschmer (Thu Jun 21 2007 - 14:48:33 EDT)
    • Re: [PERFORM] Very long SQL strings Steven Flatt (Thu Jun 21 2007 - 16:09:31 EDT)
• Re: [PERFORM] Performance query about large tables, lots of concurrent access Michael Stone (Wed Jun 20 2007 - 14:08:55 EDT)
  • Re: [PERFORM] Performance query about large tables, lots of concurrent access Karl Wright (Wed Jun 20 2007 - 14:03:28 EDT)
  • Re: [PERFORM] Performance query about large tables, lots of concurrent access Scott Marlowe (Thu Jun 21 2007 - 19:10:32 EDT)
    • Re: [PERFORM] Performance query about large tables, lots of concurrent access Joshua D. Drake (Thu Jun 21 2007 - 19:24:56 EDT)
  • Re: [PERFORM] Performance query about large tables, lots of concurrent access Scott Marlowe (Thu Jun 21 2007 - 19:11:04 EDT)
  • Re: [PERFORM] Performance query about large tables, lots of concurrent access Michael Stone (Mon Jun 25 2007 - 07:37:48 EDT)
    • Re: [PERFORM] Performance query about large tables, lots of concurrent access Jean-David Beyer (Mon Jun 25 2007 - 09:06:55 EDT)
• Re: [GENERAL] [pgsql-advocacy] [PERFORM] [ADMIN] Postgres VS Oracle Andrew Sullivan (Mon Jun 18 2007 - 14:09:28 EDT)
• [PERFORM] Database size choksi (Fri Jun 08 2007 - 04:22:14 EDT)
• Re: [PERFORM] dbt2 NOTPM numbers Heikki Linnakangas (Mon Jun 04 2007 - 16:22:35 EDT)