Peripheral Links

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

pgsql-performance - October 2005

Oct. 1, 2005

• Re: [PERFORM] A Better External Sort? Gregory Maxwell (01:44)
• Re: [PERFORM] A Better External Sort? Gregory Maxwell (02:07)
• Re: [HACKERS] A Better External Sort? Dann Corbit (05:32)
• Re: [HACKERS] A Better External Sort? Tom Lane (06:01)
• Re: [HACKERS] A Better External Sort? Dann Corbit (06:32)
• Re: [HACKERS] A Better External Sort? Simon Riggs (09:29)
• Re: database bloat, but vacuums are done, and fsm seems to be setup ok hubert depesz lubaczewski (10:01)
• Re: [HACKERS] A Better External Sort? Hannu Krosing (14:03)
• Re: [HACKERS] A Better External Sort? Ron Peacetree (14:22)
• Re: [HACKERS] A Better External Sort? Andrew Dunstan (15:19)
• Re: [HACKERS] A Better External Sort? Tom Lane (15:44)
• Re: [HACKERS] A Better External Sort? Greg Stark (16:17)
• Re: [HACKERS] A Better External Sort? Martijn van Oosterhout (16:19)
• Re: [HACKERS] A Better External Sort? Ron Peacetree (16:38)
• Re: [HACKERS] A Better External Sort? Ron Peacetree (17:42)
• Re: [HACKERS] Query in SQL statement Roger Hand (19:51)
• Which one FreeBSD or Linux AL ELK (20:08)
• Re: [HACKERS] Query in SQL statement Tom Lane (21:15)
• Re: [PERFORM] A Better External Sort? Martijn van Oosterhout (21:56)

Oct. 2, 2005

• Re: [PERFORM] A Better External Sort? Tom Lane (03:26)
• Re: [PERFORM] A Better External Sort? Martijn van Oosterhout (12:32)
• Re: [PERFORM] A Better External Sort? Martijn van Oosterhout (19:38)

Oct. 3, 2005

• Ultra-cheap NVRAM device Steinar H. Gunderson (11:02)
• URGENT: pg_statistic_relid_att_index has gone Harald Lau (12:27)
• Re: URGENT: pg_statistic_relid_att_index has gone Harald Lau (14:01)
• Re: URGENT: pg_statistic_relid_att_index has gone Tom Lane (14:08)
• index on custom function; explain jan.aerts@bbsrc.ac.uk (15:14)
• Alternative to a temporary table Steven Rosenstein (15:47)
• Re: Alternative to a temporary table Steve Atkins (16:20)
• Re: Ultra-cheap NVRAM device Dan Harris (17:15)
• Re: Ultra-cheap NVRAM device Dan Harris (17:21)
• Re: Ultra-cheap NVRAM device Jeffrey W. Baker (17:36)
• Re: Ultra-cheap NVRAM device Ron Peacetree (18:00)
• Re: Ultra-cheap NVRAM device Vivek Khera (19:06)
• Re: [HACKERS] A Better External Sort? Josh Berkus (20:34)
• Re: [HACKERS] A Better External Sort? Josh Berkus (20:40)
• Re: [HACKERS] A Better External Sort? Jeffrey W. Baker (20:42)
• Re: [HACKERS] A Better External Sort? Josh Berkus (21:16)
• Re: [HACKERS] A Better External Sort? Ron Peacetree (21:18)
• Re: [HACKERS] A Better External Sort? Luke Lonergan (21:28)
• Re: [HACKERS] A Better External Sort? Jeffrey W. Baker (21:32)
• Re: [HACKERS] A Better External Sort? Hannu Krosing (21:43)
• Re: [PERFORM] database bloat, but vacuums are done, and fsm seems Simon Riggs (21:47)
• Re: [PERFORM] A Better External Sort? Simon Riggs (21:51)
• Re: [HACKERS] A Better External Sort? Luke Lonergan (21:52)
• Re: [HACKERS] A Better External Sort? Michael Stone (21:53)
• Re: [HACKERS] A Better External Sort? Josh Berkus (21:59)
• Re: [HACKERS] A Better External Sort? Josh Berkus (22:03)
• Re: Query seem to slow if table have more than 200 million rows Qingqing Zhou (23:04)

Oct. 4, 2005

• Re: [HACKERS] A Better External Sort? Ron Peacetree (00:07)
• Re: [HACKERS] A Better External Sort? Gregory Maxwell (00:19)
• Re: [HACKERS] A Better External Sort? Ron Peacetree (00:32)
• Re: Comparative performance Joe (02:04)
• Re: Comparative performance PFC (08:45)
• Re: [PERFORM] A Better External Sort? Martijn van Oosterhout (10:04)
• Re: index on custom function; explain Jan Aerts (10:10)
• Re: Is There Any Way .... Stefan Weiss (10:31)
• Re: [PERFORM] A Better External Sort? Simon Riggs (11:24)
• Re: [PERFORM] A Better External Sort? Martijn van Oosterhout (12:24)
• Re: [PERFORM] A Better External Sort? Tom Lane (14:06)
• Re: [PERFORM] A Better External Sort? Martijn van Oosterhout (14:30)
• Re: Is There Any Way .... Lane Van Ingen (14:45)
• Re: [PERFORM] A Better External Sort? Simon Riggs (14:56)
• Re: [PERFORM] A Better External Sort? Tom Lane (15:01)
• Re: [PERFORM] A Better External Sort? Martijn van Oosterhout (15:23)
• Re: [PERFORM] A Better External Sort? mark (17:02)
• Re: Slow concurrent update of same row in a given table Jim C. Nasby (18:55)
• Re: Logarithmic change (decrease) in performance Jim C. Nasby (20:19)
• Re: Comparative performance Jim C. Nasby (20:31)
• Re: Comparative performance Jim C. Nasby (20:41)
• Re: [HACKERS] Query in SQL statement Jim C. Nasby (20:43)
• Re: SQL Function performance Jim C. Nasby (20:52)
• Re: Comparative performance Joe (20:57)
• Re: Is There Any Way .... Jim C. Nasby (20:57)
• Re: Lists or external TABLE? Jim C. Nasby (21:01)
• Re: Ultra-cheap NVRAM device Jim C. Nasby (21:02)
• Re: Comparative performance Joe (21:11)
• Re: SELECT LIMIT 1 VIEW Performance Issue Jim C. Nasby (21:15)
• Re: SELECT LIMIT 1 VIEW Performance Issue Jim C. Nasby (21:31)
• Re: Comparative performance Joe (21:37)
• Re: Comparative performance Jim C. Nasby (22:16)
• Re: SELECT LIMIT 1 VIEW Performance Issue Jim C. Nasby (22:19)
• Re: Is There Any Way .... Mark Lewis (22:23)
• Re: Comparative performance Dario (23:19)
• Re: Is There Any Way .... Ron Peacetree (23:33)

Oct. 5, 2005

• Re: Is There Any Way .... Jim C. Nasby (00:01)
• Re: Is There Any Way .... Douglas J. Trainor (00:40)
• Indexes on ramdisk Emil Briggs (01:09)
• Re: Is There Any Way .... Joshua D. Drake (01:32)
• Re: Is There Any Way .... Ron Peacetree (03:06)
• Re: Indexes on ramdisk Alex Turner (03:23)
• Re: Indexes on ramdisk Emil Briggs (03:41)
• Re: Is There Any Way .... Steve Atkins (03:50)
• Re: Is There Any Way .... mark (03:50)
• Re: Is There Any Way .... Kevin Grittner (06:16)
• Re: Query in SQL statement Richard Huxton (08:54)
• Re: Which one FreeBSD or Linux Richard Huxton (08:54)
• Re: [PERFORM] Query in SQL statement R, Rajesh (STSD) (09:03)
• Re: Query in SQL statement Richard Huxton (09:09)
• Re: [HACKERS] A Better External Sort? Michael Stone (09:41)
• Re: [HACKERS] A Better External Sort? Michael Stone (09:43)
• Re: [PERFORM] A Better External Sort? Hannu Krosing (10:32)
• Re: [PERFORM] A Better External Sort? Martijn van Oosterhout (10:49)
• Re: Is There Any Way .... Douglas J. Trainor (11:00)
• Re: Is There Any Way .... Dario (11:16)
• Re: SELECT LIMIT 1 VIEW Performance Issue Merlin Moncure (13:22)
• wal_buffers Ian Westmacott (13:23)
• Re: Is There Any Way .... Kevin Grittner (13:51)
• Re: Indexes on ramdisk Merlin Moncure (14:55)
• Re: Indexes on ramdisk Alex Turner (15:03)
• Re: Is There Any Way .... Frank Wiles (15:05)
• Re: [HACKERS] A Better External Sort? Luke Lonergan (15:24)
• Re: [HACKERS] A Better External Sort? Michael Stone (15:33)
• Re: [HACKERS] A Better External Sort? Ron Peacetree (16:14)
• Re: Ultra-cheap NVRAM device Chris Browne (17:01)
• Re: Is There Any Way .... Ron Peacetree (17:08)
• Re: [HACKERS] A Better External Sort? Joshua D. Drake (17:18)
• Re: [HACKERS] A Better External Sort? Ron Peacetree (17:21)
• Text/Varchar performance... Cristian Prieto (18:21)
• Re: [HACKERS] A Better External Sort? Jeffrey W. Baker (18:30)
• Re: Text/Varchar performance... Steinar H. Gunderson (18:34)
• Re: Ultra-cheap NVRAM device Merlin Moncure (18:35)
• Re: [PERFORM] Text/Varchar performance... Josh Berkus (19:00)
• Re: [PERFORM] A Better External Sort? Andrej Ricnik-Bay (19:43)
• Re: Is There Any Way .... Douglas J. Trainor (19:52)
• Re: [PERFORM] A Better External Sort? Jonah H. Harris (19:54)
• Re: Indexes on ramdisk Emil Briggs (23:46)
• Re: [HACKERS] A Better External Sort? Ron Peacetree (23:54)
• Re: [HACKERS] A Better External Sort? Luke Lonergan (23:55)

Oct. 6, 2005

• Re: [HACKERS] A Better External Sort? Steinar H. Gunderson (00:12)
• Re: wal_buffers Thomas F. O'Connell (06:39)
• Re: index on custom function; explain Yann Michel (08:19)
• Re: [HACKERS] A Better External Sort? Michael Stone (09:49)
• Re: [PERFORM] A Better External Sort? Hannu Krosing (10:37)
• Re: [PERFORM] A Better External Sort? Hannu Krosing (10:44)
• Re: wal_buffers Ian Westmacott (12:56)
• functions and execution plan caching Kelly Burkhart (13:17)
• Re: wal_buffers Alvaro Herrera (13:23)
• Re: [PERFORM] A Better External Sort? Martijn van Oosterhout (16:57)
• Re: index on custom function; explain Andrew McMillan (18:50)
• Re: functions and execution plan caching Michael Fuhr (19:46)
• Re: [HACKERS] A Better External Sort? Tom Lane (19:57)
• Re: [PERFORM] A Better External Sort? Martijn van Oosterhout (20:14)
• Re: [HACKERS] A Better External Sort? Alvaro Herrera (20:17)
• Re: [HACKERS] A Better External Sort? Tom Lane (20:25)
• Need Some Suggestions Lane Van Ingen (21:29)
• Re: [PERFORM] A Better External Sort? Martijn van Oosterhout (21:40)
• Status of Opteron vs Xeon Jeff Frost (23:55)

Oct. 7, 2005

• Re: Need Some Suggestions Richard Huxton (07:52)
• count(*) using index scan in "query often, update rarely" environment Cestmir Hybl (09:24)
• Re: count(*) using index scan in "query often, update rarely" environment hubert depesz lubaczewski (09:54)
• Re: count(*) using index scan in "query often, update rarely" environment Cestmir Hybl (10:14)
• Re: count(*) using index scan in "query often, update rarely" environment Steinar H. Gunderson (10:48)
• Re: count(*) using index scan in "query often, update rarely" environment Cestmir Hybl (11:14)
• Re: Status of Opteron vs Xeon Merlin Moncure (12:27)
• Re: count(*) using index scan in "query often, update rarely" environment Alvaro Herrera (13:07)
• Re: Need Some Suggestions Lane Van Ingen (13:37)
• Re: count(*) using index scan in "query often, update rarely" environment Tom Lane (13:42)
• Re: count(*) using index scan in "query often, update rarely" environment Merlin Moncure (13:50)
• Re: count(*) using index scan in "query often, update rarely" Richard Huxton (14:11)
• Re: Status of Opteron vs Xeon Chris Browne (17:33)
• Re: Status of Opteron vs Xeon Tom Lane (18:44)
• Re: wal_buffers Josh Berkus (18:51)
• Re: Status of Opteron vs Xeon Emil Briggs (19:03)
• Re: [HACKERS] A Better External Sort? Luke Lonergan (23:55)

Oct. 8, 2005

• Re: [HACKERS] A Better External Sort? mark (00:17)
• Re: [HACKERS] A Better External Sort? Luke Lonergan (04:20)
• Re: count(*) using index scan in "query often, update rarely" environment hubert depesz lubaczewski (10:44)
• Re: [HACKERS] A Better External Sort? mark (13:31)
• Re: count(*) using index scan in "query often, update rarely" environment mark (13:34)
• Re: [HACKERS] A Better External Sort? Jim C. Nasby (22:51)

Oct. 10, 2005

• What's the cost of a few extra columns? Announce (03:03)
• Server misconfiguration??? Andy (08:39)
• Re: Server misconfiguration??? Christopher Kings-Lynne (08:55)
• Re: Server misconfiguration??? Andy (09:42)
• Re: Text/Varchar performance... Ahmad Fajar (11:28)
• Compression of text columns Stef (12:17)
• Re: Compression of text columns Tino Wildenhain (12:27)
• Re: Text/Varchar performance... Steinar H. Gunderson (12:54)
• Re: Compression of text columns Stef (12:57)
• Query performance on ILIKE with AND operator... Federico Simonetti (Liveye) (13:27)
• Re: Server misconfiguration??? Tom Lane (14:18)
• Re: Server misconfiguration??? Andy (14:31)
• Re: Compression of text columns Tom Lane (14:38)
• Re: Server misconfiguration??? Christopher Kings-Lynne (14:56)
• Re: Query performance on ILIKE with AND operator... Tom Lane (14:58)
• Re: Query performance on ILIKE with AND operator... Federico Simonetti (Liveye) (15:18)
• Performance on SUSE w/ reiserfs Jon Brisbin (21:29)
• Re: Performance on SUSE w/ reiserfs Claus Guttesen (21:45)
• Re: Performance on SUSE w/ reiserfs Tom Lane (21:54)
• Re: Performance on SUSE w/ reiserfs Jon Brisbin (22:13)
• Re: Performance on SUSE w/ reiserfs Jon Brisbin (22:15)
• Re: Performance on SUSE w/ reiserfs Josh Berkus (22:15)
• XFS External Log on Pg 7.4.8 Pg_xlog drives? Steve Poe (22:28)
• Re: Performance on SUSE w/ reiserfs Alvaro Herrera (22:29)
• Re: Performance on SUSE w/ reiserfs Tom Lane (22:35)
• Re: XFS External Log on Pg 7.4.8 Pg_xlog drives? Michael Stone (22:48)

Oct. 11, 2005

• Re: What's the cost of a few extra columns? Jim C. Nasby (00:12)
• Re: What's the cost of a few extra columns? Announce (02:14)
• Re: Performance on SUSE w/ reiserfs Claus Guttesen (07:41)