Search

Peripheral Links

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

pgsql-performance - March 2011

Search archives
	(enter a message-id to go directly to that message)	Advanced Search

Prev | Next

March 1, 2011

• Re: Load and Stress on PostgreSQL 9.0 Selva manickaraja (01:48)
• Re: inheritance: planning time vs children number vs column number Tom Lane (06:20)
• Re: inheritance: planning time vs children number vs column number Marc Cousin (07:42)
• Two different execution plans for similar requests Joby Joba (08:46)
• Re: Two different execution plans for similar requests tv (09:10)
• Re: Two different execution plans for similar requests Joby Joba (09:25)
• Re: Two different execution plans for similar requests tv (09:40)
• Re: Two different execution plans for similar requests Joby Joba (12:37)
• Re: Two different execution plans for similar requests Joby Joba (12:44)
• Re: inheritance: planning time vs children number vs column number Tom Lane (15:33)
• Re: Talking about optimizer, my long dream Merlin Moncure (15:37)
• Re: inheritance: planning time vs children number vs column number Marc Cousin (15:39)
• Re: Two different execution plans for similar requests Maciek Sakrejda (17:07)
• Re: inheritance: planning time vs children number vs column number Tom Lane (17:33)

March 2, 2011

• Performance trouble finding records through related records sverhagen (00:14)
• Re: Performance trouble finding records through related records Andy Colson (03:41)
• Re: Pushing IN (subquery) down through UNION ALL? Robert Haas (14:08)
• Re: Pushing IN (subquery) down through UNION ALL? Thom Brown (14:11)
• Re: Pushing IN (subquery) down through UNION ALL? Robert Haas (14:22)
• Re: Pushing IN (subquery) down through UNION ALL? Thom Brown (14:23)
• Re: Anyone tried Flashcache with PostgreSQL? Robert Haas (15:29)
• Re: Query on view radically slower than query on underlying table Robert Haas (15:39)
• Re: Vacuum problem due to temp tables Robert Haas (15:44)
• Re: Performance Test for PostgreSQL9 Robert Haas (18:19)
• Re: Performance Test for PostgreSQL9 Joshua D. Drake (18:29)

March 3, 2011

• Re: Performance trouble finding records through related records sverhagen (00:12)
• Re: Anyone tried Flashcache with PostgreSQL? Samuel Gendler (00:20)
• Re: Performance Test for PostgreSQL9 Selva manickaraja (01:46)
• Re: Performance trouble finding records through related records Andy Colson (03:04)
• Re: Performance Test for PostgreSQL9 Greg Smith (04:01)
• Is it require further tuning Adarsh Sharma (04:31)
• Re: Performance Test for PostgreSQL9 Selva manickaraja (05:16)
• Re: Performance Test for PostgreSQL9 Joshua D. Drake (05:20)
• Re: Anyone tried Flashcache with PostgreSQL? Arjen van der Meijden (08:15)
• Re: Is Query need to be optimized Grzegorz Jaśkiewicz (09:07)
• Re: Performance trouble finding records through related records sverhagen (09:19)
• Slowing UPDATEs inside a transaction Matt Burke (14:13)
• Re: Slowing UPDATEs inside a transaction Robert Haas (14:26)
• Re: Performance trouble finding records through related records Andy Colson (14:55)
• Re: Slowing UPDATEs inside a transaction Merlin Moncure (15:23)

March 4, 2011

• Re: Slowing UPDATEs inside a transaction Matt Burke (09:21)
• Re: Vacuum problem due to temp tables Vidhya Bondre (10:26)
• Slow join on partitioned table Mark Thornton (11:40)
• Re: Vacuum problem due to temp tables Robert Haas (14:14)
• Re: Slowing UPDATEs inside a transaction Robert Haas (14:20)
• Re: Slowing UPDATEs inside a transaction Merlin Moncure (14:51)
• Re: Is it require further tuning Robert Haas (14:55)
• Calculating 95th percentiles Landreville (15:18)
• Re: Slow join on partitioned table Robert Haas (16:07)
• Re: Slow join on partitioned table Mark Thornton (16:47)
• Re: Slow join on partitioned table Mark Thornton (17:00)
• Linux I/O schedulers - CFQ & random seeks Glyn Astill (17:34)
• Re: Linux I/O schedulers - CFQ & random seeks Wayne Conrad (18:03)
• Re: Slow join on partitioned table Robert Haas (18:06)
• Re: Linux I/O schedulers - CFQ & random seeks Dan Harris (18:39)
• Re: Linux I/O schedulers - CFQ & random seeks Scott Marlowe (19:02)
• Re: Linux I/O schedulers - CFQ & random seeks Kevin Grittner (19:07)
• Re: Linux I/O schedulers - CFQ & random seeks Rosser Schwarz (19:09)

March 5, 2011

• Re: Calculating 95th percentiles Pierre C (07:54)
• Table partitioning Tobias Brox (09:37)
• Re: Table partitioning Mark Thornton (09:57)
• Re: Table partitioning Mark Thornton (09:59)
• Re: Table partitioning Tobias Brox (10:09)

March 6, 2011

• Re: Calculating 95th percentiles marcin mank (00:34)
• Re: Linux I/O schedulers - CFQ & random seeks Omar Kilani (00:38)

March 7, 2011

• Performance issues Andreas Forø Tollefsen (13:45)
• Re: Performance issues Kenneth Marshall (14:01)
• Re: Performance issues Andreas Forø Tollefsen (14:17)
• Re: Performance issues Kenneth Marshall (14:22)
• Re: Performance issues Andreas Forø Tollefsen (14:29)
• Re: Performance issues Oleg Bartunov (15:34)
• Re: Anyone tried Flashcache with PostgreSQL? Cédric Villemain (15:48)
• plan variations: join vs. exists vs. row comparison Jon Nelson (19:07)
• Re: Performance trouble finding records through related records Robert Haas (19:25)
• Re: plan variations: join vs. exists vs. row comparison Tom Lane (20:00)
• Re: plan variations: join vs. exists vs. row comparison Merlin Moncure (20:05)
• Re: plan variations: join vs. exists vs. row comparison Jon Nelson (20:06)
• Re: plan variations: join vs. exists vs. row comparison Kevin Grittner (20:24)
• Re: Performance trouble finding records through related records Merlin Moncure (20:27)
• Re: Query performance with disabled hashjoin and mergejoin Merlin Moncure (20:40)
• Re: Performance issues Andreas Forø Tollefsen (21:49)
• Re: Performance issues David Kerr (23:29)

March 8, 2011

• Re: Performance issues Tom Lane (00:38)
• How to tune this query Adarsh Sharma (05:01)
• Re: How to tune this query Jaiswal Dhaval Sudhirkumar (06:24)
• Re: Performance issues Andreas Forø Tollefsen (08:42)
• Re: Performance trouble finding records through related records sverhagen (11:17)
• Re: Performance trouble finding records through related records sverhagen (11:31)
• Re: Performance issues Andy Colson (15:21)
• Table partitioning problem Samba GUEYE (15:45)
• Re: Performance issues Andreas Forø Tollefsen (16:58)
• Re: Performance issues Andreas Forø Tollefsen (17:00)
• Re: Linux I/O schedulers - CFQ & random seeks Mindaugas Riauba (18:27)
• Re: Performance issues Andy Colson (19:13)
• Re: Query performance with disabled hashjoin and mergejoin Robert Haas (20:57)
• Re: Query performance with disabled hashjoin and mergejoin Tom Lane (21:24)
• Re: Query performance with disabled hashjoin and mergejoin Merlin Moncure (21:56)

March 9, 2011

• Re: Query performance with disabled hashjoin and mergejoin Robert Haas (16:48)
• Re: Table partitioning problem Jim Nasby (22:01)
• Re: Slow join on partitioned table Conor Walsh (22:42)
• Re: NULLS LAST performance Jim Nasby (23:01)

March 10, 2011

• Re: Table partitioning problem Samba GUEYE (08:25)
• Basic performance tuning on dedicated server runner (09:12)
• Re: Performance trouble finding records through related records sverhagen (14:10)
• Tuning massive UPDATES and GROUP BY's? fork (15:40)
• Re: NULLS LAST performance Robert Haas (15:55)
• unexpected stable function behavior Julius Tuskenis (16:26)
• Re: NULLS LAST performance Merlin Moncure (16:32)
• Re: Tuning massive UPDATES and GROUP BY's? Merlin Moncure (16:45)
• Re: Basic performance tuning on dedicated server Merlin Moncure (18:02)
• Re: Tuning massive UPDATES and GROUP BY's? fork (18:04)
• Re: unexpected stable function behavior Merlin Moncure (21:14)
• big joins not converging Dan Ancona (21:25)
• Re: big joins not converging Steve Atkins (22:13)
• Re: Tuning massive UPDATES and GROUP BY's? Marti Raudsepp (22:42)
• Re: big joins not converging fork (23:48)

March 11, 2011

• Re: big joins not converging Dan Ancona (00:43)
• Re: NULLS LAST performance Robert Haas (04:36)
• ANTI-JOIN needs table, index scan not possible? hans wulf (15:32)
• Re: big joins not converging fork (16:46)
• Re: ANTI-JOIN needs table, index scan not possible? Maciek Sakrejda (17:18)
• Re: ANTI-JOIN needs table, index scan not possible? hans wulf (17:54)
• Re: Table partitioning problem Robert Haas (18:31)
• Re: Tuning massive UPDATES and GROUP BY's? fork (19:06)
• Re: ANTI-JOIN needs table, index scan not possible? Kenneth Marshall (22:16)
• Re: ANTI-JOIN needs table, index scan not possible? Kevin Grittner (22:32)

March 12, 2011

• Planner wrongly shuns multi-column index for select .. order by col1, col2 limit 1 John Surcombe (10:07)
• Re: Tuning massive UPDATES and GROUP BY's? Marti Raudsepp (17:07)

March 13, 2011

• Re: Planner wrongly shuns multi-column index for select .. order by col1, col2 limit 1 Jeremy (12:21)
• Re: Planner wrongly shuns multi-column index for select .. order by col1, col2 limit 1 Tom Lane (16:24)
• Re: Tuning massive UPDATES and GROUP BY's? runner (16:36)
• Re: Planner wrongly shuns multi-column index for select .. order by col1, col2 limit 1 Tom Lane (22:10)

March 14, 2011

• Re: unexpected stable function behavior Julius Tuskenis (08:46)
• Re: Planner wrongly shuns multi-column index for select .. order by col1, col2 limit 1 John Surcombe (09:37)
• Re: Tuning massive UPDATES and GROUP BY's? Marti Raudsepp (10:17)
• Re: Tuning massive UPDATES and GROUP BY's? Greg Spiegelberg (13:34)
• Re: unexpected stable function behavior Merlin Moncure (13:41)
• Re: unexpected stable function behavior Andres Freund (14:08)
• Re: Tuning massive UPDATES and GROUP BY's? runner (15:54)
• Re: Performance regression from 8.3.7 to 9.0.3 Claudio Freire (15:54)
• Re: Table partitioning problem Samba GUEYE (16:42)
• Re: unexpected stable function behavior Tom Lane (17:17)
• Bug in the planner? Claudio Freire (17:24)
• Re: Planner wrongly shuns multi-column index for select .. order by col1, col2 limit 1 Tom Lane (17:24)
• Re: Performance regression from 8.3.7 to 9.0.3 Merlin Moncure (17:34)
• Re: Performance regression from 8.3.7 to 9.0.3 Merlin Moncure (17:59)
• Re: Performance regression from 8.3.7 to 9.0.3 Tom Lane (18:50)
• Re: Table partitioning problem Robert Haas (19:40)
• Re: Table partitioning problem Conor Walsh (20:22)

March 15, 2011

• Re: Bug in the planner? Tom Lane (00:56)
• Re: unexpected stable function behavior Julius Tuskenis (08:04)
• Re: unexpected stable function behavior Julius Tuskenis (08:12)
• Re: Table partitioning problem Samba GUEYE (10:10)
• Re: Index use difference betweer LIKE, LIKE ANY? Chetan Suttraway (12:30)
• Re: Table partitioning problem Shaun Thomas (13:18)
• pg_xlog size Tech Madhu (15:09)
• Re: Table partitioning problem Samba GUEYE (15:19)
• Adding additional index causes 20,000x slowdown for certain select queries - postgres 9.0.3 Timothy Garnett (18:23)
• Re: Adding additional index causes 20,000x slowdown for certain select queries - postgres 9.0.3 Timothy Garnett (18:39)
• Re: Adding additional index causes 20,000x slowdown for certain select queries - postgres 9.0.3 Timothy Garnett (18:42)

March 16, 2011

• big distinct clause vs. group by Uwe Bartels (08:45)
• Help with Query Tuning Adarsh Sharma (09:13)
• Custom operator class costs Ben Beecher (14:10)
• Re: Help with Query Tuning Kenneth Marshall (16:36)
• Re: Adding additional index causes 20,000x slowdown for certain select queries - postgres 9.0.3 Kevin Grittner (16:40)
• Re: Re: Adding additional index causes 20,000x slowdown for certain select queries - postgres 9.0.3 Tom Lane (17:01)
• Re: Adding additional index causes 20,000x slowdown for certain select queries - postgres 9.0.3 Shaun Thomas (17:05)
• Re: Help with Query Tuning Reid Thompson (17:24)
• Re: pg_xlog size Euler Taveira de Oliveira (17:27)
• Re: Adding additional index causes 20,000x slowdown for certain select queries - postgres 9.0.3 Tom Lane (17:38)
• Re: Re: Adding additional index causes 20,000x slowdown for certain select queries - postgres 9.0.3 Kevin Grittner (17:44)
• Re: Re: Adding additional index causes 20,000x slowdown for certain select queries - postgres 9.0.3 Shaun Thomas (18:34)
• Re: Re: Adding additional index causes 20,000x slowdown for certain select queries - postgres 9.0.3 Claudio Freire (18:39)
• Updating histogram_bounds after a delete Derrick Rice (19:40)
• Re: Updating histogram_bounds after a delete Derrick Rice (19:41)
• Re: Re: Adding additional index causes 20,000x slowdown for certain select queries - postgres 9.0.3 Kevin Grittner (19:42)
• Re: pg_xlog size Tech Madhu (21:27)
• Re: Updating histogram_bounds after a delete Kevin Grittner (21:56)

March 17, 2011

• Re: pg_xlog size Fujii Masao (03:09)
• Re: Help with Query Tuning Adarsh Sharma (04:48)
• Re: Help with Query Tuning Adarsh Sharma (06:25)
• Re: Help with Query Tuning tv (09:34)
• Re: Updating histogram_bounds after a delete Derrick Rice (13:27)
• Fastest pq_restore? Michael Andreasen (14:25)
• Re: Updating histogram_bounds after a delete Kevin Grittner (14:49)
• Re: Updating histogram_bounds after a delete Kenneth Marshall (14:55)
• Re: Updating histogram_bounds after a delete Tom Lane (15:00)
• Re: Updating histogram_bounds after a delete Kevin Grittner (15:05)
• Xeon twice the performance of opteron Jeff (15:13)
• Re: Xeon twice the performance of opteron J Sisson (16:42)
• Re: Xeon twice the performance of opteron Claudio Freire (16:51)
• Re: Xeon twice the performance of opteron Craig James (16:54)
• Re: Adding additional index causes 20,000x slowdown for certain select queries - postgres 9.0.3 Timothy Garnett (16:55)
• Re: Adding additional index causes 20,000x slowdown for certain select queries - postgres 9.0.3 Kevin Grittner (18:13)
• Re: Adding additional index causes 20,000x slowdown for certain select queries - postgres 9.0.3 Timothy Garnett (20:33)

March 18, 2011

• Request for feedback on hardware for a new database server Oliver Charles (00:51)
• Re: Fastest pq_restore? Andy Colson (01:08)
• Re: Xeon twice the performance of opteron mark (01:24)
• Re: Xeon twice the performance of opteron Scott Marlowe (01:39)
• Re: Request for feedback on hardware for a new database server Steve Atkins (02:05)

Prev | Next