Skip site navigation (1)
Skip section navigation (2)
pgsql-performance 2005-04 Chronological Index (1/5)
Last updated: Wed Jan 18 04:20:39 2012
771 messages
29 April 2005
Re: Distinct-Sampling (Gibbons paper) for Postgres a3a18850 (05:10)
Re: index on different types Michael Fuhr (03:28)
index on different types Enrico Weigelt (02:35)
28 April 2005
Re: [HACKERS] Bad n_distinct estimation; hacks suggested? Mischa Sandberg (15:21)
Re: Suggestions for a data-warehouse migration routine Mischa Sandberg (15:01)
Re: Why is this system swapping? Jeff (12:13)
Re: Final decision Dave Page (07:39)
Re: Final decision Bruce Momjian (03:47)
Re: ODBC driver overpopulation (was Re: Final decision) Bruce Momjian (03:44)
Re: Final decision Joshua D. Drake (03:43)
Re: ODBC driver overpopulation (was Re: Final decision) Joshua D. Drake (03:38)
ODBC driver overpopulation (was Re: Final decision) Alvaro Herrera (03:37)
Re: Final decision Josh Berkus (03:09)
27 April 2005
Re: Why is this system swapping? Greg Stark (23:46)
Re: Joel's Performance Issues WAS : Opteron vs Xeon Jim C. Nasby (21:01)
Re: Why is this system swapping? Anjan Dave (20:59)
Re: Why is this system swapping? Anjan Dave (20:54)
Re: Final decision Dave Page (19:47)
Re: Final decision John A Meinel (19:44)
Re: Why is this system swapping? Jeff (19:29)
Re: Final decision Steve Poe (19:16)
Re: Why is this system swapping? Anjan Dave (18:47)
Re: Final decision Joel Fradkin (18:47)
Re: Why is this system swapping? Jeff (18:29)
Re: Why is this system swapping? Greg Stark (18:29)
Re: Final decision Joel Fradkin (18:17)
Why is this system swapping? Anjan Dave (17:48)
Re: Final decision John A Meinel (17:38)
Re: Suggestions for a data-warehouse migration routine John A Meinel (17:38)
Re: [HACKERS] Bad n_distinct estimation; hacks suggested? Greg Stark (17:17)
Re: Final decision Joshua D. Drake (17:02)
Re: Final decision Joshua D. Drake (16:46)
Re: Final decision Josh Berkus (16:36)
Re: Final decision Dave Page (16:29)
Re: Final decision Josh Berkus (16:13)
Suggestions for a data-warehouse migration routine Richard Rowell (16:07)
Re: [HACKERS] Bad n_distinct estimation; hacks suggested? Dave Held (15:48)
Re: Final decision Rod Taylor (15:26)
Re: [HACKERS] Bad n_distinct estimation; hacks suggested? Josh Berkus (15:25)
Re: Final decision Joel Fradkin (15:17)
Re: Final decision mmiranda (15:08)
Final decision Joel Fradkin (15:01)
Re: [HACKERS] Bad n_distinct estimation; hacks suggested? Andrew Dunstan (13:44)
Re: What needs to be done for real Partitioning? Yann Michel (13:31)
Re: [HACKERS] Bad n_distinct estimation; hacks suggested? Simon Riggs (07:48)
Re: [HACKERS] Bad n_distinct estimation; hacks suggested? Mischa Sandberg (05:38)
Re: Joel's Performance Issues WAS : Opteron vs Xeon Kevin Brown (02:47)
Re: Table Partitioning: Will it be supported in Future? Mike Rylander (00:42)
26 April 2005
Re: speed up query with max() and odd estimates Matthew Nuzum (22:33)
Re: speed up query with max() and odd estimates John A Meinel (22:05)
Re: [HACKERS] Bad n_distinct estimation; hacks suggested? Gurmeet Manku (22:01)
Re: [HACKERS] Bad n_distinct estimation; hacks suggested? Andrew Dunstan (21:42)
Re: [HACKERS] Bad n_distinct estimation; hacks suggested? Simon Riggs (21:06)
Re: speed up query with max() and odd estimates Matthew Nuzum (21:02)
Re: speed up query with max() and odd estimates Steinar H. Gunderson (20:49)
Re: [HACKERS] Bad n_distinct estimation; hacks suggested? Josh Berkus (20:40)
Re: [HACKERS] Bad n_distinct estimation; hacks suggested? Simon Riggs (20:35)
speed up query with max() and odd estimates Matthew Nuzum (20:17)
Re: What needs to be done for real Partitioning? Roger Hand (19:53)
Re: pgbench Comparison of 7.4.7 to 8.0.2 Steve Poe (17:50)
Re: Table Partitioning: Will it be supported in Future? Mohan, Ross (16:59)
Re: Table Partitioning: Will it be supported in Future? Josh Berkus (16:48)
Re: Table Partitioning: Will it be supported in Future? Andreas Pflug (15:54)
Re: two queries and dual cpu (perplexed) John A Meinel (15:05)
Re: two queries and dual cpu (perplexed) Dave Held (14:58)
Re: two queries and dual cpu (perplexed) Shoaib Burq (VPAC) (14:31)
Re: Table Partitioning: Will it be supported in Future? apoc9009(at)yahoo(dot)de (09:59)
Re: BLOB's bypassing the OS Filesystem for better Image apoc9009(at)yahoo(dot)de (09:36)
Re: BLOB's bypassing the OS Filesystem for better Image Richard Huxton (09:10)
BLOB's bypassing the OS Filesystem for better Image loading speed? apoc9009(at)yahoo(dot)de (08:23)
Re: Table Partitioning: Will it be supported in Future? Richard Huxton (08:22)
Table Partitioning: Will it be supported in Future? (splitting large Tables) apoc9009(at)yahoo(dot)de (08:09)
Re: pgbench Comparison of 7.4.7 to 8.0.2 Thomas F . O'Connell (06:26)
Re: half the query time in an unnecessary(?) sort? Ron Mayer (05:42)
25 April 2005
Re: [HACKERS] Bad n_distinct estimation; hacks suggested? Dave Held (22:41)
Re: half the query time in an unnecessary(?) sort? Josh Berkus (22:06)
Re: [HACKERS] Bad n_distinct estimation; hacks suggested? Tom Lane (21:11)
Re: [HACKERS] Bad n_distinct estimation; hacks suggested? Dave Held (21:00)
Re: [HACKERS] Bad n_distinct estimation; hacks suggested? Andrew Dunstan (20:43)
half the query time in an unnecessary(?) sort? Ron Mayer (20:10)
Re: [HACKERS] Bad n_distinct estimation; hacks suggested? Josh Berkus (19:13)
Re: [HACKERS] Bad n_distinct estimation; hacks suggested? Josh Berkus (19:08)
Re: [HACKERS] Bad n_distinct estimation; hacks suggested? Simon Riggs (18:53)
Re: pgbench Comparison of 7.4.7 to 8.0.2 Steve Poe (17:18)
Re: pgbench Comparison of 7.4.7 to 8.0.2 Thomas F . O'Connell (15:45)
Re: [HACKERS] Bad n_distinct estimation; hacks suggested? Tom Lane (15:23)
Re: Joel's Performance Issues WAS : Opteron vs Xeon Merlin Moncure (14:15)
Re: [ODBC] Joel's Performance Issues WAS : Opteron vs Xeon Joel Fradkin (14:07)
Re: Joel's Performance Issues WAS : Opteron vs Xeon Merlin Moncure (13:52)
Re: [ODBC] Joel's Performance Issues WAS : Opteron vs Xeon Joel Fradkin (13:10)
Re: Bad n_distinct estimation; hacks suggested? Simon Riggs (09:01)
Re: pgbench Comparison of 7.4.7 to 8.0.2 Steve Poe (07:01)
Re: [HACKERS] Bad n_distinct estimation; hacks suggested? Tom Lane (04:59)
Re: Disk filling, CPU filling, renegade inserts and deletes? Richard Plotkin (03:14)
24 April 2005
Re: [HACKERS] Bad n_distinct estimation; hacks suggested? Josh Berkus (19:09)
Re: [HACKERS] Bad n_distinct estimation; hacks suggested? Josh Berkus (18:31)
Re: [HACKERS] Bad n_distinct estimation; hacks suggested? Andrew Dunstan (17:58)
Re: [HACKERS] Bad n_distinct estimation; hacks suggested? Marko Ristola (17:09)
Re: [ODBC] Joel's Performance Issues WAS : Opteron vs Xeon Marko Ristola (07:15)
Re: [HACKERS] Bad n_distinct estimation; hacks suggested? Tom Lane (04:49)
Re: pgbench Comparison of 7.4.7 to 8.0.2 Thomas F . O'Connell (02:33)
Re: pgbench Comparison of 7.4.7 to 8.0.2 Thomas F . O'Connell (02:31)
Re: [HACKERS] Bad n_distinct estimation; hacks suggested? Andrew Dunstan (00:33)
Re: two queries and dual cpu (perplexed) Tom Lane (00:10)
23 April 2005
Re: Bad n_distinct estimation; hacks suggested? Josh Berkus (23:34)
flattening the file might work for me here is the analyze. Joel Fradkin (20:18)
Re: Disk filling, CPU filling, renegade inserts and deletes? Tom Lane (19:51)
Re: Disk filling, CPU filling, renegade inserts and deletes? Richard Plotkin (18:37)
Re: Joel's Performance Issues WAS : Opteron vs Xeon Christopher Browne (18:32)
Re: Joel's Performance Issues WAS : Opteron vs Xeon Josh Berkus (18:28)
Re: Disk filling, CPU filling, renegade inserts and deletes? Tom Lane (18:17)
Re: Disk filling, CPU filling, renegade inserts and deletes? Richard Plotkin (18:11)
Re: Disk filling, CPU filling, renegade inserts and deletes? Tom Lane (18:06)
Re: Disk filling, CPU filling, renegade inserts and deletes? Richard Plotkin (16:59)
Re: Disk filling, CPU filling, renegade inserts and deletes? Richard Plotkin (16:57)
Re: Joel's Performance Issues WAS : Opteron vs Xeon brew (16:03)
Re: Joel's Performance Issues WAS : Opteron vs Xeon Joshua D. Drake (15:36)
Re: Joel's Performance Issues WAS : Opteron vs Xeon Joel Fradkin (14:11)
Re: Bad n_distinct estimation; hacks suggested? Greg Stark (08:02)
Re: Joel's Performance Issues WAS : Opteron vs Xeon Kevin Brown (06:30)
Re: Sort and index Tom Lane (05:00)
Re: Index bloat problem? Jim C. Nasby (03:12)
Interesting numbers on a CREATE INDEX Jim C. Nasby (03:09)
Re: Sort and index Jim C. Nasby (03:00)
Re: Joel's Performance Issues WAS : Opteron vs Xeon Jim C. Nasby (02:11)
Re: Sort and index Tom Lane (02:08)
Re: Joel's Performance Issues WAS : Opteron vs Xeon Jim C. Nasby (02:01)
Re: Sort and index Jim C. Nasby (01:54)
22 April 2005
Updating table, precautions? Anjan Dave (21:50)
Re: Joel's Performance Issues WAS : Opteron vs Xeon Joel Fradkin (21:04)
Re: Joel's Performance Issues WAS : Opteron vs Xeon Mischa Sandberg (20:54)
Re: Bad n_distinct estimation; hacks suggested? Josh Berkus (20:31)
Disk Edge Partitioning Richard_D_Levine (19:44)
Re: Bad n_distinct estimation; hacks suggested? Josh Berkus (18:47)
Re: Bad n_distinct estimation; hacks suggested? Marko Ristola (18:39)
Re: Joel's Performance Issues WAS : Opteron vs Xeon Alvaro Herrera (18:31)
Re: Joel's Performance Issues WAS : Opteron vs Xeon Bruce Momjian (18:04)
Re: Joel's Performance Issues WAS : Opteron vs Xeon Joel Fradkin (17:51)
Re: Index bloat problem? Tom Lane (17:28)
Re: Disk filling, CPU filling, renegade inserts and deletes? Richard Plotkin (16:30)
Re: Index bloat problem? David Roussel (16:16)
Re: Index bloat problem? Tom Lane (14:06)
Re: two queries and dual cpu (perplexed) Jeff (11:48)
Re: immutable functions vs. join for lookups ? Dawid Kuroczko (10:15)
Re: immutable functions vs. join for lookups ? Dawid Kuroczko (10:08)
Re: Joel's Performance Issues WAS : Opteron vs Xeon Andreas Pflug (09:47)
Re: When are index scans used over seq scans? Richard van den Berg (09:04)
Re: Index bloat problem? David Roussel (08:44)
Re: Joel's Performance Issues WAS : Opteron vs Xeon Dave Page (08:08)
Re: Index bloat problem? Tom Lane (05:57)
Re: two queries and dual cpu (perplexed) Gavin Sherry (03:58)
Re: foreign key performance Alvaro Herrera (03:55)
Re: two queries and dual cpu (perplexed) Shoaib Burq (VPAC) (03:33)
foreign key performance Enrico Weigelt (00:06)
21 April 2005
Re: Index bloat problem? Josh Berkus (23:51)
Re: Index bloat problem? Bill Chandler (23:41)
Re: Index bloat problem? Mischa Sandberg (23:38)
Re: index not used Stephan Szabo (21:58)
Re: Disk filling, CPU filling, renegade inserts and deletes? Richard Plotkin (21:08)
Re: Disk filling, CPU filling, renegade inserts and deletes? Alvaro Herrera (20:47)
Re: index not used Litao Wu (20:40)
Re: Index bloat problem? Josh Berkus (19:50)
Re: Index bloat problem? Dave Chapeskie (19:33)
Re: immutable functions vs. join for lookups ? Enrico Weigelt (19:24)
Re: index not used Darcy Buskermolen (19:23)
Re: immutable functions vs. join for lookups ? Enrico Weigelt (19:22)
Re: Index bloat problem? Alex Turner (19:12)