Skip site navigation (1)
Skip section navigation (2)
pgsql-performance 2004-04 Chronological Index (1/3)
Last updated: Wed Jan 18 04:21:59 2012
532 messages
01 May 2004
30 April 2004
Re: planner/optimizer question Kris Jurka (19:49)
Re: planner/optimizer question Gary Doades (18:59)
Re: planner/optimizer question Gary Doades (18:29)
Re: planner/optimizer question Jochem van Dieten (17:46)
Re: planner/optimizer question Jeff (12:32)
Re: analyzer/planner and clustered rows Manfred Koizar (07:30)
Re: planner/optimizer question Gary Doades (07:01)
Re: planner/optimizer question Gary Doades (06:34)
Re: Insert only tables and vacuum performance Joseph Shraibman (05:58)
Re: planner/optimizer question Dennis Bjorklund (05:27)
Re: Insert only tables and vacuum performance Tom Lane (04:30)
Re: why can't 2 indexes be used at once? Tom Lane (03:58)
Re: Insert only tables and vacuum performance Joseph Shraibman (00:53)
Re: Insert only tables and vacuum performance Rod Taylor (00:45)
29 April 2004
Re: Insert only tables and vacuum performance Joseph Shraibman (23:45)
Re: planner/optimizer question Tom Lane (23:18)
Insert only tables and vacuum performance Joseph Shraibman (23:15)
analyzer/planner and clustered rows Joseph Shraibman (23:15)
Re: planner/optimizer question Gary Doades (23:01)
Re: planner/optimizer question Gary Doades (22:30)
Re: Simply join in PostrgeSQL takes too long Josh Berkus (22:10)
Re: planner/optimizer question Tom Lane (21:54)
Re: planner/optimizer question Gary Doades (21:15)
Re: Simply join in PostrgeSQL takes too long Vitaly Belman (21:09)
Re: planner/optimizer question Gary Doades (21:08)
Re: planner/optimizer question Josh Berkus (20:54)
Re: planner/optimizer question Gary Doades (20:26)
Re: planner/optimizer question Rosser Schwarz (20:12)
Re: planner/optimizer question Gary Doades (19:23)
Re: planner/optimizer question Rod Taylor (19:13)
Re: Wierd context-switching issue on Xeon Josh Berkus (18:21)
Re: planner/optimizer question Gary Doades (18:13)
Re: Simply join in PostrgeSQL takes too long Manfred Koizar (17:57)
Re: Simply join in PostrgeSQL takes too long Rod Taylor (17:37)
Re: Simply join in PostrgeSQL takes too long Manfred Koizar (17:11)
Re: planner/optimizer question Manfred Koizar (17:00)
Re: [HACKERS] Number of pages in a random sample Manfred Koizar (16:54)
Use arrays or not? Roelant Ossewaarde (16:41)
Re: Wierd context-switching issue on Xeon ohp (13:20)
Re: Wierd context-switching issue on Xeon Robert Creager (02:41)
28 April 2004
Re: index usage Tom Lane (16:42)
Re: index usage scott.marlowe (15:41)
Re: planner/optimizer question Tom Lane (13:05)
Re: Join problem Tom Lane (12:52)
Re: Simply join in PostrgeSQL takes too long Rod Taylor (12:23)
Re: [JDBC] is a good practice to create an index on the Bruno Wolff III (08:28)
Re: Simply join in PostrgeSQL takes too long Manfred Koizar (08:22)
Re: [JDBC] is a good practice to create an index on the Christopher Kings-Lynne (08:19)
Re: [JDBC] is a good practice to create an index on the Edoardo Ceccarelli (08:13)
Re: Join problem Suller András (08:12)
Re: planner/optimizer question Manfred Koizar (07:32)
Re: planner/optimizer question Christopher Kings-Lynne (07:17)
Re: planner/optimizer question Gary Doades (07:07)
Re: planner/optimizer question Christopher Kings-Lynne (06:58)
Re: planner/optimizer question Gary Doades (06:35)
Re: planner/optimizer question Tom Lane (04:28)
Re: [JDBC] is a good practice to create an index on the Christopher Kings-Lynne (01:25)
27 April 2004
Re: Simply join in PostrgeSQL takes too long Rod Taylor (22:01)
Re: Simply join in PostrgeSQL takes too long Nick Barr (22:00)
Re: Simply join in PostrgeSQL takes too long Atesz (21:55)
Re: [JDBC] is a good practice to create an index on the Edoardo Ceccarelli (21:43)
Simply join in PostrgeSQL takes too long Vitaly Belman (21:27)
Re: Wierd context-switching issue on Xeon patch for 7.4.1 Josh Berkus (21:02)
Re: Wierd context-switching issue on Xeon patch for 7.4.1 Dave Cramer (18:23)
Re: Wierd context-switching issue on Xeon patch for 7.4.1 Josh Berkus (18:05)
Re: OT: Help with performance problems scott.marlowe (18:03)
Join problem Silke Trissl (17:32)
Re: [JDBC] is a good practice to create an index on the Dave Cramer (15:14)
Re: [JDBC] is a good practice to create an index on the Christopher Kings-Lynne (15:01)
Re: planner/optimizer question Atesz (12:54)
Re: Shared buffers, Sort memory, Effective Cache Size Manfred Koizar (12:09)
Re: [JDBC] is a good practice to create an index on the Dave Cramer (11:55)
Re: is a good practice to create an index on the oid? Christopher Kings-Lynne (02:43)
Re: Wierd context-switching issue on Xeon patch for 7.4.1 Dave Cramer (00:11)
Re: Wierd context-switching issue on Xeon patch for 7.4.1 Josh Berkus (00:03)
26 April 2004
Re: Wierd context-switching issue on Xeon Josh Berkus (19:20)
Re: index usage brad-pgperf (19:16)
Re: index usage Stephan Szabo (18:58)
Re: Help with performance problems Chris Hoover (17:21)
planner/optimizer question brad-pgperf (17:11)
is a good practice to create an index on the oid? Edoardo Ceccarelli (16:38)
Re: OT: Help with performance problems Rob Fielding (09:02)
25 April 2004
Number of pages in a random sample (was: query slows down with more accurate stats) Manfred Koizar (20:24)
Re: Why will vacuum not end? Shea,Dan [CIS] (13:05)
Re: Wierd context-switching issue on Xeon patch for 7.4.1 Andrew McMillan (07:13)
Re: Why will vacuum not end? Josh Berkus (01:50)
Re: Why will vacuum not end? Manfred Koizar (00:26)
Re: Why will vacuum not end? Manfred Koizar (00:02)
24 April 2004
Re: Why will vacuum not end? Shea,Dan [CIS] (19:48)
Re: Why will vacuum not end? Manfred Koizar (17:55)
Re: Setting Shared Buffers , Effective Cache, Sort Mem Josh Berkus (15:38)
Re: Why will vacuum not end? Josh Berkus (15:36)
Re: Why will vacuum not end? Shea,Dan [CIS] (14:45)
Re: order by index, and inheritance Michiel Meeuwissen (04:32)
Re: order by index, and inheritance Rod Taylor (04:29)
Re: order by index, and inheritance Michiel Meeuwissen (04:29)
Re: order by index, and inheritance Rod Taylor (04:28)
Re: Help with performance problems Tom Lane (02:58)
Re: Setting Shared Buffers , Effective Cache, Sort Mem Tom Lane (02:50)
23 April 2004
Re: Setting Shared Buffers , Effective Cache, Sort Mem Ron Mayer (22:04)
Re: Setting Shared Buffers , Effective Cache, Sort Mem Parameters Manfred Koizar (21:42)
Re: Help with performance problems Ron St-Pierre (21:35)
Re: Help with performance problems scott.marlowe (20:02)
Re: Help with performance problems Chris Hoover (19:27)
Re: Help with performance problems Ron St-Pierre (18:56)
Re: Why will vacuum not end? Josh Berkus (18:48)
Re: Why will vacuum not end? Shea,Dan [CIS] (18:19)
Re: Help with performance problems Josh Berkus (18:16)
Re: Help with performance problems Chris Hoover (18:01)
Re: Help with performance problems Chris Hoover (17:53)
Re: Help with performance problems scott.marlowe (17:25)
Re: Help with performance problems Chris Hoover (17:16)
Re: Help with performance problems Josh Berkus (16:43)
Re: Looking for ideas on how to speed up warehouse loading scott.marlowe (16:29)
Re: Help with performance problems Aaron Werman (15:16)
Help with performance problems Chris Hoover (13:31)
Re: Looking for ideas on how to speed up warehouse loading Aaron Werman (12:19)
Re: Looking for ideas on how to speed up warehouse loading Joe Conway (04:39)
Re: Wierd context-switching issue on Xeon Anjan Dave (02:27)
Re: Looking for ideas on how to speed up warehouse loading Tom Lane (02:03)
Re: Looking for ideas on how to speed up warehouse loading Nicholas Shanny (00:54)
22 April 2004
Re: Looking for ideas on how to speed up warehouse loading CoL (23:13)
Re: Setting Shared Buffers , Effective Cache, Sort Mem Parameters Manfred Koizar (22:48)
Looking for ideas on how to speed up warehouse loading Sean Shanny (21:57)
Re: Wierd context-switching issue on Xeon patch for 7.4.1 Rod Taylor (21:22)
Re: Wierd context-switching issue on Xeon patch for 7.4.1 Magnus Hagander (21:21)
Re: Setting Shared Buffers , Effective Cache, Sort Mem scott.marlowe (21:20)
Re: [pgsql-advocacy] MySQL vs PG TPC-H benchmarks Tom Lane (19:22)
Re: 225 times slower Pailloncy Jean-Gérard (18:47)
Re: Wierd context-switching issue on Xeon patch for 7.4.1 Bruce Momjian (18:31)
Re: [pgsql-advocacy] MySQL vs PG TPC-H benchmarks Markus Bertheau (18:21)
Re: Wierd context-switching issue on Xeon patch for 7.4.1 Josh Berkus (18:11)
Re: Wierd context-switching issue on Xeon patch for 7.4.1 Tom Lane (17:56)
Setting Shared Buffers , Effective Cache, Sort Mem Parameters Pallav Kalva (17:46)
Re: Wierd context-switching issue on Xeon patch for 7.4.1 Josh Berkus (17:37)
Re: [pgsql-advocacy] MySQL vs PG TPC-H benchmarks Eduardo Almeida (17:11)
Re: [pgsql-advocacy] MySQL vs PG TPC-H benchmarks Jan Wieck (16:20)
Re: [pgsql-advocacy] MySQL vs PG TPC-H benchmarks Tom Lane (15:54)
Re: [pgsql-advocacy] MySQL vs PG TPC-H benchmarks Eduardo Almeida (13:59)
Re: [pgsql-advocacy] MySQL vs PG TPC-H benchmarks Grega Bremec (13:42)
Re: [pgsql-advocacy] MySQL vs PG TPC-H benchmarks Eduardo Almeida (12:53)
Re: Wierd context-switching issue on Xeon patch for 7.4.1 Tom Lane (12:36)
Re: Wierd context-switching issue on Xeon patch for 7.4.1 Dave Cramer (06:04)
Re: Wierd context-switching issue on Xeon Tom Lane (06:03)
Re: 225 times slower Tom Lane (06:03)
Re: Wierd context-switching issue on Xeon patch for 7.4.1 Dave Cramer (06:01)
Re: Wierd context-switching issue on Xeon patch for 7.4.1 Tom Lane (05:13)
Re: Wierd context-switching issue on Xeon patch for 7.4.1 Bruce Momjian (04:56)
Re: Wierd context-switching issue on Xeon patch for 7.4.1 Christopher Kings-Lynne (04:37)
Re: Wierd context-switching issue on Xeon patch for 7.4.1 Tom Lane (04:23)
Re: Wierd context-switching issue on Xeon patch for 7.4.1 Josh Berkus (02:53)
Re: Wierd context-switching issue on Xeon patch for 7.4.1 Tom Lane (02:35)
Re: Wierd context-switching issue on Xeon Tom Lane (01:45)
21 April 2004
Re: Moving postgres to FC disks Cott Lang (21:50)
Re: Wierd context-switching issue on Xeon patch for 7.4.1 Dave Cramer (20:47)
Re: [pgsql-advocacy] MySQL vs PG TPC-H benchmarks Jan Wieck (19:38)
Re: Wierd context-switching issue on Xeon Dave Cramer (19:10)
Re: Help understanding stat tables Tom Lane (19:04)
Re: MySQL vs PG TPC-H benchmarks Matthew T. O'Connor (18:57)
Re: Wierd context-switching issue on Xeon Tom Lane (18:51)
Re: slow seqscan Tom Lane (18:20)
Re: Wierd context-switching issue on Xeon Paul Tuckfield (18:19)
Re: MySQL vs PG TPC-H benchmarks Josh Berkus (17:47)
Re: Wierd context-switching issue on Xeon Josh Berkus (17:30)
Re: Shared buffers, Sort memory, Effective Cache Size Qing Zhao (17:01)
Shared buffers, Sort memory, Effective Cache Size Frédéric Robinet (16:29)
Re: Help understanding stat tables Chris Hoover (16:25)
Re: slow seqscan Edoardo Ceccarelli (16:23)