Mailing List Archive For pgsql-performance@postgresql.org Aug 2007 By Subject

• [GENERAL] [PERFORM] Partioning tsearch2 a table into chunks and accessing via views
  • Erik Jones (Sat Aug 25 2007 - 16:09:01 EDT)
  • Benjamin Arai (Sat Aug 25 2007 - 15:49:13 EDT)
  • Joshua D. Drake (Sat Aug 25 2007 - 14:18:33 EDT)
  • Brandon Shalton (Sat Aug 25 2007 - 17:17:53 EDT)
  • Benjamin Arai (Sat Aug 25 2007 - 14:12:54 EDT)
  • Joshua D. Drake (Sat Aug 25 2007 - 12:18:18 EDT)
  • Benjamin Arai (Sat Aug 25 2007 - 01:34:06 EDT)
  • Joshua D. Drake (Fri Aug 24 2007 - 21:29:18 EDT)
• [GENERAL] [PERFORM] Planner making wrong decisions 8.2.4. Insane cost calculations.
  • Tom Lane (Mon Aug 06 2007 - 18:23:34 EDT)
  • Henrik Zagerholm (Mon Aug 06 2007 - 17:29:45 EDT)
  • Tom Lane (Mon Aug 06 2007 - 11:31:51 EDT)
• [PERFORM] 8.2 Autovacuum BUG ?
  • Tom Lane (Fri Aug 31 2007 - 19:43:54 EDT)
  • Greg Smith (Fri Aug 31 2007 - 19:24:56 EDT)
  • Chris Browne (Fri Aug 31 2007 - 15:13:54 EDT)
  • Tom Lane (Fri Aug 31 2007 - 15:48:43 EDT)
  • Erik Jones (Fri Aug 31 2007 - 15:35:49 EDT)
  • Tom Lane (Fri Aug 31 2007 - 15:08:45 EDT)
  • Alvaro Herrera (Fri Aug 31 2007 - 14:51:28 EDT)
  • Alvaro Herrera (Fri Aug 31 2007 - 14:47:44 EDT)
  • Pallav Kalva (Fri Aug 31 2007 - 14:42:11 EDT)
  • Mikko Partio (Fri Aug 31 2007 - 14:31:47 EDT)
  • Chris Browne (Fri Aug 31 2007 - 13:46:09 EDT)
  • Mark Lewis (Fri Aug 31 2007 - 12:29:31 EDT)
  • Pallav Kalva (Fri Aug 31 2007 - 12:25:16 EDT)
  • Alvaro Herrera (Fri Aug 31 2007 - 12:11:58 EDT)
  • Pallav Kalva (Fri Aug 31 2007 - 12:05:36 EDT)
  • Tom Lane (Fri Aug 31 2007 - 11:39:35 EDT)
  • Pallav Kalva (Fri Aug 31 2007 - 11:30:47 EDT)
• [PERFORM] 8.2 Query 10 times slower than 8.1 (view-heavy)
  • Evan Carroll (Tue Aug 28 2007 - 12:21:54 EDT)
  • Evan Carroll (Tue Aug 28 2007 - 12:30:19 EDT)
  • Kevin Grittner (Tue Aug 28 2007 - 12:20:26 EDT)
  • Joshua D. Drake (Tue Aug 28 2007 - 12:17:28 EDT)
  • Gregory Stark (Tue Aug 28 2007 - 11:58:12 EDT)
  • Scott Marlowe (Tue Aug 28 2007 - 11:32:01 EDT)
  • Evan Carroll (Tue Aug 28 2007 - 11:22:11 EDT)
• [PERFORM] 8.2.4 Chooses Bad Query Plan
  • Tom Lane (Tue Aug 28 2007 - 17:06:12 EDT)
  • Pallav Kalva (Tue Aug 28 2007 - 15:28:59 EDT)
  • Tom Lane (Tue Aug 28 2007 - 14:36:13 EDT)
  • Pallav Kalva (Tue Aug 28 2007 - 11:09:00 EDT)
• [PERFORM] [GENERAL] Shared memory usage
  • Max Zorloff (Sat Aug 25 2007 - 18:32:59 EDT)
  • Max Zorloff (Sat Aug 25 2007 - 18:22:23 EDT)
  • Martijn van Oosterhout (Sat Aug 25 2007 - 16:39:52 EDT)
• [PERFORM] [HACKERS] Proposal: Pluggable Optimizer Interface
  • Tom Lane (Mon Aug 13 2007 - 19:18:41 EDT)
  • Josh Berkus (Mon Aug 13 2007 - 19:08:02 EDT)
  • Tom Lane (Mon Aug 13 2007 - 18:24:27 EDT)
  • Julius Stroffek (Mon Aug 13 2007 - 17:27:56 EDT)
  • Tom Lane (Mon Aug 13 2007 - 17:23:23 EDT)
  • Stefan Kaltenbrunner (Mon Aug 13 2007 - 16:20:35 EDT)
• [PERFORM] [pgsql-jobs] Looking for database hosting
  • Andrew Hammond (Sun Aug 19 2007 - 20:37:07 EDT)
  • Leon Mergen (Sun Aug 19 2007 - 17:49:02 EDT)
  • Luke Lonergan (Sun Aug 19 2007 - 16:17:04 EDT)
  • Andrew Hammond (Sun Aug 19 2007 - 15:48:10 EDT)
• [PERFORM] [Solved] Postgres performance problem
  • Vivek Khera (Fri Aug 31 2007 - 15:36:37 EDT)
  • Richard Huxton (Thu Aug 30 2007 - 14:07:20 EDT)
  • Mark Lewis (Thu Aug 30 2007 - 14:08:47 EDT)
  • Decibel! (Thu Aug 30 2007 - 13:31:51 EDT)
  • Ruben Rubio (Thu Aug 30 2007 - 05:50:04 EDT)
• [PERFORM] asynchronous commit feature
  • Merlin Moncure (Mon Aug 27 2007 - 17:18:05 EDT)
  • Decibel! (Mon Aug 27 2007 - 16:11:38 EDT)
  • Merlin Moncure (Thu Aug 23 2007 - 09:09:00 EDT)
• [PERFORM] Autovacuum is running forever
  • Sachchida Ojha (Tue Aug 21 2007 - 18:20:02 EDT)
  • Scott Marlowe (Tue Aug 21 2007 - 19:16:00 EDT)
  • Scott Marlowe (Tue Aug 21 2007 - 18:19:59 EDT)
  • Sachchida Ojha (Tue Aug 21 2007 - 18:07:44 EDT)
  • Scott Marlowe (Tue Aug 21 2007 - 18:05:05 EDT)
  • Scott Marlowe (Tue Aug 21 2007 - 18:03:25 EDT)
  • Scott Marlowe (Tue Aug 21 2007 - 18:01:23 EDT)
  • Sachchida Ojha (Tue Aug 21 2007 - 17:52:32 EDT)
  • Alvaro Herrera (Tue Aug 21 2007 - 17:54:41 EDT)
  • Sachchida Ojha (Tue Aug 21 2007 - 17:46:12 EDT)
  • Sachchida Ojha (Tue Aug 21 2007 - 17:37:59 EDT)
  • Michael Glaesemann (Tue Aug 21 2007 - 17:35:57 EDT)
  • Sachchida Ojha (Tue Aug 21 2007 - 17:26:45 EDT)
• [PERFORM] Autovacuum running forever
  • Scott Marlowe (Tue Aug 21 2007 - 17:47:18 EDT)
  • Sachchida Ojha (Tue Aug 21 2007 - 17:30:09 EDT)
• [PERFORM] Bad planner decision - bitmap scan instead of index
  • Frank Schoep (Fri Aug 17 2007 - 11:59:30 EDT)
  • Michael Stone (Fri Aug 17 2007 - 11:23:29 EDT)
  • Frank Schoep (Fri Aug 17 2007 - 04:43:18 EDT)
  • hubert depesz lubaczewski (Fri Aug 17 2007 - 03:28:39 EDT)
  • Frank Schoep (Thu Aug 16 2007 - 15:25:14 EDT)
  • Tom Lane (Thu Aug 16 2007 - 13:01:24 EDT)
  • Frank Schoep (Thu Aug 16 2007 - 12:14:02 EDT)
• [PERFORM] Bitmap Heap Scan before using index
  • GOERGLER Paul (Mon Aug 27 2007 - 09:11:57 EDT)
• [PERFORM] Bitmap Index Scan optimization opportunity
  • Heikki Linnakangas (Fri Aug 10 2007 - 16:05:13 EDT)
  • Kevin Grittner (Fri Aug 10 2007 - 15:33:28 EDT)
• [PERFORM] CLOG Patch
  • Simon Riggs (Fri Aug 10 2007 - 16:03:19 EDT)
  • Jignesh K. Shah (Fri Aug 10 2007 - 13:54:41 EDT)
  • Simon Riggs (Fri Aug 03 2007 - 16:29:47 EDT)
  • Jignesh K. Shah (Fri Aug 03 2007 - 16:09:39 EDT)
• [PERFORM] cpu throttling
  • Decibel! (Fri Aug 03 2007 - 18:17:42 EDT)
  • Bryan Murphy (Thu Aug 02 2007 - 14:09:55 EDT)
  • Alan Hodgson (Thu Aug 02 2007 - 12:14:37 EDT)
  • Bryan Murphy (Thu Aug 02 2007 - 12:02:07 EDT)
• [PERFORM] deadlock_timeout parameter in Postgresql.cof
  • Bill Moran (Thu Aug 23 2007 - 14:52:08 EDT)
  • Sachchida Ojha (Thu Aug 23 2007 - 14:23:57 EDT)
  • Sachchida Ojha (Thu Aug 23 2007 - 14:21:59 EDT)
• [PERFORM] Default Performance between 8.0 and 8.1
  • Ted Jordan (Mon Aug 06 2007 - 13:58:19 EDT)
  • Merlin Moncure (Sun Aug 05 2007 - 21:56:35 EDT)
  • Ted Jordan (Sat Aug 04 2007 - 16:35:59 EDT)
• [PERFORM] Dell Hardware Recommendations
  • Dave Cramer (Mon Aug 13 2007 - 20:59:26 EDT)
  • Vivek Khera (Mon Aug 13 2007 - 09:50:11 EDT)
  • Joel Fradkin (Fri Aug 10 2007 - 16:36:46 EDT)
  • Merlin Moncure (Fri Aug 10 2007 - 16:36:07 EDT)
  • Vivek Khera (Fri Aug 10 2007 - 15:42:58 EDT)
  • Merlin Moncure (Fri Aug 10 2007 - 13:30:38 EDT)
  • Merlin Moncure (Fri Aug 10 2007 - 06:53:20 EDT)
  • Merlin Moncure (Fri Aug 10 2007 - 06:35:51 EDT)
  • david(at)lang.hm (Fri Aug 10 2007 - 01:27:43 EDT)
  • Greg Smith (Fri Aug 10 2007 - 01:23:13 EDT)
  • Decibel! (Fri Aug 10 2007 - 00:58:58 EDT)
  • Scott Marlowe (Thu Aug 09 2007 - 21:58:19 EDT)
  • Joe Uhl (Thu Aug 09 2007 - 20:54:20 EDT)
  • Arjen van der Meijden (Thu Aug 09 2007 - 18:21:01 EDT)
  • Decibel! (Thu Aug 09 2007 - 18:05:02 EDT)
  • Merlin Moncure (Thu Aug 09 2007 - 17:50:10 EDT)
  • Decibel! (Thu Aug 09 2007 - 17:15:53 EDT)
  • Joe Uhl (Thu Aug 09 2007 - 15:47:09 EDT)
• [PERFORM] Extreme slow select query 8.2.4
  • Henrik Zagerholm (Mon Aug 06 2007 - 16:16:55 EDT)
  • Heikki Linnakangas (Mon Aug 06 2007 - 15:47:22 EDT)
  • Henrik Zagerholm (Mon Aug 06 2007 - 11:50:22 EDT)
  • Tom Lane (Mon Aug 06 2007 - 10:58:47 EDT)
  • Henrik Zagerholm (Mon Aug 06 2007 - 05:19:10 EDT)
• [PERFORM] Fast tsearch2, trigram matching on short phrases
  • Carlo Stonebanks (Wed Aug 22 2007 - 17:09:52 EDT)
  • Oleg Bartunov (Wed Aug 22 2007 - 16:43:07 EDT)
  • Carlo Stonebanks (Wed Aug 22 2007 - 16:31:08 EDT)
  • Carlo Stonebanks (Wed Aug 22 2007 - 16:25:16 EDT)
  • Oleg Bartunov (Wed Aug 22 2007 - 14:48:44 EDT)
  • Steinar H. Gunderson (Wed Aug 22 2007 - 12:29:50 EDT)
  • Carlo Stonebanks (Wed Aug 22 2007 - 12:02:54 EDT)
• [PERFORM] Fwd: Table Partitioning
  • Henrik (Sat Aug 18 2007 - 07:11:58 EDT)
  • Nurlan Mukhanov (Fri Aug 10 2007 - 16:58:29 EDT)
• [PERFORM] Help optimize view
  • Relyea, Mike (Mon Aug 20 2007 - 10:02:48 EDT)
  • Kevin Grittner (Sat Aug 18 2007 - 21:11:59 EDT)
  • Kevin Grittner (Sat Aug 18 2007 - 21:01:50 EDT)
  • Relyea, Mike (Fri Aug 10 2007 - 12:57:33 EDT)
  • Kevin Grittner (Mon Aug 13 2007 - 18:37:33 EDT)
  • Kevin Grittner (Mon Aug 13 2007 - 17:25:49 EDT)
  • Relyea, Mike (Mon Aug 13 2007 - 17:00:28 EDT)
  • Tom Lane (Mon Aug 13 2007 - 16:17:23 EDT)
  • Kevin Grittner (Mon Aug 13 2007 - 16:02:15 EDT)
  • Relyea, Mike (Mon Aug 13 2007 - 14:48:30 EDT)
  • Kevin Grittner (Mon Aug 13 2007 - 12:25:01 EDT)
  • Relyea, Mike (Mon Aug 13 2007 - 11:35:44 EDT)
  • Tom Lane (Fri Aug 10 2007 - 17:43:38 EDT)
  • Relyea, Mike (Fri Aug 10 2007 - 15:04:44 EDT)
• [PERFORM] High update activity, PostgreSQL vs BigDBMS
  • Guy Rouillier (Fri Aug 17 2007 - 18:48:05 EDT)
• [PERFORM] How to ENABLE SQL capturing???
  • Joshua D. Drake (Mon Aug 13 2007 - 12:15:35 EDT)
  • Gregory Stark (Mon Aug 13 2007 - 12:02:41 EDT)
  • Joshua D. Drake (Mon Aug 13 2007 - 11:42:50 EDT)
  • Jonathan Ellis (Mon Aug 13 2007 - 11:04:07 EDT)
  • Joshua D. Drake (Fri Aug 10 2007 - 17:50:34 EDT)
  • smiley2211 (Fri Aug 10 2007 - 17:43:13 EDT)
  • Jeff Frost (Fri Aug 10 2007 - 16:10:02 EDT)
  • smiley2211 (Fri Aug 10 2007 - 13:54:35 EDT)
  • Bryan Murphy (Wed Aug 08 2007 - 16:57:52 EDT)
  • Steinar H. Gunderson (Wed Aug 08 2007 - 16:36:12 EDT)
  • smiley2211 (Wed Aug 08 2007 - 16:02:24 EDT)
• [PERFORM] Implementing an regex filter
  • Enrico Weigelt (Wed Aug 08 2007 - 08:16:11 EDT)
• [PERFORM] index & Bitmap Heap Scan
  • Paul (Wed Aug 29 2007 - 04:16:45 EDT)
  • Tom Lane (Tue Aug 28 2007 - 12:55:58 EDT)
  • Paul (Tue Aug 28 2007 - 04:49:09 EDT)
• [PERFORM] Indexscan is only used if we use "limit n"
  • Josh Berkus (Thu Aug 16 2007 - 19:10:53 EDT)
  • Mark Lewis (Wed Aug 15 2007 - 16:03:10 EDT)
  • joao (Wed Aug 15 2007 - 16:02:43 EDT)
  • Alvaro Herrera (Wed Aug 15 2007 - 16:00:39 EDT)
  • Sebastián Baioni (Wed Aug 15 2007 - 15:36:45 EDT)
• [PERFORM] Installing PostgreSQL
  • Campbell, Lance (Thu Aug 23 2007 - 13:37:51 EDT)
  • Richard Huxton (Thu Aug 23 2007 - 13:26:19 EDT)
  • Greg Smith (Thu Aug 23 2007 - 13:25:42 EDT)
  • Campbell, Lance (Thu Aug 23 2007 - 13:19:25 EDT)
  • Richard Huxton (Thu Aug 23 2007 - 13:08:22 EDT)
  • Campbell, Lance (Thu Aug 23 2007 - 12:47:15 EDT)
• [PERFORM] Integrated perc 5/i
  • Luke Lonergan (Thu Aug 16 2007 - 21:12:49 EDT)
  • Decibel! (Thu Aug 16 2007 - 18:41:00 EDT)
  • Scott Marlowe (Thu Aug 16 2007 - 18:25:07 EDT)
  • Merlin Moncure (Thu Aug 16 2007 - 18:14:54 EDT)
  • tyrrill_ed(at)emc.com (Thu Aug 16 2007 - 13:30:11 EDT)
  • Decibel! (Thu Aug 16 2007 - 15:51:10 EDT)
  • Steinar H. Gunderson (Thu Aug 16 2007 - 13:59:15 EDT)
  • Michael Ben-Nes (Thu Aug 16 2007 - 13:47:25 EDT)
  • Steinar H. Gunderson (Thu Aug 16 2007 - 12:43:47 EDT)
  • Merlin Moncure (Thu Aug 16 2007 - 08:59:51 EDT)
  • Michael Ben-Nes (Thu Aug 16 2007 - 04:26:52 EDT)
• [PERFORM] io storm on checkpoints, postgresql 8.2.4, linux
  • Decibel! (Tue Aug 28 2007 - 17:34:04 EDT)
  • Erik Jones (Tue Aug 28 2007 - 11:00:57 EDT)
  • Kenneth Marshall (Wed Aug 22 2007 - 11:57:19 EDT)
  • Greg Smith (Thu Aug 23 2007 - 13:00:57 EDT)
  • Dmitry Potapov (Thu Aug 23 2007 - 10:37:39 EDT)
  • Greg Smith (Wed Aug 22 2007 - 16:30:35 EDT)
  • Dmitry Potapov (Wed Aug 22 2007 - 12:28:00 EDT)
  • Dmitry Potapov (Wed Aug 22 2007 - 12:22:59 EDT)
  • Dmitry Potapov (Wed Aug 22 2007 - 12:16:15 EDT)
  • Joshua D. Drake (Wed Aug 22 2007 - 12:01:43 EDT)
  • Mark Mielke (Wed Aug 22 2007 - 11:57:33 EDT)
  • Dmitry Potapov (Wed Aug 22 2007 - 11:33:35 EDT)
• [PERFORM] LIKE query verses =
  • Tom Lane (Wed Aug 29 2007 - 13:51:41 EDT)
  • Mark Lewis (Wed Aug 29 2007 - 13:12:31 EDT)
  • Karthikeyan Mahadevan (Wed Aug 29 2007 - 08:31:43 EDT)
• [PERFORM] Long running transaction in pg_activity_log
  • Farhan Mughal (Wed Aug 22 2007 - 17:58:40 EDT)
  • Tobias Brox (Wed Aug 22 2007 - 17:08:58 EDT)
  • Sachchida Ojha (Wed Aug 22 2007 - 16:54:29 EDT)
  • Sachchida Ojha (Wed Aug 22 2007 - 16:40:09 EDT)
• [PERFORM] long-running query - needs tuning
  • Tom Lane (Thu Aug 23 2007 - 14:56:19 EDT)
  • Kevin Kempter (Thu Aug 23 2007 - 13:16:57 EDT)
• [PERFORM] Looking for database hosting: FIX CC LIST!!
  • Josh Berkus (Sun Aug 19 2007 - 17:51:39 EDT)
• [PERFORM] mid 2007 "best bang for the buck" hardware opinions
  • Vivek Khera (Thu Aug 09 2007 - 10:40:30 EDT)
  • justin (Thu Aug 09 2007 - 00:45:27 EDT)
  • Scott Marlowe (Thu Aug 09 2007 - 00:06:30 EDT)
  • justin (Wed Aug 08 2007 - 23:34:42 EDT)
• [PERFORM] Optimising "in" queries
  • Stephen Davies (Thu Aug 23 2007 - 19:47:48 EDT)
  • Stephen Davies (Wed Aug 22 2007 - 08:08:56 EDT)
  • Tom Lane (Thu Aug 23 2007 - 22:19:40 EDT)
  • Alvaro Herrera (Thu Aug 23 2007 - 15:46:42 EDT)
  • Stephen Davies (Wed Aug 22 2007 - 19:30:13 EDT)
  • Russell Smith (Thu Aug 23 2007 - 03:42:28 EDT)
  • Russell Smith (Thu Aug 23 2007 - 03:34:01 EDT)
  • Michael Glaesemann (Wed Aug 22 2007 - 20:21:05 EDT)
  • Kevin Grittner (Wed Aug 22 2007 - 14:50:26 EDT)
  • Michael Glaesemann (Wed Aug 22 2007 - 09:25:26 EDT)
  • Russell Smith (Wed Aug 22 2007 - 06:58:59 EDT)
  • Scott Marlowe (Wed Aug 22 2007 - 00:20:25 EDT)
  • Stephen Davies (Tue Aug 21 2007 - 22:40:36 EDT)
• [PERFORM] Partioning tsearch2 a table into chunks and accessing via views
  • Erik Jones (Sat Aug 25 2007 - 15:58:06 EDT)
  • Brandon Shalton (Fri Aug 24 2007 - 23:54:24 EDT)
  • Benjamin Arai (Fri Aug 24 2007 - 20:41:48 EDT)
• [PERFORM] partitioned table and ORDER BY indexed_field DESC LIMIT 1
  • Heikki Linnakangas (Tue Aug 28 2007 - 06:20:16 EDT)
  • Tomas Tamosaitis (Mon Aug 27 2007 - 08:57:29 EDT)
  • Luke Lonergan (Fri Aug 24 2007 - 12:25:53 EDT)
  • Luke Lonergan (Fri Aug 24 2007 - 12:20:28 EDT)
  • Heikki Linnakangas (Fri Aug 24 2007 - 06:38:26 EDT)
  • Anton (Fri Aug 24 2007 - 06:32:43 EDT)
  • Mikko Partio (Fri Aug 24 2007 - 06:24:31 EDT)
  • Anton (Fri Aug 24 2007 - 04:53:05 EDT)
• [PERFORM] Performance across multiple schemas
  • Robins Tharakan (Tue Aug 28 2007 - 21:50:51 EDT)
  • Robins (Tue Aug 28 2007 - 22:45:09 EDT)
  • Tom Lane (Tue Aug 28 2007 - 09:49:26 EDT)
  • Robins (Tue Aug 28 2007 - 09:44:06 EDT)
  • Robins (Tue Aug 28 2007 - 09:05:24 EDT)
• [PERFORM] Performance issue
  • Willo van der Merwe (Mon Aug 27 2007 - 08:16:48 EDT)
  • Willo van der Merwe (Tue Aug 28 2007 - 05:34:18 EDT)
  • Tom Lane (Mon Aug 27 2007 - 11:55:46 EDT)
  • Bill Moran (Mon Aug 27 2007 - 10:45:20 EDT)
  • Willo van der Merwe (Mon Aug 27 2007 - 09:41:42 EDT)
• [PERFORM] Performance issue with nested loop
  • Jens Reufsteck (Wed Aug 29 2007 - 06:15:49 EDT)
  • Jens Reufsteck (Wed Aug 29 2007 - 10:33:14 EDT)
• [PERFORM] Performance on writable views
  • Jim Nasby (Mon Aug 13 2007 - 18:17:16 EDT)
  • Joshua D. Drake (Sat Aug 11 2007 - 09:58:41 EDT)
  • Heikki Linnakangas (Sat Aug 11 2007 - 03:42:54 EDT)
  • Enrico Weigelt (Wed Aug 08 2007 - 08:40:54 EDT)
• [PERFORM] Performance problem with table containing a lot of text (blog)
  • Heikki Linnakangas (Wed Aug 29 2007 - 06:14:20 EDT)
  • Kari Lavikka (Wed Aug 29 2007 - 05:39:13 EDT)
  • Heikki Linnakangas (Wed Aug 29 2007 - 04:29:21 EDT)
  • Kari Lavikka (Tue Aug 28 2007 - 15:10:33 EDT)
  • Dan Harris (Tue Aug 28 2007 - 15:04:31 EDT)
  • Kari Lavikka (Tue Aug 28 2007 - 14:53:37 EDT)
• [PERFORM] Performance problems with large telemetric datasets on 7.4.2
  • Scott Marlowe (Tue Aug 07 2007 - 10:07:09 EDT)
  • Sven Clement (Mon Aug 06 2007 - 05:54:52 EDT)
  • Heikki Linnakangas (Mon Aug 06 2007 - 05:51:09 EDT)
  • Ragnar (Mon Aug 06 2007 - 05:50:25 EDT)
  • Sven Clement (Mon Aug 06 2007 - 03:10:01 EDT)
  • Heikki Linnakangas (Sun Aug 05 2007 - 12:07:35 EDT)
  • Sven Clement (Sat Aug 04 2007 - 16:03:02 EDT)
  • Tom Lane (Fri Aug 03 2007 - 18:34:09 EDT)
  • Andrew Kroeger (Fri Aug 03 2007 - 17:13:27 EDT)
  • Josh Berkus (Fri Aug 03 2007 - 13:56:23 EDT)
  • Sven Clement (Fri Aug 03 2007 - 11:57:11 EDT)
  • Dan Langille (Fri Aug 03 2007 - 10:17:58 EDT)
  • Mark Lewis (Fri Aug 03 2007 - 10:20:36 EDT)
  • Sven Clement (Fri Aug 03 2007 - 09:52:38 EDT)
• [PERFORM] Performance Solaris vs Linux
  • Julius Stroffek (Tue Aug 21 2007 - 11:49:13 EDT)
  • Chris Mair (Sat Aug 18 2007 - 06:13:45 EDT)
  • Alvaro Herrera (Fri Aug 17 2007 - 23:08:04 EDT)
  • Fredrik Bertilsson (Fri Aug 17 2007 - 02:50:00 EDT)
• [PERFORM] Planner making wrong decisions 8.2.4. Insane cost calculations.
  • Gregory Stark (Mon Aug 06 2007 - 11:31:14 EDT)
  • Henrik Zagerholm (Mon Aug 06 2007 - 10:46:43 EDT)
  • Gregory Stark (Mon Aug 06 2007 - 09:07:17 EDT)
  • Henrik Zagerholm (Mon Aug 06 2007 - 08:21:10 EDT)
• [PERFORM] Poor Performance after Upgrade
  • Russell Smith (Wed Aug 22 2007 - 06:52:30 EDT)
  • vincent (Wed Aug 22 2007 - 05:19:11 EDT)
  • Steinar H. Gunderson (Wed Aug 22 2007 - 00:24:25 EDT)
  • Ben Perrault (Tue Aug 21 2007 - 01:17:14 EDT)
• [PERFORM] Postgres configuration for 64 CPUs, 128 GB RAM...
  • Luke Lonergan (Wed Aug 01 2007 - 14:10:14 EDT)
• [PERFORM] Postgres optimizer
  • Mark Lewis (Fri Aug 03 2007 - 14:28:33 EDT)
  • Mouhamadou Dia (Fri Aug 03 2007 - 13:58:51 EDT)
• [PERFORM] Postgres performance problem
  • ruben(at)rentalia.com (Thu Aug 30 2007 - 03:52:16 EDT)
  • Anton Melser (Tue Aug 28 2007 - 14:36:11 EDT)
  • Bill Moran (Mon Aug 27 2007 - 09:29:35 EDT)
  • ruben(at)rentalia.com (Mon Aug 27 2007 - 08:52:22 EDT)
  • Chris Mair (Mon Aug 27 2007 - 08:33:51 EDT)
  • Ruben Rubio (Mon Aug 27 2007 - 07:41:45 EDT)
• [PERFORM] Proposal: Pluggable Optimizer Interface
  • Julius Stroffek (Mon Aug 13 2007 - 15:49:56 EDT)
• [PERFORM] RAID 10 or RAID 10 + RAID 1
  • Decibel! (Tue Aug 14 2007 - 17:31:50 EDT)
  • Michael Ben-Nes (Tue Aug 14 2007 - 06:14:39 EDT)
• [PERFORM] Raid Configurations
  • Decibel! (Thu Aug 23 2007 - 13:13:43 EDT)
  • Merlin Moncure (Fri Aug 17 2007 - 19:55:59 EDT)
  • Robert D Oden (Thu Aug 16 2007 - 12:32:24 EDT)
• [PERFORM] schema design question
  • Adam Tauno Williams (Sun Aug 19 2007 - 20:22:07 EDT)
  • Steinar H. Gunderson (Sun Aug 19 2007 - 16:42:34 EDT)
  • David Fetter (Sun Aug 19 2007 - 16:23:34 EDT)
  • mark overmeer (Sun Aug 19 2007 - 16:13:08 EDT)
  • David Fetter (Sun Aug 19 2007 - 14:41:15 EDT)
  • Steinar H. Gunderson (Sun Aug 19 2007 - 14:26:58 EDT)
  • David Fetter (Sun Aug 19 2007 - 14:12:16 EDT)
  • mark overmeer (Sun Aug 19 2007 - 11:23:14 EDT)
  • Adam Tauno Williams (Sun Aug 19 2007 - 10:24:14 EDT)
  • mark overmeer (Sun Aug 19 2007 - 09:19:52 EDT)
• [PERFORM] schemas to limit data access
  • Brennan, Sean (IMS) (Fri Aug 31 2007 - 23:08:34 EDT)
  • Brennan, Sean (IMS) (Fri Aug 31 2007 - 23:02:25 EDT)
  • Brennan, Sean (IMS) (Fri Aug 31 2007 - 23:02:32 EDT)
• [PERFORM] select count(*) performance
  • Scott Marlowe (Fri Aug 17 2007 - 21:14:01 EDT)
  • Detlef Rudolph (Sat Aug 11 2007 - 11:54:41 EDT)
  • Kevin Grittner (Mon Aug 13 2007 - 10:07:03 EDT)
  • valgog (Mon Aug 13 2007 - 07:38:09 EDT)
  • Kevin Grittner (Sat Aug 11 2007 - 11:32:08 EDT)
  • Brian Hurt (Fri Aug 10 2007 - 09:08:18 EDT)
  • Merlin Moncure (Fri Aug 10 2007 - 07:44:21 EDT)
  • runic (Wed Aug 08 2007 - 09:01:25 EDT)
  • slawekj (Thu Aug 09 2007 - 10:44:41 EDT)
• [PERFORM] select on 1milion register = 6s
  • Jan Dittmer (Wed Aug 01 2007 - 13:37:11 EDT)
• [PERFORM] server performance issues - suggestions for tuning
  • Scott Marlowe (Tue Aug 28 2007 - 10:32:01 EDT)
  • Andrew Sullivan (Tue Aug 28 2007 - 10:26:52 EDT)
  • Kevin Grittner (Tue Aug 28 2007 - 09:12:06 EDT)
  • Richard Huxton (Tue Aug 28 2007 - 03:50:54 EDT)
  • Kevin Kempter (Tue Aug 28 2007 - 00:13:14 EDT)
• [PERFORM] Shared memory usage
  • Max Zorloff (Thu Aug 30 2007 - 02:40:32 EDT)
  • Greg Smith (Wed Aug 29 2007 - 15:26:06 EDT)
  • Max Zorloff (Mon Aug 27 2007 - 09:18:19 EDT)
  • Adam Tauno Williams (Mon Aug 27 2007 - 06:21:43 EDT)
  • Max Zorloff (Sat Aug 25 2007 - 17:22:58 EDT)
• [PERFORM] significant vacuum issues - looking for suggestions
  • Kevin Kempter (Mon Aug 27 2007 - 18:06:00 EDT)
  • Kevin Kempter (Mon Aug 27 2007 - 18:03:52 EDT)
  • Decibel! (Mon Aug 27 2007 - 18:04:39 EDT)
  • Kevin Kempter (Mon Aug 27 2007 - 18:00:01 EDT)
  • Kevin Grittner (Mon Aug 27 2007 - 17:56:33 EDT)
  • Decibel! (Mon Aug 27 2007 - 17:00:41 EDT)
  • Kevin Kempter (Sat Aug 25 2007 - 01:34:23 EDT)
  • Tom Lane (Fri Aug 24 2007 - 17:39:22 EDT)
  • Bill Moran (Fri Aug 24 2007 - 17:08:13 EDT)
  • Kevin Grittner (Fri Aug 24 2007 - 16:52:20 EDT)
  • Bill Moran (Fri Aug 24 2007 - 16:41:44 EDT)
  • Kevin Kempter (Fri Aug 24 2007 - 15:57:23 EDT)
• [PERFORM] Simple select hangs while CPU close to 100% - Analyze
  • Alvaro Herrera (Fri Aug 17 2007 - 23:03:49 EDT)
  • Jozsef Szalay (Fri Aug 17 2007 - 18:54:29 EDT)
• [PERFORM] Stable function optimisation
  • Philipp Specht (Mon Aug 13 2007 - 16:12:33 EDT)
  • Philipp Specht (Wed Aug 15 2007 - 16:48:34 EDT)
  • Tom Lane (Mon Aug 13 2007 - 17:01:40 EDT)
  • Philipp Specht (Mon Aug 13 2007 - 16:37:59 EDT)
• [PERFORM] Terminology Question
  • Joshua D. Drake (Mon Aug 20 2007 - 13:55:15 EDT)
  • Scott Marlowe (Mon Aug 20 2007 - 10:50:18 EDT)
  • Campbell, Lance (Mon Aug 20 2007 - 10:36:00 EDT)
• [PERFORM] Transaction Log
  • Alan Hodgson (Wed Aug 29 2007 - 16:36:48 EDT)
  • Bill Moran (Wed Aug 29 2007 - 16:21:53 EDT)
  • Steinar H. Gunderson (Wed Aug 29 2007 - 16:17:58 EDT)
  • Steve Atkins (Wed Aug 29 2007 - 16:11:32 EDT)
  • Mark Mielke (Wed Aug 29 2007 - 15:54:05 EDT)
  • Markus Benne (Wed Aug 29 2007 - 15:22:03 EDT)
  • mbguy2000-1(at)yahoo.com (Wed Aug 29 2007 - 15:24:34 EDT)
• [PERFORM] TRUNCATE TABLE
  • Tom Lane (Mon Aug 06 2007 - 14:46:14 EDT)
  • Decibel! (Mon Aug 06 2007 - 01:48:54 EDT)
  • Adriaan van Os (Sat Aug 04 2007 - 17:39:31 EDT)
  • Alvaro Herrera (Wed Aug 01 2007 - 11:11:39 EDT)
  • Kevin Grittner (Wed Aug 01 2007 - 10:22:00 EDT)
  • Adriaan van Os (Wed Aug 01 2007 - 04:27:10 EDT)
• [PERFORM] Update table performance
  • Piotr Ko³aczkowski (Tue Aug 07 2007 - 09:44:17 EDT)
  • Kenneth Marshall (Tue Aug 07 2007 - 09:15:37 EDT)
  • Decibel! (Thu Aug 09 2007 - 11:32:15 EDT)
  • Trevor Talbot (Thu Aug 09 2007 - 09:41:50 EDT)
  • Michael Stone (Thu Aug 09 2007 - 09:13:44 EDT)
  • Merlin Moncure (Thu Aug 09 2007 - 08:34:09 EDT)
  • Decibel! (Wed Aug 08 2007 - 13:28:14 EDT)
  • Erik Jones (Wed Aug 08 2007 - 11:15:41 EDT)
  • Heikki Linnakangas (Wed Aug 08 2007 - 04:00:48 EDT)
  • Erik Jones (Tue Aug 07 2007 - 21:46:20 EDT)
  • Mark Makarowsky (Tue Aug 07 2007 - 19:13:00 EDT)
  • Decibel! (Tue Aug 07 2007 - 17:42:28 EDT)
  • Scott Marlowe (Tue Aug 07 2007 - 15:36:18 EDT)
  • Chris Browne (Tue Aug 07 2007 - 14:03:06 EDT)
  • Decibel! (Tue Aug 07 2007 - 13:59:14 EDT)
  • Alan Hodgson (Tue Aug 07 2007 - 12:03:49 EDT)
  • Scott Marlowe (Tue Aug 07 2007 - 10:53:31 EDT)
  • Richard Huxton (Tue Aug 07 2007 - 09:33:19 EDT)
  • Mark Makarowsky (Tue Aug 07 2007 - 08:58:35 EDT)
• [PERFORM] When/if to Reindex
  • Tom Lane (Fri Aug 24 2007 - 17:43:57 EDT)
  • Gregory Stark (Fri Aug 24 2007 - 16:06:53 EDT)
  • Steven Flatt (Fri Aug 24 2007 - 13:49:01 EDT)
  • Tom Lane (Fri Aug 24 2007 - 13:28:55 EDT)
  • Steven Flatt (Fri Aug 24 2007 - 12:56:20 EDT)
  • Tom Lane (Fri Aug 24 2007 - 12:15:25 EDT)
  • Steven Flatt (Fri Aug 24 2007 - 10:22:38 EDT)
  • Gregory Stark (Fri Aug 24 2007 - 02:49:16 EDT)
  • Mark Kirkwood (Fri Aug 24 2007 - 01:11:31 EDT)
  • Tom Lane (Thu Aug 23 2007 - 23:59:02 EDT)
  • Steven Flatt (Thu Aug 23 2007 - 18:25:25 EDT)
  • Gregory Stark (Wed Aug 22 2007 - 19:50:53 EDT)
  • Steven Flatt (Wed Aug 22 2007 - 12:55:28 EDT)
  • Steven Flatt (Thu Aug 09 2007 - 09:51:42 EDT)
  • Bill Moran (Thu Aug 09 2007 - 09:04:11 EDT)
  • Tom Lane (Wed Aug 08 2007 - 21:51:48 EDT)
  • Decibel! (Wed Aug 08 2007 - 16:35:54 EDT)
  • Bill Moran (Wed Aug 08 2007 - 15:27:57 EDT)
  • Steven Flatt (Wed Aug 08 2007 - 15:12:44 EDT)
  • Vivek Khera (Wed Aug 08 2007 - 13:42:34 EDT)
• [PERFORM] Why are distinct and group by choosing different plans?
  • Tom Lane (Thu Aug 02 2007 - 20:48:07 EDT)
  • Gregory Stark (Thu Aug 02 2007 - 18:37:43 EDT)
  • Ron Mayer (Thu Aug 02 2007 - 17:32:14 EDT)
• Fwd: [PERFORM] 8.2 Query 10 times slower than 8.1 (view-heavy)
  • Mark Lewis (Fri Aug 31 2007 - 20:09:17 EDT)
  • Tom Lane (Fri Aug 31 2007 - 19:39:25 EDT)
  • Tom Lane (Tue Aug 28 2007 - 14:48:00 EDT)
  • Mark Lewis (Tue Aug 28 2007 - 12:51:31 EDT)
  • Evan Carroll (Tue Aug 28 2007 - 12:24:57 EDT)
• RES: [PERFORM] Improving select peformance
  • Alvaro Herrera (Wed Aug 01 2007 - 12:52:48 EDT)
  • Carlos H. Reimer (Wed Aug 01 2007 - 11:12:39 EDT)
• RES: RES: [PERFORM] Improving select peformance
  • Tom Lane (Thu Aug 02 2007 - 22:13:01 EDT)
  • Carlos H. Reimer (Thu Aug 02 2007 - 21:47:25 EDT)
  • Carlos H. Reimer (Wed Aug 01 2007 - 20:26:24 EDT)
• RES: RES: RES: [PERFORM] Improving select peformance
  • Carlos H. Reimer (Sat Aug 04 2007 - 10:02:26 EDT)

  This archive was generated by hypermail 2.1.8 : Thu Jul 31 2008 - 17:16:56 EDT