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

• [GENERAL] [PERFORM] Parrallel query execution for UNION ALL Queries
  • Luke Lonergan (Thu Jul 19 2007 - 10:30:43 EDT)
  • Dimitri Fontaine (Thu Jul 19 2007 - 06:14:29 EDT)
• [PERFORM] 8.2 -> 8.3 performance numbers
  • Merlin Moncure (Tue Jul 24 2007 - 21:28:00 EDT)
  • Jim Nasby (Fri Jul 20 2007 - 14:32:34 EDT)
  • Josh Berkus (Fri Jul 20 2007 - 13:03:31 EDT)
  • Jim Nasby (Fri Jul 20 2007 - 00:58:35 EDT)
• [PERFORM] [PERFORMANCE] is it possible to force an index to be held in memory?
  • valgog (Mon Jul 02 2007 - 06:04:46 EDT)
• [PERFORM] Advice about how to delete
  • Heikki Linnakangas (Fri Jul 06 2007 - 12:18:53 EDT)
  • Arnau (Fri Jul 06 2007 - 11:56:21 EDT)
  • Michael Glaesemann (Fri Jul 06 2007 - 11:04:54 EDT)
  • Arnau (Fri Jul 06 2007 - 10:42:31 EDT)
• [PERFORM] Affect of Reindexing on Vacuum Times
  • Jim Nasby (Thu Jul 26 2007 - 19:27:59 EDT)
  • Y Sidhu (Wed Jul 25 2007 - 14:53:16 EDT)
• [PERFORM] best use of an EMC SAN
  • Dave Cramer (Wed Jul 11 2007 - 14:45:06 EDT)
  • Greg Smith (Wed Jul 11 2007 - 14:35:50 EDT)
  • Andrew Sullivan (Wed Jul 11 2007 - 14:27:01 EDT)
  • Jim Nasby (Wed Jul 11 2007 - 13:58:12 EDT)
  • Chris Browne (Wed Jul 11 2007 - 13:39:39 EDT)
  • Andrew Sullivan (Wed Jul 11 2007 - 11:33:37 EDT)
  • Cott Lang (Wed Jul 11 2007 - 10:40:01 EDT)
  • Dave Cramer (Wed Jul 11 2007 - 10:14:41 EDT)
  • Gregory Stark (Wed Jul 11 2007 - 10:05:37 EDT)
  • Dan Gorman (Wed Jul 11 2007 - 09:18:10 EDT)
  • Dave Cramer (Wed Jul 11 2007 - 09:03:27 EDT)
• [PERFORM] bitmap-index-scan slower than normal index scan
  • A. Kretschmer (Thu Jul 12 2007 - 01:06:31 EDT)
  • Andreas Kretschmer (Wed Jul 11 2007 - 16:19:58 EDT)
  • Tom Lane (Wed Jul 11 2007 - 16:04:33 EDT)
  • Alex Deucher (Wed Jul 11 2007 - 16:01:58 EDT)
  • Alex Deucher (Wed Jul 11 2007 - 16:01:30 EDT)
  • A. Kretschmer (Wed Jul 11 2007 - 15:31:58 EDT)
  • Alex Deucher (Wed Jul 11 2007 - 14:52:01 EDT)
  • Andreas Kretschmer (Wed Jul 11 2007 - 14:36:38 EDT)
• [PERFORM] Database Statistics???
  • Alvaro Herrera (Fri Jul 13 2007 - 17:05:02 EDT)
  • Mario Weilguni (Fri Jul 13 2007 - 14:19:51 EDT)
  • smiley2211 (Fri Jul 13 2007 - 14:27:50 EDT)
  • Ansgar -59cobalt- Wiechers (Fri Jul 13 2007 - 13:52:49 EDT)
  • Tom Arthurs (Fri Jul 13 2007 - 13:39:19 EDT)
  • smiley2211 (Fri Jul 13 2007 - 12:53:29 EDT)
• [PERFORM] deadlock detected when calling function (Call function_name)
  • Alvaro Herrera (Tue Jul 31 2007 - 11:28:06 EDT)
  • Sachchida Ojha (Tue Jul 31 2007 - 11:00:48 EDT)
• [PERFORM] deadlock detected when calling function (Callfunction_name)
  • Sachchida Ojha (Tue Jul 31 2007 - 12:38:51 EDT)
• [PERFORM] Delete Cascade FK speed issue
  • Axel Rau (Wed Jul 04 2007 - 03:30:24 EDT)
  • Mark Lewis (Tue Jul 03 2007 - 12:01:05 EDT)
  • Michael Fuhr (Tue Jul 03 2007 - 07:33:42 EDT)
  • Patric de Waha (Tue Jul 03 2007 - 02:05:27 EDT)
• [PERFORM] Direct I/O
  • Jignesh K. Shah (Fri Jul 06 2007 - 12:03:12 EDT)
  • Alvaro Herrera (Fri Jul 06 2007 - 10:40:35 EDT)
  • lai yoke hman (Thu Jul 05 2007 - 22:28:49 EDT)
• [PERFORM] disable archiving
  • valgog (Tue Jul 24 2007 - 03:33:55 EDT)
  • Paul van den Bogaard (Mon Jul 23 2007 - 13:42:06 EDT)
  • Arjen van der Meijden (Mon Jul 23 2007 - 13:39:10 EDT)
  • A. Kretschmer (Mon Jul 23 2007 - 13:37:49 EDT)
  • Alvaro Herrera (Mon Jul 23 2007 - 13:34:20 EDT)
  • Paul van den Bogaard (Mon Jul 23 2007 - 13:24:48 EDT)
• [PERFORM] disk filling up
  • Merlin Moncure (Tue Jul 31 2007 - 12:16:38 EDT)
  • Tom Lane (Tue Jul 31 2007 - 01:19:16 EDT)
  • Merlin Moncure (Fri Jul 27 2007 - 09:44:31 EDT)
  • Yudhvir Singh Sidhu (Thu Jul 26 2007 - 11:06:37 EDT)
  • Mark Kirkwood (Thu Jul 26 2007 - 20:48:36 EDT)
  • Joshua D. Drake (Thu Jul 26 2007 - 10:47:08 EDT)
  • Mark Lewis (Thu Jul 26 2007 - 10:37:23 EDT)
  • Bill Moran (Thu Jul 26 2007 - 09:34:32 EDT)
  • Brandon Shalton (Thu Jul 26 2007 - 12:18:55 EDT)
• [PERFORM] Equivalent queries produce different plans
  • Tom Lane (Tue Jul 10 2007 - 21:25:03 EDT)
  • Craig James (Tue Jul 10 2007 - 21:06:31 EDT)
  • Craig James (Tue Jul 10 2007 - 20:53:17 EDT)
• [PERFORM] Estimating WAL volume
  • Simon Riggs (Mon Jul 16 2007 - 04:02:08 EDT)
  • Greg Smith (Wed Jul 11 2007 - 23:10:36 EDT)
• [PERFORM] Filesystem Direct I/O and WAL sync option
  • Dimitri (Tue Jul 10 2007 - 08:53:18 EDT)
  • Jonah H. Harris (Mon Jul 09 2007 - 16:46:32 EDT)
  • Jim C. Nasby (Mon Jul 09 2007 - 16:32:20 EDT)
  • Dimitri (Thu Jul 05 2007 - 08:01:14 EDT)
  • Gregory Stark (Wed Jul 04 2007 - 06:45:01 EDT)
  • Dimitri (Wed Jul 04 2007 - 06:26:10 EDT)
  • Gregory Stark (Tue Jul 03 2007 - 21:13:02 EDT)
  • Dimitri (Tue Jul 03 2007 - 11:26:55 EDT)
  • Heikki Linnakangas (Tue Jul 03 2007 - 11:06:29 EDT)
  • Dimitri (Tue Jul 03 2007 - 10:54:38 EDT)
• [PERFORM] FORGOT TO CONFIGURE RAID! DELL POWEREDGE 2950
  • Jim C. Nasby (Mon Jul 16 2007 - 17:02:11 EDT)
  • Hannes Dorbath (Sat Jul 14 2007 - 06:19:51 EDT)
  • Gregory Stark (Sat Jul 14 2007 - 05:57:55 EDT)
  • Steinar H. Gunderson (Sat Jul 14 2007 - 04:34:40 EDT)
  • Hannes Dorbath (Sat Jul 14 2007 - 04:29:05 EDT)
• [PERFORM] How to use a trigger to write rows to a remote server
  • Merlin Moncure (Fri Jul 27 2007 - 14:27:00 EDT)
  • Erik Jones (Wed Jul 18 2007 - 13:06:34 EDT)
  • Michael Dengler (Wed Jul 18 2007 - 12:30:56 EDT)
  • Adam Tauno Williams (Wed Jul 18 2007 - 11:43:42 EDT)
  • Tom Lane (Wed Jul 18 2007 - 10:51:56 EDT)
  • Csaba Nagy (Wed Jul 18 2007 - 10:02:12 EDT)
  • Heikki Linnakangas (Wed Jul 18 2007 - 09:46:05 EDT)
  • Michael Dengler (Wed Jul 18 2007 - 09:36:33 EDT)
• [PERFORM] importance of fast disks with pg
  • Heikki Linnakangas (Wed Jul 18 2007 - 04:57:15 EDT)
  • Dan Harris (Tue Jul 17 2007 - 17:54:27 EDT)
  • Thomas Finneid (Tue Jul 17 2007 - 17:44:14 EDT)
• [PERFORM] improvement suggestions for performance design
  • Kalle Hallivuori (Thu Jul 19 2007 - 03:23:38 EDT)
  • Thomas Finneid (Wed Jul 18 2007 - 15:24:18 EDT)
  • Kalle Hallivuori (Sun Jul 08 2007 - 12:25:26 EDT)
  • Thomas Finneid (Sun Jul 08 2007 - 06:06:29 EDT)
  • Kalle Hallivuori (Fri Jul 06 2007 - 07:30:30 EDT)
  • Thomas Finneid (Thu Jul 05 2007 - 18:23:36 EDT)
  • Heikki Linnakangas (Thu Jul 05 2007 - 14:39:51 EDT)
  • Y Sidhu (Thu Jul 05 2007 - 12:10:21 EDT)
  • tfinneid(at)ifi.uio.no (Thu Jul 05 2007 - 11:49:29 EDT)
  • Y Sidhu (Thu Jul 05 2007 - 10:57:07 EDT)
  • tfinneid(at)ifi.uio.no (Thu Jul 05 2007 - 09:35:57 EDT)
  • Heikki Linnakangas (Thu Jul 05 2007 - 08:59:30 EDT)
  • tfinneid(at)ifi.uio.no (Thu Jul 05 2007 - 08:15:48 EDT)
• [PERFORM] Improving select peformance
  • Tom Lane (Thu Jul 19 2007 - 21:31:08 EDT)
  • Carlos H. Reimer (Thu Jul 19 2007 - 20:41:27 EDT)
• [PERFORM] index over timestamp not being used
  • Ansgar -59cobalt- Wiechers (Wed Jul 25 2007 - 09:35:12 EDT)
  • Mario Weilguni (Wed Jul 25 2007 - 09:05:10 EDT)
  • Tom Lane (Tue Jul 24 2007 - 15:43:15 EDT)
  • Arnau (Tue Jul 24 2007 - 15:31:07 EDT)
  • Tom Lane (Tue Jul 24 2007 - 15:24:55 EDT)
  • Arnau (Tue Jul 24 2007 - 14:27:01 EDT)
• [PERFORM] Insert Statements Hanging
  • Alan Hodgson (Wed Jul 25 2007 - 16:55:13 EDT)
  • Pallav Kalva (Wed Jul 25 2007 - 16:27:02 EDT)
• [PERFORM] insert vs select into performance
  • Michael Stone (Mon Jul 23 2007 - 07:51:50 EDT)
  • Heikki Linnakangas (Wed Jul 18 2007 - 15:58:02 EDT)
  • Adriaan van Os (Wed Jul 18 2007 - 15:28:40 EDT)
  • Thomas Finneid (Wed Jul 18 2007 - 15:13:14 EDT)
  • Thomas Finneid (Wed Jul 18 2007 - 15:11:20 EDT)
  • Thomas Finneid (Wed Jul 18 2007 - 15:08:08 EDT)
  • Michael Stone (Wed Jul 18 2007 - 07:32:50 EDT)
  • Michael Stone (Wed Jul 18 2007 - 07:31:43 EDT)
  • PFC (Wed Jul 18 2007 - 07:07:18 EDT)
  • Thomas Finneid (Tue Jul 17 2007 - 17:27:07 EDT)
  • PFC (Tue Jul 17 2007 - 17:14:36 EDT)
  • Thomas Finneid (Tue Jul 17 2007 - 17:10:50 EDT)
  • Michael Glaesemann (Tue Jul 17 2007 - 17:07:04 EDT)
  • Thomas Finneid (Tue Jul 17 2007 - 17:01:15 EDT)
  • Mark Lewis (Tue Jul 17 2007 - 16:59:28 EDT)
  • Michael Stone (Tue Jul 17 2007 - 16:58:35 EDT)
  • Thomas Finneid (Tue Jul 17 2007 - 16:58:01 EDT)
  • Thomas Finneid (Tue Jul 17 2007 - 16:50:22 EDT)
  • Tom Lane (Tue Jul 17 2007 - 16:31:20 EDT)
  • Arjen van der Meijden (Tue Jul 17 2007 - 15:53:51 EDT)
  • Michael Glaesemann (Tue Jul 17 2007 - 15:54:55 EDT)
  • Thomas Finneid (Tue Jul 17 2007 - 15:38:59 EDT)
• [PERFORM] ionice to make vacuum friendier?
  • Jim C. Nasby (Wed Jul 18 2007 - 14:48:16 EDT)
  • Heikki Linnakangas (Wed Jul 18 2007 - 05:03:00 EDT)
  • Ron Mayer (Tue Jul 17 2007 - 18:29:32 EDT)
• [PERFORM] Is it possible to know where is the "deadlock"
  • Claus Guttesen (Thu Jul 19 2007 - 13:05:24 EDT)
  • Bill Moran (Thu Jul 19 2007 - 13:03:26 EDT)
  • Arnau (Thu Jul 19 2007 - 12:44:48 EDT)
• [PERFORM] Join with lower/upper limits doesn't scale well
  • Gregory Stark (Mon Jul 02 2007 - 20:04:46 EDT)
  • Craig James (Mon Jul 02 2007 - 19:30:59 EDT)
• [PERFORM] large number of connected connections to postgres database (v8.0)
  • Josh Berkus (Fri Jul 20 2007 - 19:28:27 EDT)
  • Fei Liu (Tue Jul 17 2007 - 14:51:05 EDT)
• [PERFORM] multicolumn index column order
  • Lew (Fri Jul 27 2007 - 16:03:11 EDT)
  • valgog (Wed Jul 25 2007 - 04:34:00 EDT)
  • andrew(at)pillette.com (Tue Jul 24 2007 - 03:10:30 EDT)
  • Valentine Gogichashvili (Tue Jul 24 2007 - 03:40:43 EDT)
  • valgog (Mon Jul 23 2007 - 13:13:16 EDT)
  • Tom Lane (Mon Jul 23 2007 - 13:00:40 EDT)
  • valgog (Mon Jul 23 2007 - 12:47:03 EDT)
• [PERFORM] one column from huge view
  • Tom Lane (Thu Jul 12 2007 - 10:48:17 EDT)
  • Heikki Linnakangas (Thu Jul 12 2007 - 08:55:43 EDT)
  • Michael Fuhr (Thu Jul 12 2007 - 08:51:36 EDT)
  • Heikki Linnakangas (Thu Jul 12 2007 - 04:50:42 EDT)
  • Marcin Stêpnicki (Thu Jul 12 2007 - 04:33:45 EDT)
• [PERFORM] Optmal tags design?
  • Bryan Murphy (Wed Jul 18 2007 - 17:54:07 EDT)
  • Mark Lewis (Wed Jul 18 2007 - 17:51:52 EDT)
  • lists(at)on-track.ca (Wed Jul 18 2007 - 17:26:00 EDT)
• [PERFORM] Parrallel query execution for UNION ALL Queries
  • Jim C. Nasby (Wed Jul 18 2007 - 14:50:07 EDT)
  • Scott Marlowe (Wed Jul 18 2007 - 12:30:48 EDT)
  • Jonah H. Harris (Wed Jul 18 2007 - 12:21:49 EDT)
  • Benjamin Arai (Wed Jul 18 2007 - 12:14:35 EDT)
• [PERFORM] Performance issue with 8.2.3 - "C" application
  • Karl Denninger (Wed Jul 25 2007 - 17:01:28 EDT)
  • Gregory Stark (Wed Jul 25 2007 - 03:58:40 EDT)
  • Nis Jørgensen (Wed Jul 25 2007 - 02:17:58 EDT)
  • Karl Denninger (Tue Jul 24 2007 - 23:35:41 EDT)
  • Tom Lane (Tue Jul 24 2007 - 23:25:06 EDT)
  • Karl Denninger (Tue Jul 24 2007 - 23:16:16 EDT)
  • Merlin Moncure (Tue Jul 24 2007 - 23:15:19 EDT)
  • Karl Denninger (Tue Jul 24 2007 - 22:55:45 EDT)
  • Tom Lane (Tue Jul 24 2007 - 22:45:58 EDT)
  • Karl Denninger (Tue Jul 24 2007 - 21:20:09 EDT)
• [PERFORM] Performance of PostgreSQL and Oracle
  • Tom Lane (Thu Jul 05 2007 - 23:59:26 EDT)
  • lai yoke hman (Thu Jul 05 2007 - 22:44:09 EDT)
• [PERFORM] performance of postgresql in replication using slony
  • Chris Browne (Thu Jul 26 2007 - 14:28:12 EDT)
  • Jeff Davis (Thu Jul 26 2007 - 13:21:45 EDT)
  • angga erwina (Thu Jul 26 2007 - 04:44:19 EDT)
• [PERFORM] pg_restore causes 100
  • Tom Lane (Thu Jul 12 2007 - 10:27:03 EDT)
  • Craig James (Thu Jul 12 2007 - 03:34:45 EDT)
• [PERFORM] Postgres configuration for 64 CPUs, 128 GB RAM...
  • Dimitri (Tue Jul 31 2007 - 18:14:53 EDT)
  • Luke Lonergan (Mon Jul 30 2007 - 17:41:38 EDT)
  • Dimitri (Mon Jul 30 2007 - 17:26:03 EDT)
  • Marc Mamin (Tue Jul 24 2007 - 10:38:43 EDT)
  • Luke Lonergan (Sun Jul 22 2007 - 12:43:47 EDT)
  • Gavin M. Roy (Fri Jul 20 2007 - 20:18:53 EDT)
  • Josh Berkus (Fri Jul 20 2007 - 19:26:07 EDT)
  • PFC (Tue Jul 17 2007 - 14:04:28 EDT)
  • Strong, David (Tue Jul 17 2007 - 13:43:44 EDT)
  • Greg Smith (Tue Jul 17 2007 - 12:46:22 EDT)
  • Gregory Stark (Tue Jul 17 2007 - 12:18:28 EDT)
  • Jim C. Nasby (Tue Jul 17 2007 - 11:48:00 EDT)
  • Stefan Kaltenbrunner (Tue Jul 17 2007 - 11:06:03 EDT)
  • Marc Mamin (Tue Jul 17 2007 - 10:10:30 EDT)
• [PERFORM] PostgreSQL 8.0 occasionally slow down
  • Ho Fat Tsang (Tue Jul 03 2007 - 13:21:25 EDT)
  • Ho Fat Tsang (Tue Jul 03 2007 - 13:14:05 EDT)
  • Ho Fat Tsang (Tue Jul 03 2007 - 13:07:55 EDT)
  • Ho Fat Tsang (Tue Jul 03 2007 - 13:03:17 EDT)
  • Greg Smith (Mon Jul 02 2007 - 18:21:40 EDT)
• [PERFORM] PostgreSQL Configuration Tool for Dummies
  • Harald Armin Massa (Fri Jul 06 2007 - 00:25:53 EDT)
  • Magnus Hagander (Thu Jul 05 2007 - 01:15:04 EDT)
• [PERFORM] PostgreSQL publishes first real benchmark
  • Ray Stell (Fri Jul 13 2007 - 08:08:13 EDT)
  • Philippe Amelant (Fri Jul 13 2007 - 05:56:29 EDT)
  • Greg Smith (Thu Jul 12 2007 - 11:00:54 EDT)
  • Gregory Stark (Thu Jul 12 2007 - 06:45:16 EDT)
  • Stefan Kaltenbrunner (Thu Jul 12 2007 - 05:08:38 EDT)
  • Jignesh K. Shah (Wed Jul 11 2007 - 14:34:13 EDT)
  • Tom Lane (Wed Jul 11 2007 - 13:07:19 EDT)
  • André Gomes Lamas Otero (Wed Jul 11 2007 - 12:37:27 EDT)
  • Jignesh K. Shah (Wed Jul 11 2007 - 12:33:01 EDT)
  • Heikki Linnakangas (Wed Jul 11 2007 - 11:59:32 EDT)
  • Jignesh K. Shah (Wed Jul 11 2007 - 11:48:42 EDT)
  • Philippe Amelant (Wed Jul 11 2007 - 10:16:38 EDT)
  • Heiko W.Rupp (Tue Jul 10 2007 - 04:00:43 EDT)
  • Jim C. Nasby (Mon Jul 09 2007 - 16:53:08 EDT)
  • Jonah H. Harris (Mon Jul 09 2007 - 15:17:58 EDT)
  • Joshua D. Drake (Mon Jul 09 2007 - 15:17:35 EDT)
  • Jonah H. Harris (Mon Jul 09 2007 - 15:04:53 EDT)
  • Greg Smith (Mon Jul 09 2007 - 14:55:11 EDT)
  • Vivek Khera (Mon Jul 09 2007 - 14:38:08 EDT)
  • Magnus Hagander (Mon Jul 09 2007 - 14:23:50 EDT)
  • Jignesh K. Shah (Mon Jul 09 2007 - 13:48:44 EDT)
  • Joshua D. Drake (Mon Jul 09 2007 - 13:02:10 EDT)
  • Steinar H. Gunderson (Mon Jul 09 2007 - 12:52:19 EDT)
  • Heikki Linnakangas (Mon Jul 09 2007 - 12:27:24 EDT)
  • Joshua D. Drake (Mon Jul 09 2007 - 12:27:52 EDT)
  • Jonah H. Harris (Mon Jul 09 2007 - 12:21:46 EDT)
  • Jignesh K. Shah (Mon Jul 09 2007 - 11:57:13 EDT)
• [PERFORM] Problems with posting
  • Carlos H. Reimer (Thu Jul 19 2007 - 21:19:35 EDT)
• [PERFORM] Query Analyser
  • Michael Fuhr (Wed Jul 11 2007 - 10:05:57 EDT)
  • Gauri Kanekar (Tue Jul 10 2007 - 10:47:05 EDT)
• [PERFORM] Query is taking 5 HOURS to Complete on 8.1 version
  • Alvaro Herrera (Thu Jul 05 2007 - 14:05:47 EDT)
  • smiley2211 (Thu Jul 05 2007 - 13:49:24 EDT)
  • Richard Huxton (Tue Jul 03 2007 - 16:28:48 EDT)
  • Richard Huxton (Tue Jul 03 2007 - 16:27:01 EDT)
  • smiley2211 (Tue Jul 03 2007 - 16:18:38 EDT)
  • Chris Hoover (Tue Jul 03 2007 - 16:16:50 EDT)
  • smiley2211 (Tue Jul 03 2007 - 15:23:44 EDT)
  • Richard Huxton (Tue Jul 03 2007 - 15:18:11 EDT)
  • smiley2211 (Tue Jul 03 2007 - 14:55:27 EDT)
  • Bill Moran (Tue Jul 03 2007 - 13:32:48 EDT)
  • smiley2211 (Tue Jul 03 2007 - 13:25:31 EDT)
• [PERFORM] Query optimization....
  • Karl Denninger (Mon Jul 30 2007 - 21:08:44 EDT)
• [PERFORM] Query performance issue
  • Jonathan Gray (Tue Jul 24 2007 - 05:50:18 EDT)
  • Chris (Tue Jul 24 2007 - 05:36:25 EDT)
  • Jonathan Gray (Tue Jul 24 2007 - 05:18:53 EDT)
  • Chris (Tue Jul 24 2007 - 04:50:55 EDT)
  • Chris (Tue Jul 24 2007 - 04:44:04 EDT)
  • Jonathan Gray (Tue Jul 24 2007 - 03:48:07 EDT)
• [PERFORM] Questions on Tags table schema
  • Ron Mayer (Mon Jul 30 2007 - 16:40:31 EDT)
  • Richard Huxton (Mon Jul 30 2007 - 10:58:31 EDT)
  • Richard Huxton (Mon Jul 30 2007 - 07:57:06 EDT)
  • Jay Kang (Mon Jul 30 2007 - 07:26:10 EDT)
  • Richard Huxton (Mon Jul 30 2007 - 06:48:55 EDT)
  • Richard Huxton (Mon Jul 30 2007 - 06:28:05 EDT)
  • Jay Kang (Mon Jul 30 2007 - 06:13:19 EDT)
  • Richard Huxton (Mon Jul 30 2007 - 03:21:34 EDT)
  • Jay Kang (Sun Jul 29 2007 - 10:22:30 EDT)
• [PERFORM] rtree/gist index taking enormous amount of space in 8.2.3
  • Dolafi, Tom (Mon Jul 09 2007 - 17:48:21 EDT)
• [PERFORM] Second SpecJAppserver2004 with PostgreSQL
  • Jignesh K. Shah (Tue Jul 24 2007 - 00:09:00 EDT)
• [PERFORM] select on 1milion register = 6s
  • Alvaro Herrera (Sun Jul 29 2007 - 14:02:20 EDT)
  • Scott Marlowe (Sun Jul 29 2007 - 00:51:41 EDT)
  • Hervé Piedvache (Sat Jul 28 2007 - 15:56:58 EDT)
  • Craig James (Sat Jul 28 2007 - 15:59:26 EDT)
  • Bruno Rodrigues Siqueira (Sat Jul 28 2007 - 15:27:14 EDT)
• [PERFORM] Semantics of PostgreSQL Server Log Stats
  • Bruce Momjian (Tue Jul 31 2007 - 14:22:50 EDT)
  • Camilo Porto (Tue Jul 31 2007 - 10:35:56 EDT)
• [PERFORM] Seq scan on join table despite index and high statistics
  • Henrik Zagerholm (Tue Jul 31 2007 - 04:23:38 EDT)
• [PERFORM] Simple query showing 270 hours of CPU time
  • Tom Lane (Fri Jul 20 2007 - 14:12:26 EDT)
  • Dan Harris (Fri Jul 20 2007 - 13:18:35 EDT)
  • PFC (Fri Jul 20 2007 - 12:55:02 EDT)
  • Tom Lane (Fri Jul 20 2007 - 12:42:05 EDT)
  • Dan Harris (Fri Jul 20 2007 - 11:43:50 EDT)
• [PERFORM] Simple select hangs while CPU close to 100%
  • Bill Moran (Wed Jul 25 2007 - 16:28:34 EDT)
  • Pavel Stehule (Wed Jul 25 2007 - 15:06:02 EDT)
  • Jozsef Szalay (Wed Jul 25 2007 - 14:47:58 EDT)
  • Bill Moran (Wed Jul 25 2007 - 14:12:20 EDT)
  • Bill Moran (Wed Jul 25 2007 - 13:59:20 EDT)
  • Jozsef Szalay (Wed Jul 25 2007 - 13:51:39 EDT)
  • Pavel Stehule (Wed Jul 25 2007 - 13:42:11 EDT)
  • Jozsef Szalay (Wed Jul 25 2007 - 13:37:23 EDT)
  • Adam Tauno Williams (Sun Jul 22 2007 - 14:32:45 EDT)
  • Pavel Stehule (Sun Jul 22 2007 - 11:52:34 EDT)
  • Jozsef Szalay (Sun Jul 22 2007 - 11:29:04 EDT)
• [PERFORM] slony over LAN and VPN
  • angga erwina (Sun Jul 15 2007 - 12:37:58 EDT)
• [PERFORM] slony over VPN and LAN
  • angga erwina (Sun Jul 15 2007 - 12:41:53 EDT)
• [PERFORM] slow query
  • Nis Jørgensen (Mon Jul 02 2007 - 09:20:37 EDT)
  • Vidhya Bondre (Mon Jul 02 2007 - 06:07:04 EDT)
• [PERFORM] Slow query with backwards index scan
  • Nis Jørgensen (Mon Jul 30 2007 - 16:05:14 EDT)
  • Tilmann Singer (Mon Jul 30 2007 - 15:10:25 EDT)
  • Nis Jørgensen (Mon Jul 30 2007 - 12:30:50 EDT)
  • Tilmann Singer (Sat Jul 28 2007 - 16:54:50 EDT)
  • andrew(at)pillette.com (Sat Jul 28 2007 - 16:43:58 EDT)
  • Jeremy Harris (Sat Jul 28 2007 - 15:40:12 EDT)
  • Craig James (Sat Jul 28 2007 - 16:06:02 EDT)
  • Tilmann Singer (Sat Jul 28 2007 - 15:27:13 EDT)
  • andrew(at)pillette.com (Sat Jul 28 2007 - 15:03:52 EDT)
  • Tilmann Singer (Sat Jul 28 2007 - 08:52:36 EDT)
  • Nis Jørgensen (Fri Jul 27 2007 - 14:28:52 EDT)
  • Tilmann Singer (Fri Jul 27 2007 - 13:27:03 EDT)
• [PERFORM] Table Statistics with pgAdmin III
  • Dave Page (Wed Jul 25 2007 - 04:59:54 EDT)
  • Campbell, Lance (Tue Jul 24 2007 - 14:41:22 EDT)
  • Dave Page (Tue Jul 24 2007 - 13:49:47 EDT)
  • Jean-Max Reymond (Tue Jul 24 2007 - 13:23:53 EDT)
  • Campbell, Lance (Tue Jul 24 2007 - 13:06:13 EDT)
• [PERFORM] TIMING A QUERY ???
  • smiley2211 (Thu Jul 12 2007 - 08:39:40 EDT)
  • Andrew Sullivan (Wed Jul 11 2007 - 13:01:57 EDT)
  • Gregory Stark (Wed Jul 11 2007 - 12:11:09 EDT)
  • Tom Lane (Wed Jul 11 2007 - 12:10:55 EDT)
  • Andrew Sullivan (Wed Jul 11 2007 - 11:39:11 EDT)
  • smiley2211 (Wed Jul 11 2007 - 11:21:40 EDT)
• [PERFORM] TRUNCATE TABLE
  • Adriaan van Os (Wed Jul 18 2007 - 03:36:45 EDT)
  • Tom Lane (Mon Jul 16 2007 - 20:18:18 EDT)
  • Jim C. Nasby (Mon Jul 16 2007 - 17:39:45 EDT)
  • Adriaan van Os (Fri Jul 13 2007 - 15:32:09 EDT)
  • Pavel Stehule (Fri Jul 13 2007 - 15:12:34 EDT)
  • Alvaro Herrera (Fri Jul 13 2007 - 13:35:01 EDT)
  • Jim C. Nasby (Fri Jul 13 2007 - 13:12:47 EDT)
  • Tom Lane (Fri Jul 13 2007 - 12:30:46 EDT)
  • Steinar H. Gunderson (Fri Jul 13 2007 - 12:29:47 EDT)
  • Adriaan van Os (Fri Jul 13 2007 - 12:17:18 EDT)
  • Tom Lane (Fri Jul 13 2007 - 10:40:30 EDT)
  • Michael Stone (Fri Jul 13 2007 - 08:44:38 EDT)
  • Thomas Samson (Fri Jul 13 2007 - 05:21:02 EDT)
  • Jean-Max Reymond (Fri Jul 13 2007 - 05:05:53 EDT)
  • Gregory Stark (Fri Jul 13 2007 - 05:02:33 EDT)
  • Adriaan van Os (Fri Jul 13 2007 - 03:47:06 EDT)
  • Tom Lane (Thu Jul 12 2007 - 15:20:02 EDT)
  • Adriaan van Os (Thu Jul 12 2007 - 03:37:40 EDT)
  • Gregory Stark (Wed Jul 11 2007 - 18:15:52 EDT)
  • Tom Lane (Wed Jul 11 2007 - 17:54:45 EDT)
  • Adriaan van Os (Wed Jul 11 2007 - 16:10:49 EDT)
• [PERFORM] Trying to tune postgres, how is this config?
  • Pat Maddox (Thu Jul 19 2007 - 13:33:30 EDT)
• [PERFORM] tuning a function to insert/retrieve values from a reference table
  • Tom Lane (Tue Jul 10 2007 - 11:41:20 EDT)
  • Marc Mamin (Tue Jul 10 2007 - 11:03:40 EDT)
• [PERFORM] Two questions.. shared_buffers and long reader issue
  • Patric de Waha (Wed Jul 11 2007 - 16:48:51 EDT)
  • Andrew Sullivan (Wed Jul 11 2007 - 12:58:26 EDT)
  • Tom Lane (Wed Jul 11 2007 - 12:57:42 EDT)
  • Bryan Murphy (Wed Jul 11 2007 - 11:51:51 EDT)
  • Patric de Waha (Wed Jul 11 2007 - 11:35:33 EDT)
• [PERFORM] update, truncate and vacuum
  • Dave Dutcher (Thu Jul 26 2007 - 18:59:58 EDT)
  • Luke Lonergan (Thu Jul 26 2007 - 19:17:32 EDT)
  • Scott Feldstein (Thu Jul 26 2007 - 18:36:50 EDT)
• [PERFORM] User concurrency thresholding: where do I look?
  • Jignesh K. Shah (Tue Jul 31 2007 - 17:46:26 EDT)
  • Josh Berkus (Tue Jul 31 2007 - 17:33:20 EDT)
  • Jignesh K. Shah (Mon Jul 30 2007 - 15:23:42 EDT)
  • Jignesh K. Shah (Fri Jul 27 2007 - 16:04:57 EDT)
  • Jignesh K. Shah (Fri Jul 27 2007 - 15:11:35 EDT)
  • Jignesh K. Shah (Fri Jul 27 2007 - 08:49:57 EDT)
  • Simon Riggs (Fri Jul 27 2007 - 05:15:13 EDT)
  • Simon Riggs (Fri Jul 27 2007 - 05:15:27 EDT)
  • Alvaro Herrera (Fri Jul 27 2007 - 04:58:05 EDT)
  • Jignesh K. Shah (Thu Jul 26 2007 - 17:17:55 EDT)
  • Simon Riggs (Thu Jul 26 2007 - 16:04:50 EDT)
  • Robert Lor (Thu Jul 26 2007 - 15:56:08 EDT)
  • Jignesh K. Shah (Thu Jul 26 2007 - 15:44:42 EDT)
  • Simon Riggs (Thu Jul 26 2007 - 11:51:16 EDT)
  • Tom Lane (Thu Jul 26 2007 - 11:42:48 EDT)
  • Jignesh K. Shah (Thu Jul 26 2007 - 11:27:30 EDT)
  • Simon Riggs (Thu Jul 26 2007 - 11:25:31 EDT)
  • Tom Lane (Thu Jul 26 2007 - 10:40:16 EDT)
  • Jignesh K. Shah (Thu Jul 26 2007 - 10:29:51 EDT)
  • Tom Lane (Wed Jul 25 2007 - 19:24:25 EDT)
  • Jignesh K. Shah (Wed Jul 25 2007 - 18:58:53 EDT)
  • Simon Riggs (Mon Jul 23 2007 - 14:30:48 EDT)
  • Tom Lane (Mon Jul 23 2007 - 14:19:20 EDT)
  • Simon Riggs (Mon Jul 23 2007 - 13:50:53 EDT)
  • Simon Riggs (Mon Jul 23 2007 - 13:37:41 EDT)
  • Tom Lane (Mon Jul 23 2007 - 12:35:28 EDT)
  • Simon Riggs (Mon Jul 23 2007 - 11:47:43 EDT)
  • Tom Lane (Mon Jul 23 2007 - 10:54:58 EDT)
  • Simon Riggs (Mon Jul 23 2007 - 10:39:16 EDT)
  • Tom Lane (Mon Jul 23 2007 - 10:11:41 EDT)
  • Simon Riggs (Mon Jul 23 2007 - 04:51:08 EDT)
  • Tom Lane (Sat Jul 21 2007 - 00:26:10 EDT)
  • David Boreham (Fri Jul 20 2007 - 23:31:14 EDT)
  • Jignesh K. Shah (Fri Jul 20 2007 - 17:24:33 EDT)
  • Tom Lane (Fri Jul 20 2007 - 16:57:34 EDT)
  • Jignesh K. Shah (Fri Jul 20 2007 - 16:51:39 EDT)
  • Tom Lane (Fri Jul 20 2007 - 16:16:01 EDT)
  • Jignesh K. Shah (Fri Jul 20 2007 - 15:46:30 EDT)
  • Tom Lane (Fri Jul 20 2007 - 15:13:13 EDT)
  • Jignesh K. Shah (Fri Jul 20 2007 - 14:56:31 EDT)
  • Tom Lane (Fri Jul 20 2007 - 14:23:51 EDT)
  • Jignesh K. Shah (Fri Jul 20 2007 - 14:18:05 EDT)
  • Jignesh K. Shah (Fri Jul 20 2007 - 14:08:49 EDT)
  • Josh Berkus (Fri Jul 20 2007 - 13:17:35 EDT)
  • Greg Smith (Fri Jul 20 2007 - 13:05:54 EDT)
  • Gregory Stark (Fri Jul 20 2007 - 07:46:07 EDT)
  • Josh Berkus (Fri Jul 20 2007 - 00:38:39 EDT)
  • Tom Lane (Thu Jul 19 2007 - 21:45:26 EDT)
  • Josh Berkus (Thu Jul 19 2007 - 21:19:13 EDT)
  • Greg Smith (Thu Jul 19 2007 - 15:04:44 EDT)
  • Joshua D. Drake (Thu Jul 19 2007 - 14:27:45 EDT)
  • Tom Lane (Thu Jul 19 2007 - 13:45:15 EDT)
  • Alvaro Herrera (Thu Jul 19 2007 - 13:37:04 EDT)
  • Tom Lane (Thu Jul 19 2007 - 13:25:38 EDT)
  • Josh Berkus (Thu Jul 19 2007 - 12:22:24 EDT)
  • Alvaro Herrera (Thu Jul 19 2007 - 11:49:12 EDT)
  • Joshua D. Drake (Thu Jul 19 2007 - 11:44:18 EDT)
  • Josh Berkus (Thu Jul 19 2007 - 11:28:59 EDT)
• [PERFORM] Using EXECUTE in a function
  • Merlin Moncure (Tue Jul 31 2007 - 23:28:50 EDT)
  • Andreas Tille (Tue Jul 31 2007 - 10:10:03 EDT)
• [PERFORM] Vacuum full considered useful ;)
  • Vivek Khera (Sat Jul 14 2007 - 22:26:22 EDT)
  • Guillaume Lelarge (Sat Jul 14 2007 - 12:34:18 EDT)
  • Tom Lane (Sat Jul 14 2007 - 12:32:48 EDT)
  • Joshua D. Drake (Sat Jul 14 2007 - 12:25:18 EDT)
  • Patric de Waha (Sat Jul 14 2007 - 11:50:39 EDT)
• [PERFORM] Vacuum looping?
  • Decibel! (Mon Jul 30 2007 - 21:46:37 EDT)
  • Steven Flatt (Mon Jul 30 2007 - 12:04:08 EDT)
  • Jim C. Nasby (Sat Jul 28 2007 - 12:36:24 EDT)
  • Tom Lane (Sat Jul 28 2007 - 10:37:07 EDT)
  • Steven Flatt (Fri Jul 27 2007 - 17:32:11 EDT)
• [PERFORM] WALL on controller without battery?
  • Francisco Reyes (Wed Jul 11 2007 - 20:26:56 EDT)
  • Greg Smith (Wed Jul 11 2007 - 19:01:10 EDT)
  • Francisco Reyes (Wed Jul 11 2007 - 16:34:46 EDT)
  • Joshua D. Drake (Wed Jul 11 2007 - 15:45:29 EDT)
  • Francisco Reyes (Wed Jul 11 2007 - 15:39:32 EDT)
  • Greg Smith (Wed Jul 11 2007 - 14:53:56 EDT)
  • Alan Hodgson (Wed Jul 11 2007 - 11:47:44 EDT)
  • Andrew Sullivan (Wed Jul 11 2007 - 11:36:20 EDT)
  • Francisco Reyes (Wed Jul 11 2007 - 10:48:04 EDT)
• [PERFORM] Weird row estimate
  • Marc Cousin (Thu Jul 12 2007 - 04:55:07 EDT)
  • Tom Lane (Wed Jul 11 2007 - 16:35:31 EDT)
  • Marc Cousin (Wed Jul 11 2007 - 11:28:43 EDT)
• [PERFORM] When/if to Reindex
  • Jim C. Nasby (Wed Jul 18 2007 - 14:52:51 EDT)
  • Steven Flatt (Wed Jul 18 2007 - 13:08:30 EDT)
• [pgsql-advocacy] [PERFORM] 8.2 -> 8.3 performance numbers
  • Gregory Stark (Wed Jul 25 2007 - 10:43:29 EDT)
  • Simon Riggs (Wed Jul 25 2007 - 10:22:25 EDT)
  • Merlin Moncure (Wed Jul 25 2007 - 10:09:50 EDT)
  • Simon Riggs (Wed Jul 25 2007 - 10:09:09 EDT)
  • Mario Weilguni (Wed Jul 25 2007 - 09:07:23 EDT)
  • Simon Riggs (Wed Jul 25 2007 - 08:52:13 EDT)
• RES: [PERFORM] select on 1milion register = 6s
  • Decibel! (Sun Jul 29 2007 - 12:35:37 EDT)
  • Bruno Rodrigues Siqueira (Sat Jul 28 2007 - 19:07:18 EDT)
  • Bruno Rodrigues Siqueira (Sat Jul 28 2007 - 18:40:48 EDT)
  • Ragnar (Sat Jul 28 2007 - 18:36:16 EDT)
  • Bruno Rodrigues Siqueira (Sat Jul 28 2007 - 16:12:10 EDT)
• RES: RES: [PERFORM] select on 1milion register = 6s
  • Decibel! (Mon Jul 30 2007 - 02:52:41 EDT)
  • Decibel! (Sun Jul 29 2007 - 21:29:26 EDT)
  • Bruno Rodrigues Siqueira (Sun Jul 29 2007 - 12:44:23 EDT)
  • Bruno Rodrigues Siqueira (Sat Jul 28 2007 - 18:38:54 EDT)

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