Peripheral Links

• Home
• About
• Download
• Documentation
• Community
• Developers
• Support
• Your account

pgsql-performance - June 2007

June 1, 2007

• Seq Scan Tyler Durden (16:48)
• Re: Seq Scan Dan Harris (16:59)
• Re: Seq Scan Michael Glaesemann (17:03)
• Autodetect of software RAID1+0 fails Craig James (17:57)
• Re: Autodetect of software RAID1+0 fails Dimitri (18:51)
• PostgreSQL not fully utilizing system resources? Gregory Stewart (19:40)
• Re: Autodetect of software RAID1+0 fails Luke Lonergan (19:54)
• Re: Autodetect of software RAID1+0 fails Steinar H. Gunderson (21:35)

June 2, 2007

• Re: Autodetect of software RAID1+0 fails mark (00:23)
• Re: Autodetect of software RAID1+0 fails Luke Lonergan (05:41)
• upgraded to pgsql 8.2.4, getting worse performance then 7.4.x Douglas J Hunley (13:13)
• Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x Michael Fuhr (15:21)
• Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x Rafael Martinez (15:21)
• Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x Tom Lane (15:25)
• Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x Stefan Kaltenbrunner (15:31)
• Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x Kenneth Marshall (15:45)
• Re: Append table Hanu Kurubar (15:52)
• Re: Append table Arjen van der Meijden (16:04)
• Re: Append table Gregory Stark (16:36)
• Re: Postgres Benchmark Results Josh Berkus (19:44)
• Re: Append table Hanu Kurubar (19:49)

June 3, 2007

• Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x Douglas J Hunley (17:24)
• Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x Douglas J Hunley (17:29)
• Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x Luke Lonergan (20:39)
• Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x Greg Smith (22:30)

June 4, 2007

• Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x Tom Lane (03:17)
• Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x Douglas J Hunley (12:40)
• Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x Heikki Linnakangas (12:44)
• Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x Luke Lonergan (12:51)
• Re: upgraded to pgsql 8.2.4, getting worse performancethen 7.4.x Reid Thompson (14:28)
• dbt2 NOTPM numbers Markus Schiltknecht (15:00)
• Re: dbt2 NOTPM numbers Heikki Linnakangas (15:09)
• Re: dbt2 NOTPM numbers Markus Schiltknecht (15:26)
• Re: dbt2 NOTPM numbers PFC (16:47)
• Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x Douglas J Hunley (17:05)
• Thousands of tables versus on table? Thomas Andrews (17:40)
• Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x Alvaro Herrera (18:08)
• Re: Thousands of tables versus on table? Mark Lewis (18:15)
• Re: Thousands of tables versus on table? Thomas Andrews (18:45)
• Re: Thousands of tables versus on table? Thomas Andrews (18:46)
• Re: dbt2 NOTPM numbers Markus Schiltknecht (18:56)
• Re: Thousands of tables versus on table? Gregory Stark (19:43)
• Re: Thousands of tables versus on table? Thomas Andrews (19:57)
• Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x Douglas J Hunley (20:01)
• Re: Thousands of tables versus on table? Y Sidhu (20:08)
• Re: Thousands of tables versus on table? Thomas Andrews (20:14)
• Re: Thousands of tables versus on table? Gregory Stark (20:18)
• Re: Thousands of tables versus on table? Scott Marlowe (20:20)
• Re: Thousands of tables versus on table? PFC (20:21)
• Re: dbt2 NOTPM numbers Heikki Linnakangas (20:22)
• Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x Gregory Stark (21:11)
• Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x Heikki Linnakangas (21:17)
• Re: Thousands of tables versus on table? david (23:33)
• Re: PostgreSQL not fully utilizing system resources? Bill Moran (23:50)

June 5, 2007

• Re: PostgreSQL not fully utilizing system resources? Greg Smith (00:57)
• postgresql running on a virtual cluster Dave Cramer (02:00)
• Question about SQL performance Jason Lustig (03:18)
• Re: Question about SQL performance mark (05:23)
• Re: Question about SQL performance PFC (05:52)
• Re: Question about SQL performance Richard Huxton (08:50)
• Performance Problem Gauri Kanekar (09:26)
• Performance Problem Gauri Kanekar (09:53)
• Re: Performance Problem Steinar H. Gunderson (13:16)
• Re: Performance Problem Gregory Stark (13:32)
• Re: dbt2 NOTPM numbers Markus Schiltknecht (14:16)
• Re: dbt2 NOTPM numbers Heikki Linnakangas (14:21)
• Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x Douglas J Hunley (14:25)
• Re: dbt2 NOTPM numbers Markus Schiltknecht (14:25)
• Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x Douglas J Hunley (14:34)
• Re: dbt2 NOTPM numbers Greg Smith (14:42)
• Re: Thousands of tables versus on table? Scott Marlowe (16:48)
• Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x Hanu Kurubar (17:01)
• Re: Thousands of tables versus on table? Thomas Andrews (17:04)
• Re: Thousands of tables versus on table? Scott Marlowe (17:09)
• Re: Thousands of tables versus on table? Gregory Stark (18:55)
• Re: Thousands of tables versus on table? Scott Marlowe (19:34)
• Re: Append table Chander Ganesan (20:11)
• Re: Thousands of tables versus on table? david (20:33)
• Re: performance drop on 8.2.4, reverting to 8.1.4 Steven Flatt (21:30)
• Re: performance drop on 8.2.4, reverting to 8.1.4 Steinar H. Gunderson (21:38)
• Re: Thousands of tables versus on table? Tom Lane (21:59)
• Re: Thousands of tables versus on table? Steinar H. Gunderson (22:06)
• Re: performance drop on 8.2.4, reverting to 8.1.4 Tom Lane (22:08)
• Re: Thousands of tables versus on table? david (22:31)
• Re: Thousands of tables versus on table? david (22:58)

June 6, 2007

• weird query plan weiping (03:45)
• Re: weird query plan weiping (03:59)
• different query plan because different limit # (Re: weird query plan) weiping (07:24)
• Re: Thousands of tables versus on table? Heikki Linnakangas (07:29)
• Re: different query plan because different limit # (Re: weird query plan) weiping (07:40)
• Re: different query plan because different limit # (Re: weird query plan) Gregory Stark (09:21)
• Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x Douglas J Hunley (14:35)
• Re: weird query plan Tom Lane (14:40)
• Re: Thousands of tables versus on table? Scott Marlowe (15:07)
• Re: Thousands of tables versus on table? Scott Marlowe (15:17)
• Re: Thousands of tables versus on table? Craig James (16:23)
• Re: Thousands of tables versus on table? Scott Marlowe (16:49)
• Re: Thousands of tables versus on table? Craig James (17:32)
• Re: Thousands of tables versus on table? Jonah H. Harris (18:01)
• Re: Thousands of tables versus on table? Jonah H. Harris (18:15)
• VERY slow queries at random Gunther Mayer (19:20)
• Re: Thousands of tables versus on table? Andrew Sullivan (19:23)
• Re: Thousands of tables versus on table? Andrew Sullivan (19:32)
• Re: Thousands of tables versus on table? Jonah H. Harris (19:40)
• control of benchmarks (was: Thousands of tables) Andrew Sullivan (19:40)
• Re: VERY slow queries at random Andrew Sullivan (19:56)
• Re: control of benchmarks (was: Thousands of tables) Jonah H. Harris (19:57)
• Re: Thousands of tables versus on table? Craig James (20:13)
• Re: Thousands of tables versus on table? Jonah H. Harris (20:20)
• Is this true? Chris Hoover (20:58)
• Re: VERY slow queries at random Scott Marlowe (21:27)
• Re: Is this true? Jeff Davis (21:37)
• reclaiming disk space after major updates Dan Harris (22:04)
• Re: LIKE search and performance James Mansion (22:23)
• Weird 8.2.4 performance Kurt Overberg (23:27)

June 7, 2007

• Re: Weird 8.2.4 performance Mark Kirkwood (00:01)
• Re: Weird 8.2.4 performance Michael Glaesemann (00:14)
• Re: LIKE search and performance mark (03:33)
• Re: Thousands of tables versus on table? david (05:22)
• Re: VERY slow queries at random Kristo Kaiv (07:09)
• copy from performance on large tables with indexes Marc Mamin (09:17)
• Re: Weird 8.2.4 performance Richard Huxton (09:23)
• Re: Weird 8.2.4 performance Steinar H. Gunderson (09:35)
• Re: Weird 8.2.4 performance Steinar H. Gunderson (09:43)
• Re: Weird 8.2.4 performance Mark Kirkwood (11:12)
• Re: Weird 8.2.4 performance Kurt Overberg (11:18)
• Re: Weird 8.2.4 performance Steinar H. Gunderson (11:28)
• Re: Weird 8.2.4 performance Tom Lane (13:32)
• Re: {Spam} Re: Weird 8.2.4 performance Dimitri Fontaine (13:54)
• Re: VERY slow queries at random Gunther Mayer (14:22)
• Re: VERY slow queries at random Gunther Mayer (15:32)
• Re: VERY slow queries at random Gunther Mayer (15:38)
• Re: VERY slow queries at random Andrew Sullivan (15:45)
• Re: VERY slow queries at random Alvaro Herrera (15:58)
• How Are The Variables Related? Y Sidhu (16:47)
• Re: performance drop on 8.2.4, reverting to 8.1.4 Steven Flatt (17:11)
• Getting Slow Joe Lester (17:48)
• Re: Getting Slow Andrew Sullivan (18:37)
• Re: Getting Slow Steinar H. Gunderson (18:50)
• Re: Getting Slow Alvaro Herrera (18:58)
• Re: reclaiming disk space after major updates Andrew Sullivan (19:20)
• Re: Getting Slow Greg Smith (19:26)
• Re: VERY slow queries at random Greg Smith (19:42)
• Best way to delete unreferenced rows? Tyrrill, Ed (20:02)
• Re: reclaiming disk space after major updates Dan Harris (21:26)
• Re: Best way to delete unreferenced rows? Craig James (22:50)
• Re: Weird 8.2.4 performance Mark Kirkwood (23:04)
• Re: Weird 8.2.4 performance Joshua D. Drake (23:09)

June 8, 2007

• Re: performance drop on 8.2.4, reverting to 8.1.4 Tom Lane (01:11)
• Re: performance drop on 8.2.4, reverting to 8.1.4 Alvaro Herrera (01:22)
• Re: performance drop on 8.2.4, reverting to 8.1.4 Tom Lane (01:31)
• Re: Getting Slow Tom Lane (01:46)
• Re: Getting Slow Alvaro Herrera (02:24)
• Database size choksi (08:22)
• Re: VERY slow queries at random Kristo Kaiv (08:27)
• Re: reclaiming disk space after major updates Andrew Sullivan (14:03)
• Re: [ADMIN] reclaiming disk space after major updates Dan Harris (14:29)
• Re: [ADMIN] reclaiming disk space after major updates Andrew Sullivan (15:10)
• Please help me understand these numbers Chris Hoover (15:44)
• Re: Please help me understand these numbers Bill Moran (16:09)
• How much ram is too much Dave Cramer (16:31)
• Re: Best way to delete unreferenced rows? Tyrrill, Ed (16:45)
• Re: How much ram is too much Guy Rouillier (16:46)
• Re: How much ram is too much Ben (16:52)
• Re: dbt2 NOTPM numbers Mark Wong (17:01)
• Re: Please help me understand these numbers Chris Hoover (17:05)
• Re: How much ram is too much Dave Cramer (17:08)
• Re: How much ram is too much david (17:30)
• Re: Please help me understand these numbers Bill Moran (17:37)
• Re: How much ram is too much Joshua D. Drake (17:38)
• [OT] Re: How much ram is too much Zoltan Boszormenyi (17:38)
• Re: Please help me understand these numbers Chris Hoover (17:52)
• Re: [OT] Re: How much ram is too much Joshua D. Drake (18:10)
• Re: [OT] Re: How much ram is too much Dave Cramer (18:52)
• Re: [OT] Re: How much ram is too much Zoltan Boszormenyi (18:54)
• Re: [OT] Re: How much ram is too much mark (19:00)
• Re: [OT] Re: How much ram is too much Zoltan Boszormenyi (19:14)
• Re: How much ram is too much Guy Rouillier (19:41)
• Re: [OT] Re: How much ram is too much Andreas Kostyrka (21:43)

June 11, 2007

• Re: Vacuum takes forever Jim Nasby (02:51)
• Re: dbt2 NOTPM numbers Jim Nasby (03:08)
• Re: How much ram is too much Jim Nasby (03:11)
• pg_statistic doesnt contain details for specific table Nimesh Satam (08:50)
• Re: pg_statistic doesnt contain details for specific table Heikki Linnakangas (08:54)
• Re: pg_statistic doesnt contain details for specific table Nimesh Satam (08:58)
• Re: How much ram is too much Dave Cramer (10:55)
• Variable (degrading) perfomance Vladimir Stankovic (13:04)
• Re: pg_statistic doesnt contain details for specific table Michael Fuhr (13:29)
• Re: pg_statistic doesnt contain details for specific table Nimesh Satam (13:52)
• Re: pg_statistic doesnt contain details for specific table Michael Fuhr (14:34)
• Re: How much ram is too much Dave Cramer (15:09)
• test / live environment, major performance difference Christo Du Preez (15:10)
• Re: dbt2 NOTPM numbers Markus Schiltknecht (15:30)
• Re: How much ram is too much Andrew Sullivan (15:34)
• Re: dbt2 NOTPM numbers Heikki Linnakangas (15:34)
• Re: dbt2 NOTPM numbers Markus Schiltknecht (15:44)
• Re: Best way to delete unreferenced rows? Craig James (15:44)
• Re: test / live environment, major performance difference Ansgar -59cobalt- Wiechers (15:58)
• Re: test / live environment, major performance difference Dave Dutcher (16:16)
• Variable (degrading) performance Vladimir Stankovic (17:21)