Mailing List Archive For pgsql-performance@postgresql.org Jan 2008 By Thread

• [PERFORM] analyze Adrian Moisey (Tue Jan 29 2008 - 09:28:45 EST)
  • Re: [PERFORM] analyze Andrew Sullivan (Tue Jan 29 2008 - 13:09:26 EST)
  • Re: [PERFORM] analyze Scott Marlowe (Tue Jan 29 2008 - 13:36:46 EST)
• [PERFORM] 8x2.5" or 6x3.5" disks Christian Nicolaisen (Mon Jan 28 2008 - 14:25:59 EST)
  • Re: [PERFORM] 8x2.5" or 6x3.5" disks Arjen van der Meijden (Mon Jan 28 2008 - 15:28:21 EST)
    • Re: [PERFORM] 8x2.5" or 6x3.5" disks david(at)lang.hm (Tue Jan 29 2008 - 03:32:25 EST)
      • Re: [PERFORM] 8x2.5" or 6x3.5" disks Claus Guttesen (Tue Jan 29 2008 - 03:06:49 EST)
      • Re: [PERFORM] 8x2.5" or 6x3.5" disks Arjen van der Meijden (Tue Jan 29 2008 - 05:29:23 EST)
  • Re: [PERFORM] 8x2.5" or 6x3.5" disks Mike Smith (Tue Jan 29 2008 - 06:43:15 EST)
    • Re: [PERFORM] 8x2.5" or 6x3.5" disks Scott Marlowe (Tue Jan 29 2008 - 10:00:22 EST)
    • Re: [PERFORM] 8x2.5" or 6x3.5" disks Craig James (Tue Jan 29 2008 - 10:06:23 EST)
      • Re: [PERFORM] 8x2.5" or 6x3.5" disks Mike Smith (Tue Jan 29 2008 - 13:40:25 EST)
• [PERFORM] JDBC/Stored procedure performance issue Claire McLister (Mon Jan 28 2008 - 12:59:07 EST)
  • Re: [PERFORM] JDBC/Stored procedure performance issue Tom Lane (Mon Jan 28 2008 - 15:51:53 EST)
    • Re: [PERFORM] JDBC/Stored procedure performance issue Matthew Lunnon (Tue Jan 29 2008 - 05:12:49 EST)
      • Re: [PERFORM] JDBC/Stored procedure performance issue Tom Lane (Tue Jan 29 2008 - 13:08:50 EST)
    • Re: [PERFORM] JDBC/Stored procedure performance issue Claire McLister (Thu Jan 31 2008 - 14:29:52 EST)
• [PERFORM] Hard Drive Usage for Speeding up Big Queries Alex Hochberger (Mon Jan 28 2008 - 08:54:30 EST)
  • Re: [PERFORM] Hard Drive Usage for Speeding up Big Queries Scott Marlowe (Mon Jan 28 2008 - 10:19:48 EST)
  • Re: [PERFORM] Hard Drive Usage for Speeding up Big Queries Merlin Moncure (Mon Jan 28 2008 - 21:56:40 EST)
• [PERFORM] Performance problems inside a stored procedure. Matthew Lunnon (Mon Jan 28 2008 - 07:02:26 EST)
  • Re: [PERFORM] Performance problems inside a stored procedure. Heikki Linnakangas (Mon Jan 28 2008 - 07:06:48 EST)
    • Re: [PERFORM] Performance problems inside a stored procedure. Matthew Lunnon (Mon Jan 28 2008 - 07:10:24 EST)
      • Re: [PERFORM] Performance problems inside a stored procedure. Euler Taveira de Oliveira (Tue Jan 29 2008 - 08:59:19 EST)
      • Re: [PERFORM] Performance problems inside a stored procedure. Matthew Lunnon (Tue Jan 29 2008 - 12:38:13 EST)
• [PERFORM] Performance issues migrating from 743 to 826 Matthew Lunnon (Mon Jan 28 2008 - 06:41:41 EST)
  • Re: [PERFORM] Performance issues migrating from 743 to 826 Gregory Stark (Mon Jan 28 2008 - 07:41:03 EST)
    • Re: [PERFORM] Performance issues migrating from 743 to 826 Matthew Lunnon (Mon Jan 28 2008 - 10:49:25 EST)
  • Re: [PERFORM] Performance issues migrating from 743 to 826 Scott Marlowe (Mon Jan 28 2008 - 10:14:00 EST)
    • Re: [PERFORM] Performance issues migrating from 743 to 826 Matthew Lunnon (Mon Jan 28 2008 - 10:27:50 EST)
      • Re: [PERFORM] Performance issues migrating from 743 to 826 Scott Marlowe (Mon Jan 28 2008 - 10:39:54 EST)
      • Re: [PERFORM] Performance issues migrating from 743 to 826 Matthew Lunnon (Mon Jan 28 2008 - 10:54:07 EST)
• [PERFORM] How do I bulk insert to a table without affecting read performance on that table? growse (Fri Jan 25 2008 - 18:27:05 EST)
  • Re: [PERFORM] How do I bulk insert to a table without affecting read performance on that table? Scott Marlowe (Fri Jan 25 2008 - 21:06:58 EST)
    • Re: [PERFORM] How do I bulk insert to a table without affecting read performance on that table? growse (Sat Jan 26 2008 - 06:42:45 EST)
      • Re: [PERFORM] How do I bulk insert to a table without affecting read performance on that table? Scott Marlowe (Sat Jan 26 2008 - 08:39:22 EST)
      • Re: [PERFORM] How do I bulk insert to a table without affecting read performance on that table? Kevin Grittner (Thu Jan 31 2008 - 18:06:20 EST)
• [PERFORM] 1 or 2 servers for large DB scenario. David Brain (Fri Jan 25 2008 - 11:36:52 EST)
  • Re: [PERFORM] 1 or 2 servers for large DB scenario. Greg Smith (Fri Jan 25 2008 - 11:55:43 EST)
    • Re: [PERFORM] 1 or 2 servers for large DB scenario. Matthew (Fri Jan 25 2008 - 12:00:01 EST)
      • Re: [PERFORM] 1 or 2 servers for large DB scenario. Heikki Linnakangas (Sun Jan 27 2008 - 05:47:30 EST)
  • Re: [PERFORM] 1 or 2 servers for large DB scenario. Matthew (Fri Jan 25 2008 - 11:56:24 EST)
  • Re: [PERFORM] 1 or 2 servers for large DB scenario. Jignesh K. Shah (Sun Jan 27 2008 - 19:53:04 EST)
  • Re: [PERFORM] 1 or 2 servers for large DB scenario. Merlin Moncure (Sun Jan 27 2008 - 23:25:26 EST)
• [PERFORM] 8.3rc1 Out of memory when performing update Stephen Denne (Thu Jan 24 2008 - 18:46:20 EST)
  • Re: [PERFORM] 8.3rc1 Out of memory when performing update Fernando Ike (Thu Jan 24 2008 - 20:14:33 EST)
    • Re: [PERFORM] 8.3rc1 Out of memory when performing update cgallant(at)gmail.com (Fri Jan 25 2008 - 13:32:46 EST)
      • Re: [PERFORM] 8.3rc1 Out of memory when performing update Roberts, Jon (Fri Jan 25 2008 - 13:36:28 EST)
      • Re: [PERFORM] 8.3rc1 Out of memory when performing update Magnus Hagander (Fri Jan 25 2008 - 13:45:43 EST)
  • Re: [PERFORM] 8.3rc1 Out of memory when performing update Tom Lane (Thu Jan 24 2008 - 21:31:14 EST)
    • Re: [PERFORM] 8.3rc1 Out of memory when performing update Stephen Denne (Thu Jan 24 2008 - 22:20:49 EST)
      • Re: [PERFORM] 8.3rc1 Out of memory when performing update Tom Lane (Thu Jan 24 2008 - 23:50:25 EST)
      • Re: [PERFORM] 8.3rc1 Out of memory when performing update Stephen Denne (Fri Jan 25 2008 - 05:14:40 EST)
      • Re: [PERFORM] 8.3rc1 Out of memory when performing update Stephen Denne (Sun Jan 27 2008 - 16:55:10 EST)
      • Re: [PERFORM] 8.3rc1 Out of memory when performing update Tom Lane (Sun Jan 27 2008 - 23:16:20 EST)
      • Re: [PERFORM] 8.3rc1 Out of memory when performing update Stephen Denne (Mon Jan 28 2008 - 00:04:00 EST)
      • Re: [PERFORM] 8.3rc1 Out of memory when performing update Guillaume Smet (Mon Jan 28 2008 - 03:18:08 EST)
• [PERFORM] Configuration settings (shared_buffers, etc) in Linux: puzzled Rick Schumeyer (Thu Jan 24 2008 - 13:00:24 EST)
  • Re: [PERFORM] Configuration settings (shared_buffers, etc) in Linux: puzzled Greg Smith (Thu Jan 24 2008 - 13:52:49 EST)
  • Re: [PERFORM] Configuration settings (shared_buffers, etc) in Linux: puzzled Fernando Ike (Thu Jan 24 2008 - 20:53:52 EST)
• [PERFORM] Vacuum and FSM page size Thomas Lozza (Wed Jan 23 2008 - 13:29:16 EST)
  • Re: [PERFORM] Vacuum and FSM page size Vivek Khera (Wed Jan 23 2008 - 14:22:20 EST)
    • Re: [PERFORM] Vacuum and FSM page size Tom Lane (Wed Jan 23 2008 - 15:25:50 EST)
  • Re: [PERFORM] Vacuum and FSM page size Scott Marlowe (Thu Jan 24 2008 - 10:48:04 EST)
    • Re: [PERFORM] Vacuum and FSM page size Thomas Lozza (Sun Jan 27 2008 - 18:01:30 EST)
      • Re: [PERFORM] Vacuum and FSM page size Scott Marlowe (Sun Jan 27 2008 - 18:54:12 EST)
  • Re: [PERFORM] Vacuum and FSM page size Decibel! (Wed Jan 23 2008 - 14:02:21 EST)
• [PERFORM] Postgres 8.2 memory weirdness Tory M Blue (Wed Jan 23 2008 - 13:23:51 EST)
  • Re: [PERFORM] Postgres 8.2 memory weirdness Greg Smith (Wed Jan 23 2008 - 19:31:51 EST)
    • Re: [PERFORM] Postgres 8.2 memory weirdness Tory M Blue (Thu Jan 24 2008 - 12:46:19 EST)
      • Re: [PERFORM] Postgres 8.2 memory weirdness Greg Smith (Thu Jan 24 2008 - 13:49:34 EST)
      • Re: [PERFORM] Postgres 8.2 memory weirdness Tory M Blue (Fri Jan 25 2008 - 12:36:18 EST)
      • Re: [PERFORM] Postgres 8.2 memory weirdness Greg Smith (Sun Jan 27 2008 - 19:08:51 EST)
      • Re: [PERFORM] Postgres 8.2 memory weirdness Tory M Blue (Mon Jan 28 2008 - 01:09:12 EST)
• [PERFORM] planner chooses unoptimal plan on joins with complex key Dmitry Potapov (Wed Jan 23 2008 - 08:48:16 EST)
  • Re: [PERFORM] planner chooses unoptimal plan on joins with complex key Guillaume Smet (Wed Jan 23 2008 - 08:58:52 EST)
    • Re: [PERFORM] planner chooses unoptimal plan on joins with complex key Tom Lane (Wed Jan 23 2008 - 12:17:56 EST)
  • Re: [PERFORM] planner chooses unoptimal plan on joins with complex key Tom Lane (Thu Jan 24 2008 - 21:27:01 EST)
    • Re: [PERFORM] planner chooses unoptimal plan on joins with complex key Dmitry Potapov (Tue Jan 29 2008 - 10:25:55 EST)
      • Re: [PERFORM] planner chooses unoptimal plan on joins with complex key Tom Lane (Tue Jan 29 2008 - 16:59:44 EST)
      • Re: [PERFORM] planner chooses unoptimal plan on joins with complex key Dmitry Potapov (Thu Jan 31 2008 - 06:40:11 EST)
• [PERFORM] *_cost recommendation with 8.3 and a fully cached db Guillaume Smet (Wed Jan 23 2008 - 07:36:44 EST)
• [PERFORM] Making the most of memory? Joshua Fielek (Tue Jan 22 2008 - 23:11:48 EST)
  • Re: [PERFORM] Making the most of memory? Scott Marlowe (Wed Jan 23 2008 - 00:20:43 EST)
  • Re: [PERFORM] Making the most of memory? Bill Moran (Wed Jan 23 2008 - 09:59:08 EST)
  • Re: [PERFORM] Making the most of memory? Scott Marlowe (Wed Jan 23 2008 - 13:44:38 EST)
    • Re: [PERFORM] Making the most of memory? Guy Rouillier (Wed Jan 23 2008 - 14:57:09 EST)
      • Re: [PERFORM] Making the most of memory? Brian Hurt (Wed Jan 23 2008 - 15:50:59 EST)
      • Re: [PERFORM] Making the most of memory? Matthew (Thu Jan 24 2008 - 09:15:19 EST)
      • Re: [PERFORM] Making the most of memory? Florian Weimer (Thu Jan 24 2008 - 09:26:46 EST)
      • Re: [PERFORM] Making the most of memory? Chris Browne (Thu Jan 24 2008 - 11:23:02 EST)
      • Re: [PERFORM] Making the most of memory? Florian Weimer (Fri Jan 25 2008 - 03:18:41 EST)
      • Re: [PERFORM] Making the most of memory? A.M. (Wed Jan 23 2008 - 15:40:28 EST)
      • Re: [PERFORM] Making the most of memory? Craig James (Wed Jan 23 2008 - 16:06:22 EST)
      • Re: [PERFORM] Making the most of memory? Greg Smith (Wed Jan 23 2008 - 19:54:24 EST)
      • Re: [PERFORM] Making the most of memory? Steinar H. Gunderson (Thu Jan 24 2008 - 03:05:23 EST)
      • Re: [PERFORM] Making the most of memory? Scott Marlowe (Wed Jan 23 2008 - 20:45:07 EST)
      • Re: [PERFORM] Making the most of memory? Chris Browne (Thu Jan 24 2008 - 11:09:08 EST)
      • Re: [PERFORM] Making the most of memory? Merlin Moncure (Thu Jan 24 2008 - 09:01:17 EST)
  • Re: [PERFORM] Making the most of memory? Rich (Wed Jan 23 2008 - 14:06:02 EST)
  • Re: [PERFORM] Making the most of memory? Heikki Linnakangas (Thu Jan 24 2008 - 04:19:58 EST)
  • Re: [PERFORM] Making the most of memory? Merlin Moncure (Thu Jan 24 2008 - 13:01:33 EST)
    • Re: [PERFORM] Making the most of memory? Merlin Moncure (Thu Jan 24 2008 - 13:21:21 EST)
• [PERFORM] Workaround for cross column stats dependency Guillaume Smet (Tue Jan 22 2008 - 19:57:07 EST)
  • Re: [PERFORM] Workaround for cross column stats dependency Tom Lane (Tue Jan 22 2008 - 20:43:13 EST)
    • Re: [PERFORM] Workaround for cross column stats dependency Guillaume Smet (Tue Jan 22 2008 - 21:02:50 EST)
      • Re: [PERFORM] Workaround for cross column stats dependency Guillaume Smet (Wed Jan 23 2008 - 04:05:53 EST)
• [PERFORM] Optimizing queries that use temporary tables Luiz K. Matsumura (Tue Jan 22 2008 - 14:32:17 EST)
  • Re: [PERFORM] Optimizing queries that use temporary tables Scott Marlowe (Tue Jan 22 2008 - 15:34:15 EST)
• [PERFORM] scheduler Adrian Moisey (Tue Jan 22 2008 - 02:00:53 EST)
  • Re: [PERFORM] scheduler Claus Guttesen (Tue Jan 22 2008 - 03:10:07 EST)
    • Re: [PERFORM] scheduler Adrian Moisey (Tue Jan 22 2008 - 03:27:21 EST)
      • Re: [PERFORM] scheduler david(at)lang.hm (Tue Jan 22 2008 - 03:37:21 EST)
  • Re: [PERFORM] scheduler Luke Lonergan (Tue Jan 22 2008 - 03:45:45 EST)
• [PERFORM] 8.3 synchronous_commit Hannes Dorbath (Mon Jan 21 2008 - 16:55:16 EST)
  • Re: [PERFORM] 8.3 synchronous_commit Pavel Stehule (Mon Jan 21 2008 - 17:11:07 EST)
  • Re: [PERFORM] 8.3 synchronous_commit Jeff Davis (Mon Jan 21 2008 - 17:25:30 EST)
  • Re: [PERFORM] 8.3 synchronous_commit Greg Smith (Mon Jan 21 2008 - 18:31:16 EST)
    • Re: [PERFORM] 8.3 synchronous_commit Jeff Davis (Mon Jan 21 2008 - 18:45:54 EST)
      • Re: [PERFORM] 8.3 synchronous_commit Greg Smith (Mon Jan 21 2008 - 19:26:14 EST)
      • Re: [PERFORM] 8.3 synchronous_commit Fernando Ike (Mon Jan 21 2008 - 19:48:21 EST)
    • Re: [PERFORM] 8.3 synchronous_commit Hannes Dorbath (Tue Jan 22 2008 - 07:13:57 EST)
  • Re: [PERFORM] 8.3 synchronous_commit Florian Weimer (Tue Jan 22 2008 - 03:32:25 EST)
    • Re: [PERFORM] 8.3 synchronous_commit Guillaume Smet (Tue Jan 22 2008 - 03:49:02 EST)
      • Re: [PERFORM] 8.3 synchronous_commit Florian Weimer (Tue Jan 22 2008 - 03:56:51 EST)
      • Re: [PERFORM] 8.3 synchronous_commit Hannes Dorbath (Tue Jan 22 2008 - 06:56:59 EST)
• [PERFORM] Slow performance with left outer join Marten Verhoeven (Mon Jan 21 2008 - 10:00:02 EST)
  • Re: [PERFORM] Slow performance with left outer join Pavel Stehule (Mon Jan 21 2008 - 10:17:16 EST)
  • Re: [PERFORM] Slow performance with left outer join Tom Lane (Mon Jan 21 2008 - 11:55:55 EST)
    • Re: [PERFORM] Slow performance with left outer join Pavel Stehule (Mon Jan 21 2008 - 13:04:33 EST)
• [PERFORM] Slow set-returning functions Dean Rasheed (Sun Jan 20 2008 - 06:40:19 EST)
  • Re: [PERFORM] Slow set-returning functions Heikki Linnakangas (Sun Jan 20 2008 - 09:34:52 EST)
    • Re: [PERFORM] Slow set-returning functions Merlin Moncure (Sun Jan 20 2008 - 10:25:48 EST)
      • Re: [PERFORM] Slow set-returning functions Dean Rasheed (Sun Jan 20 2008 - 12:32:29 EST)
      • Re: [PERFORM] Slow set-returning functions Tom Lane (Sun Jan 20 2008 - 13:30:35 EST)
      • Re: [PERFORM] Slow set-returning functions Dean Rasheed (Sun Jan 27 2008 - 12:29:34 EST)
      • Re: [PERFORM] Slow set-returning functions Marcin StÄ™pnicki (Sun Jan 27 2008 - 14:16:20 EST)
      • Re: [PERFORM] Slow set-returning functions Merlin Moncure (Sun Jan 27 2008 - 18:01:08 EST)
      • Re: [PERFORM] Slow set-returning functions Dean Rasheed (Mon Jan 28 2008 - 07:38:57 EST)
• [PERFORM] [OT] RAID controllers blocking one another? Sean Davis (Thu Jan 17 2008 - 15:17:08 EST)
  • Re: [PERFORM] [OT] RAID controllers blocking one another? Scott Marlowe (Thu Jan 17 2008 - 16:07:02 EST)
    • Re: [PERFORM] [OT] RAID controllers blocking one another? Greg Smith (Thu Jan 17 2008 - 18:23:47 EST)
      • Re: [PERFORM] [OT] RAID controllers blocking one another? Sean Davis (Fri Jan 18 2008 - 08:03:42 EST)
      • Re: [PERFORM] [OT] RAID controllers blocking one another? Greg Smith (Fri Jan 18 2008 - 14:14:31 EST)
      • Re: [PERFORM] [OT] RAID controllers blocking one another? Sean Davis (Fri Jan 18 2008 - 14:35:15 EST)
    • Re: [PERFORM] [OT] RAID controllers blocking one another? Steinar H. Gunderson (Thu Jan 17 2008 - 18:30:55 EST)
  • Re: [PERFORM] [OT] RAID controllers blocking one another? david(at)lang.hm (Sat Jan 19 2008 - 12:31:39 EST)
• [PERFORM] strange pauses Adrian Moisey (Wed Jan 16 2008 - 05:42:11 EST)
  • Re: [PERFORM] strange pauses Richard Huxton (Wed Jan 16 2008 - 05:50:23 EST)
    • Re: [PERFORM] strange pauses Tom Lane (Wed Jan 16 2008 - 10:23:06 EST)
    • Re: [PERFORM] strange pauses Greg Smith (Wed Jan 16 2008 - 10:37:58 EST)
      • Re: [PERFORM] strange pauses Adrian Moisey (Thu Jan 17 2008 - 01:50:24 EST)
      • Re: [PERFORM] strange pauses Scott Marlowe (Thu Jan 17 2008 - 08:44:28 EST)
    • Re: [PERFORM] strange pauses Adrian Moisey (Fri Jan 18 2008 - 05:58:06 EST)
      • Re: [PERFORM] strange pauses Adrian Moisey (Fri Jan 18 2008 - 07:03:03 EST)
      • Re: [PERFORM] strange pauses Alvaro Herrera (Fri Jan 18 2008 - 07:41:21 EST)
      • Re: [PERFORM] strange pauses Adrian Moisey (Mon Jan 21 2008 - 02:58:30 EST)
      • Re: [PERFORM] strange pauses Decibel! (Mon Jan 21 2008 - 14:29:52 EST)
      • Re: [PERFORM] strange pauses Scott Marlowe (Fri Jan 18 2008 - 10:36:08 EST)
  • Re: [PERFORM] strange pauses Scott Marlowe (Wed Jan 16 2008 - 10:30:48 EST)
  • Re: [PERFORM] strange pauses Brian Herlihy (Thu Jan 17 2008 - 04:16:40 EST)
• [PERFORM] Tuning Postgresql on Windows XP Pro 32 bit [was on HACKERS list] Doug Knight (Tue Jan 15 2008 - 12:05:20 EST)
  • Re: [PERFORM] Tuning Postgresql on Windows XP Pro 32 bit [was on HACKERS list] Kevin Grittner (Fri Jan 18 2008 - 17:50:34 EST)
• [PERFORM] Saving result set of SELECT to table column Patric (Mon Jan 14 2008 - 13:19:36 EST)
  • Re: [PERFORM] Saving result set of SELECT to table column Ansgar -59cobalt- Wiechers (Mon Jan 14 2008 - 13:38:38 EST)
  • Re: [PERFORM] Saving result set of SELECT to table column Robins Tharakan (Mon Jan 14 2008 - 22:30:27 EST)
• [PERFORM] Seq scans on indexed columns. Yannick Le Guédart (Mon Jan 14 2008 - 09:18:51 EST)
  • Re: [PERFORM] Seq scans on indexed columns. Guillaume Cottenceau (Mon Jan 14 2008 - 09:34:36 EST)
  • Re: [PERFORM] Seq scans on indexed columns. Shane Ambler (Mon Jan 14 2008 - 14:06:42 EST)
• [PERFORM] Inheritance, unique keys and performance Julian Scarfe (Sat Jan 12 2008 - 14:34:23 EST)
  • Re: [PERFORM] Inheritance, unique keys and performance Tom Lane (Sat Jan 12 2008 - 15:35:18 EST)
    • Re: [PERFORM] Inheritance, unique keys and performance Julian Scarfe (Sun Jan 13 2008 - 04:13:21 EST)
      • Re: [PERFORM] Inheritance, unique keys and performance Tom Lane (Sun Jan 13 2008 - 13:46:43 EST)
      • Re: [PERFORM] Inheritance, unique keys and performance Julian Scarfe (Sun Jan 13 2008 - 14:28:18 EST)
      • Re: [PERFORM] Inheritance, unique keys and performance Tom Lane (Sun Jan 13 2008 - 15:47:50 EST)
• [PERFORM] Simple select, but takes long time James DeMichele (Fri Jan 11 2008 - 20:33:54 EST)
  • Re: [PERFORM] Simple select, but takes long time Tom Lane (Fri Jan 11 2008 - 21:11:18 EST)
  • Re: [PERFORM] Simple select, but takes long time andrew(at)pillette.com (Sat Jan 12 2008 - 00:37:29 EST)
    • Re: [PERFORM] Simple select, but takes long time Tom Lane (Sat Jan 12 2008 - 00:44:14 EST)
• [PERFORM] Evaluating boolean formula: slow performance Jörg Kiegeland (Fri Jan 11 2008 - 12:06:03 EST)
  • Re: [PERFORM] Evaluating boolean formula: slow performance Jörg Kiegeland (Fri Jan 11 2008 - 12:42:13 EST)
• [PERFORM] Best way to index IP data? Kevin Kempter (Thu Jan 10 2008 - 18:14:54 EST)
  • Re: [PERFORM] Best way to index IP data? Joshua D. Drake (Thu Jan 10 2008 - 18:22:45 EST)
  • Re: [PERFORM] Best way to index IP data? Steve Atkins (Thu Jan 10 2008 - 18:25:20 EST)
    • Re: [PERFORM] Best way to index IP data? Jonah H. Harris (Thu Jan 10 2008 - 18:41:56 EST)
      • Re: [PERFORM] Best way to index IP data? Pomarede Nicolas (Fri Jan 11 2008 - 04:31:26 EST)
      • Re: [PERFORM] Best way to index IP data? Tom Lane (Fri Jan 11 2008 - 10:19:51 EST)
      • Re: [PERFORM] Best way to index IP data? Andrew Sullivan (Fri Jan 11 2008 - 10:37:34 EST)
      • Re: [PERFORM] Best way to index IP data? Pomarede Nicolas (Fri Jan 11 2008 - 10:55:30 EST)
      • Re: [PERFORM] Best way to index IP data? Steve Atkins (Fri Jan 11 2008 - 11:11:15 EST)
      • Re: [PERFORM] Best way to index IP data? Joshua D. Drake (Fri Jan 11 2008 - 11:18:21 EST)
      • Re: [PERFORM] Best way to index IP data? Michael Stone (Fri Jan 11 2008 - 11:27:49 EST)
      • Re: [PERFORM] Best way to index IP data? Tom Lane (Fri Jan 11 2008 - 15:07:38 EST)
      • Re: [PERFORM] Best way to index IP data? D'Arcy J.M. Cain (Fri Jan 11 2008 - 15:19:35 EST)
      • Re: [PERFORM] Best way to index IP data? Michael Stone (Fri Jan 11 2008 - 16:32:05 EST)
      • Re: [PERFORM] Best way to index IP data? Michael Stone (Fri Jan 11 2008 - 16:40:48 EST)
      • Re: [PERFORM] Best way to index IP data? Michael Stone (Fri Jan 11 2008 - 16:27:05 EST)
      • Re: [PERFORM] Best way to index IP data? Alvaro Herrera (Fri Jan 11 2008 - 16:37:10 EST)
      • Re: [PERFORM] Best way to index IP data? Michael Stone (Fri Jan 11 2008 - 17:02:36 EST)
      • Re: [PERFORM] Best way to index IP data? Andrew Sullivan (Fri Jan 11 2008 - 17:24:03 EST)
      • Re: [PERFORM] Best way to index IP data? Steve Atkins (Fri Jan 11 2008 - 17:38:27 EST)
      • Re: [PERFORM] Best way to index IP data? Andrew Sullivan (Fri Jan 11 2008 - 18:00:55 EST)
      • Re: [PERFORM] Best way to index IP data? Steve Atkins (Fri Jan 11 2008 - 18:37:37 EST)
      • Re: [PERFORM] Best way to index IP data? Joshua D. Drake (Fri Jan 11 2008 - 18:52:11 EST)
      • Re: [PERFORM] Best way to index IP data? Steve Atkins (Fri Jan 11 2008 - 18:55:46 EST)
      • Re: [PERFORM] Best way to index IP data? Michael Stone (Fri Jan 11 2008 - 19:21:29 EST)
      • Re: [PERFORM] Best way to index IP data? Joshua D. Drake (Fri Jan 11 2008 - 19:43:18 EST)
      • Re: [PERFORM] Best way to index IP data? Michael Stone (Fri Jan 11 2008 - 20:04:25 EST)
      • Re: [PERFORM] Best way to index IP data? Greg Smith (Fri Jan 11 2008 - 21:56:38 EST)
      • Re: [PERFORM] Best way to index IP data? david(at)lang.hm (Sat Jan 12 2008 - 06:17:31 EST)
      • Re: [PERFORM] Best way to index IP data? D'Arcy J.M. Cain (Sat Jan 12 2008 - 01:00:48 EST)
      • Re: [PERFORM] Best way to index IP data? Michael Stone (Fri Jan 11 2008 - 19:11:37 EST)
      • Re: [PERFORM] Best way to index IP data? Florian Weimer (Mon Jan 14 2008 - 03:27:52 EST)
      • Re: [PERFORM] Best way to index IP data? Michael Stone (Mon Jan 14 2008 - 06:19:24 EST)
      • Re: [PERFORM] Best way to index IP data? Florian Weimer (Mon Jan 14 2008 - 09:05:27 EST)
      • Re: [PERFORM] Best way to index IP data? Michael Stone (Mon Jan 14 2008 - 09:12:01 EST)
      • Re: [PERFORM] Best way to index IP data? Pomarede Nicolas (Fri Jan 11 2008 - 17:43:58 EST)
      • Re: [PERFORM] Best way to index IP data? Tom Lane (Fri Jan 11 2008 - 19:51:19 EST)
      • Re: [PERFORM] Best way to index IP data? Tom Lane (Fri Jan 11 2008 - 19:19:10 EST)
      • Re: [PERFORM] Best way to index IP data? Michael Stone (Fri Jan 11 2008 - 19:36:02 EST)
      • Re: [PERFORM] Best way to index IP data? Joshua D. Drake (Fri Jan 11 2008 - 19:57:46 EST)
      • Re: [PERFORM] Best way to index IP data? Michael Stone (Fri Jan 11 2008 - 20:07:40 EST)
  • Re: [PERFORM] Best way to index IP data? Michael Stone (Fri Jan 11 2008 - 20:58:47 EST)
• [PERFORM] not exists clause S Golly (Thu Jan 10 2008 - 15:15:53 EST)
  • Re: [PERFORM] not exists clause Josh Berkus (Thu Jan 10 2008 - 16:50:30 EST)
  • Re: [PERFORM] not exists clause Guy Rouillier (Thu Jan 10 2008 - 23:00:23 EST)
• [PERFORM] Search for fixed set of keywords Jörg Kiegeland (Wed Jan 09 2008 - 05:43:42 EST)
  • Re: [PERFORM] Search for fixed set of keywords Oleg Bartunov (Wed Jan 09 2008 - 05:55:06 EST)
    • Re: [PERFORM] Search for fixed set of keywords Jörg Kiegeland (Thu Jan 10 2008 - 04:23:47 EST)
      • Re: [PERFORM] Search for fixed set of keywords Oleg Bartunov (Thu Jan 10 2008 - 07:05:59 EST)
• [PERFORM] big database performance Adrian Moisey (Wed Jan 09 2008 - 03:18:34 EST)
  • Re: [PERFORM] big database performance Joshua D. Drake (Wed Jan 09 2008 - 03:27:33 EST)
    • Re: [PERFORM] big database performance Adrian Moisey (Wed Jan 09 2008 - 07:53:09 EST)
      • Re: [PERFORM] big database performance Alan Hodgson (Wed Jan 09 2008 - 11:16:48 EST)
      • Re: [PERFORM] big database performance Joshua D. Drake (Wed Jan 09 2008 - 11:50:58 EST)
      • Re: [PERFORM] big database performance Adrian Moisey (Thu Jan 10 2008 - 03:45:17 EST)
    • Re: [PERFORM] big database performance Guillaume Smet (Wed Jan 09 2008 - 11:59:58 EST)
      • Re: [PERFORM] big database performance Greg Smith (Wed Jan 09 2008 - 13:44:34 EST)
    • Re: [PERFORM] big database performance Jared Mauch (Wed Jan 09 2008 - 12:42:43 EST)
      • Re: [PERFORM] big database performance Adrian Moisey (Thu Jan 10 2008 - 03:57:46 EST)
      • Re: [PERFORM] big database performance Jared Mauch (Thu Jan 10 2008 - 09:21:22 EST)
      • Re: [PERFORM] big database performance Stephane Bailliez (Thu Jan 10 2008 - 06:08:39 EST)
      • Re: [PERFORM] big database performance Jared Mauch (Thu Jan 10 2008 - 09:34:40 EST)
  • Re: [PERFORM] big database performance Frank Habermann (Wed Jan 09 2008 - 03:42:10 EST)
  • Re: [PERFORM] big database performance Simon Riggs (Wed Jan 09 2008 - 16:01:18 EST)
• [PERFORM] After Vacuum Analyse - Procedure performance not improved - Innner select is faster Anoo Sivadasan Pillai (Tue Jan 08 2008 - 23:03:57 EST)
  • Re: [PERFORM] After Vacuum Analyse - Procedure performance not improved - Innner select is faster Alvaro Herrera (Wed Jan 09 2008 - 00:06:44 EST)
    • Re: [PERFORM] After Vacuum Analyse - Procedure performance notimproved - Innner select is faster Anoo Sivadasan Pillai (Wed Jan 09 2008 - 01:00:33 EST)
      • Re: [PERFORM] After Vacuum Analyse - Procedure performance notimproved - Innner select is faster Erik Jones (Wed Jan 09 2008 - 13:06:35 EST)
• [PERFORM] Performance of aggregates over set-returning functions John Smith (Tue Jan 08 2008 - 21:21:46 EST)
  • Re: [PERFORM] Performance of aggregates over set-returning functions Tom Lane (Tue Jan 08 2008 - 22:07:23 EST)
    • Re: [PERFORM] Performance of aggregates over set-returning functions John Smith (Tue Jan 08 2008 - 22:33:33 EST)
      • Re: [PERFORM] Performance of aggregates over set-returning functions Tom Lane (Tue Jan 08 2008 - 22:51:04 EST)
• [PERFORM] Loss of cache when persistent connexion is closed Guillaume Pungeot (Tue Jan 08 2008 - 10:35:56 EST)
  • Re: [PERFORM] Loss of cache when persistent connexion is closed Tom Lane (Tue Jan 08 2008 - 19:05:55 EST)
• [PERFORM] concurrent inserts into two separate tables are very slow Sergei Shelukhin (Sat Jan 05 2008 - 22:00:00 EST)
  • Re: [PERFORM] concurrent inserts into two separate tables are very slow Scott Marlowe (Mon Jan 07 2008 - 17:17:19 EST)
    • Re: [PERFORM] concurrent inserts into two separate tables are very slow Sergei Shelukhin (Mon Jan 07 2008 - 17:49:42 EST)
      • Re: [PERFORM] concurrent inserts into two separate tables are very slow Scott Marlowe (Mon Jan 07 2008 - 18:08:46 EST)
• [PERFORM] Commit takes a long time. Peter Childs (Thu Jan 03 2008 - 09:35:37 EST)
  • Re: [PERFORM] Commit takes a long time. Pavel Stehule (Thu Jan 03 2008 - 11:20:01 EST)
  • Re: [PERFORM] Commit takes a long time. Tom Lane (Thu Jan 03 2008 - 11:35:01 EST)
    • Re: [PERFORM] Commit takes a long time. Peter Childs (Fri Jan 04 2008 - 03:46:37 EST)
    • Re: [PERFORM] Commit takes a long time. Simon Riggs (Fri Jan 04 2008 - 05:17:17 EST)
• [PERFORM] Linux/PostgreSQL scalability issue - problem with 8 cores Jakub Ouhrabka (Thu Jan 03 2008 - 06:50:01 EST)
  • Re: [PERFORM] Linux/PostgreSQL scalability issue - problem with 8 cores Sven Geisler (Thu Jan 03 2008 - 11:27:44 EST)
    • Re: [PERFORM] Linux/PostgreSQL scalability issue - problem with 8 cores Jakub Ouhrabka (Thu Jan 03 2008 - 12:51:43 EST)
      • Re: [PERFORM] Linux/PostgreSQL scalability issue - problem with 8 cores Alvaro Herrera (Thu Jan 03 2008 - 13:31:18 EST)
      • Re: [PERFORM] Linux/PostgreSQL scalability issue - problem with 8 cores Jakub Ouhrabka (Thu Jan 03 2008 - 14:26:30 EST)
  • Re: [PERFORM] Linux/PostgreSQL scalability issue - problem with 8 cores Tom Lane (Thu Jan 03 2008 - 11:59:30 EST)
    • Re: [PERFORM] Linux/PostgreSQL scalability issue - problem with 8 cores Jakub Ouhrabka (Thu Jan 03 2008 - 12:37:29 EST)
      • Re: [PERFORM] Linux/PostgreSQL scalability issue - problem with 8 cores Jakub Ouhrabka (Mon Jan 07 2008 - 06:00:12 EST)
      • Re: [PERFORM] Linux/PostgreSQL scalability issue - problem with 8 cores Alvaro Herrera (Mon Jan 07 2008 - 10:12:34 EST)
      • Re: [PERFORM] Linux/PostgreSQL scalability issue - problem with 8 cores Tom Lane (Mon Jan 07 2008 - 19:54:25 EST)
      • Re: [PERFORM] Linux/PostgreSQL scalability issue - problem with 8 cores Simon Riggs (Fri Jan 25 2008 - 18:27:09 EST)
      • Re: [PERFORM] Linux/PostgreSQL scalability issue - problem with 8 cores Matthew (Mon Jan 28 2008 - 09:27:34 EST)
      • Re: [PERFORM] Linux/PostgreSQL scalability issue - problem with 8 cores Tom Lane (Mon Jan 07 2008 - 17:31:30 EST)
  • Re: [PERFORM] Linux/PostgreSQL scalability issue - problem with 8 cores James Mansion (Fri Jan 04 2008 - 15:46:52 EST)
    • Re: [PERFORM] Linux/PostgreSQL scalability issue - problem with 8 cores David Boreham (Fri Jan 04 2008 - 15:55:08 EST)
  • Re: [PERFORM] Linux/PostgreSQL scalability issue - problem with 8 cores Tom Lane (Mon Jan 07 2008 - 19:01:32 EST)
    • Re: [PERFORM] Linux/PostgreSQL scalability issue - problem with 8 cores Jakub Ouhrabka (Tue Jan 08 2008 - 07:19:24 EST)
      • Re: [PERFORM] Linux/PostgreSQL scalability issue - problem with 8 cores Tom Lane (Tue Jan 08 2008 - 12:25:11 EST)
      • Re: [PERFORM] Linux/PostgreSQL scalability issue - problem with 8 cores Jakub Ouhrabka (Fri Jan 11 2008 - 06:11:36 EST)
      • Re: [PERFORM] Linux/PostgreSQL scalability issue - problem with 8 cores Tom Lane (Fri Jan 11 2008 - 10:05:40 EST)
      • Re: [PERFORM] Linux/PostgreSQL scalability issue - problem with 8 cores Jakub Ouhrabka (Mon Jan 14 2008 - 06:47:05 EST)
      • Re: [PERFORM] Linux/PostgreSQL scalability issue - problem with 8 cores Tom Lane (Mon Jan 14 2008 - 10:22:14 EST)
      • Re: [PERFORM] Linux/PostgreSQL scalability issue - problem with 8 cores Jakub Ouhrabka (Tue Jan 15 2008 - 07:09:18 EST)
      • Re: [PERFORM] Linux/PostgreSQL scalability issue - problem with 8 cores Adrian Moisey (Tue Jan 15 2008 - 07:26:10 EST)
      • Re: [PERFORM] Linux/PostgreSQL scalability issue - problem with 8 cores Tom Lane (Tue Jan 15 2008 - 10:51:04 EST)
      • Re: [PERFORM] Linux/PostgreSQL scalability issue - problem with 8 cores Tom Lane (Tue Jan 15 2008 - 10:20:59 EST)
      • Re: [PERFORM] Linux/PostgreSQL scalability issue - problem with 8 cores Jakub Ouhrabka (Tue Jan 15 2008 - 10:45:57 EST)
      • Re: [PERFORM] Linux/PostgreSQL scalability issue - problem with 8 cores Tom Lane (Tue Jan 15 2008 - 11:26:00 EST)
      • Re: [PERFORM] Linux/PostgreSQL scalability issue - problem with 8 cores Jakub Ouhrabka (Tue Jan 15 2008 - 12:06:33 EST)
• Re: [PERFORM] [GENERAL] Can't make backup Sebastián Baioni (Wed Jan 02 2008 - 07:24:03 EST)
  • Re: [PERFORM] SELECT * FROM table is too slow Luiz K. Matsumura (Tue Jan 22 2008 - 14:44:33 EST)
    • Re: [PERFORM] SELECT * FROM table is too slow Joshua D. Drake (Tue Jan 22 2008 - 15:19:21 EST)
    • Re: [PERFORM] SELECT * FROM table is too slow Guillaume Cottenceau (Wed Jan 23 2008 - 03:47:42 EST)
  • Re: [PERFORM] RAID arrays and performance Gregory Stark (Tue Jan 29 2008 - 09:55:39 EST)
    • Re: [PERFORM] RAID arrays and performance Matthew (Tue Jan 29 2008 - 10:09:03 EST)
      • Re: [PERFORM] RAID arrays and performance Gregory Stark (Tue Jan 29 2008 - 10:52:20 EST)
      • Re: [PERFORM] RAID arrays and performance Kevin Grittner (Tue Jan 29 2008 - 11:23:22 EST)
      • Re: [PERFORM] RAID arrays and performance Gregory Stark (Tue Jan 29 2008 - 11:45:20 EST)
      • Re: [PERFORM] RAID arrays and performance Kevin Grittner (Tue Jan 29 2008 - 12:13:54 EST)