Peripheral Links

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

pgsql-performance - November 2005

2005-11-01

• Re: 8.1beta3 performance Steinar H. Gunderson (02:00)
• Re: 8.1beta3 performance Neil Conway (02:06)
• pgbench results interpretation? Joost Kraaijeveld (08:03)
• Re: pgbench results interpretation? Gavin Sherry (09:16)
• Re: pgbench results interpretation? Joost Kraaijeveld (10:05)
• Re: 8.x index insert performance Kelly Burkhart (13:33)
• Re: 8.x index insert performance Tom Lane (13:45)
• solutions for new Postgresql application testing Geoffrey (14:14)
• Re: 8.1beta3 performance Jon Brisbin (14:50)
• Re: 8.x index insert performance Ron Peacetree (15:37)
• Re: 8.1beta3 performance Dave Page (15:49)
• Re: 8.1beta3 performance Tom Lane (17:24)
• improvise callbacks in plpgsql Merlin Moncure (19:00)
• Re: solutions for new Postgresql application testing Merlin Moncure (19:39)
• Re: improvise callbacks in plpgsql Tom Lane (21:29)
• Re: improvise callbacks in plpgsql Merlin Moncure (22:13)
• Re: improvise callbacks in plpgsql Jim C. Nasby (23:04)
• Re: solutions for new Postgresql application testing Geoffrey (23:12)
• Joining views disables indexes? Mitch Pirtle (23:16)
• Re: Joining views disables indexes? Jim C. Nasby (23:23)
• Re: Joining views disables indexes? Steinar H. Gunderson (23:28)
• Re: Joining views disables indexes? Tom Lane (23:28)

2005-11-02

• Re: performance of implicit join vs. explicit conditions on inet queries? Qingqing Zhou (01:19)
• Re: performance of implicit join vs. explicit conditions on inet queries? Tom Lane (04:20)
• Re: 8.1beta3 performance PostgreSQL (09:32)
• Re: pgbench results interpretation? Gavin Sherry (10:16)
• Re: insert performance for win32 Merlin Moncure (13:36)
• Re: improvise callbacks in plpgsql Merlin Moncure (13:45)
• Re: insert performance for win32 Magnus Hagander (13:54)
• Re: 8.1beta3 performance Tom Lane (14:41)
• Re: pgbench results interpretation? Joost Kraaijeveld (14:41)
• Re: insert performance for win32 Marc Cousin (14:47)
• Re: insert performance for win32 Tom Lane (15:11)
• Performance difference between sql and pgsql function... Cristian Prieto (15:32)
• Re: improvise callbacks in plpgsql Merlin Moncure (16:47)
• Re: improvise callbacks in plpgsql Merlin Moncure (17:04)
• Re: 8.x index insert performance Greg Stark (17:26)
• Trigger Rowsets Ralph Mason (23:34)
• Re: [PERFORM] improvise callbacks in plpgsql Jim C. Nasby (23:44)
• Re: Trigger Rowsets Jim C. Nasby (23:50)

2005-11-03

• Re: [PERFORM] improvise callbacks in plpgsql David Fetter (02:52)
• Sorted union Scott Lamb (05:13)
• Re: Sorted union Scott Lamb (05:27)
• Re: insert performance for win32 Qingqing Zhou (07:11)
• Re: Sorted union Merlin Moncure (13:53)
• Re: [PERFORM] improvise callbacks in plpgsql Merlin Moncure (14:01)
• Function with table%ROWTYPE globbing Sven Willenberger (15:14)
• Re: Function with table%ROWTYPE globbing Merlin Moncure (15:37)
• Re: Sorted union Scott Lamb (15:41)
• Re: Sorted union Merlin Moncure (16:20)
• Re: Sorted union Scott Lamb (18:02)
• Re: insert performance for win32 Merlin Moncure (18:03)
• Re: Sorted union Merlin Moncure (18:21)
• Re: Sorted union Kevin Grittner (18:32)
• Re: Sorted union Merlin Moncure (18:37)
• Re: insert performance for win32 Merlin Moncure (18:42)
• Re: insert performance for win32 Merlin Moncure (18:47)
• Re: Sorted union Scott Lamb (18:49)
• Re: insert performance for win32 Magnus Hagander (19:04)
• Re: Sorted union Kevin Grittner (19:11)
• Re: insert performance for win32 Qingqing Zhou (20:25)
• Re: insert performance for win32 Magnus Hagander (20:30)
• Re: insert performance for win32 Qingqing Zhou (20:34)
• Re: insert performance for win32 Magnus Hagander (20:39)
• Re: insert performance for win32 Merlin Moncure (21:04)
• Re: insert performance for win32 Qingqing Zhou (21:06)
• Re: insert performance for win32 Magnus Hagander (21:15)
• Re: insert performance for win32 Qingqing Zhou (21:46)
• Encoding on 8.0.4 Don Drake (22:35)
• Re: insert performance for win32 Qingqing Zhou (23:30)
• Re: insert performance for win32 Tom Lane (23:56)

2005-11-04

• Re: insert performance for win32 Qingqing Zhou (07:29)
• Searching union views not using indices Michal Taborsky (11:38)
• Re: insert performance for win32 Merlin Moncure (13:49)
• Re: insert performance for win32 Merlin Moncure (14:08)
• Re: insert performance for win32 Tom Lane (14:59)
• Re: Searching union views not using indices Richard Huxton (15:01)
• Re: Searching union views not using indices Merlin Moncure (15:07)
• Re: insert performance for win32 Merlin Moncure (15:12)
• Re: Searching union views not using indices Michael Fuhr (15:12)
• Re: insert performance for win32 Tom Lane (15:21)
• Re: insert performance for win32 Merlin Moncure (15:31)
• Re: Searching union views not using indices Tom Lane (15:31)
• Re: insert performance for win32 Tom Lane (15:36)
• Re: insert performance for win32 Merlin Moncure (15:41)
• Re: Searching union views not using indices Michal Taborsky (15:55)
• Re: insert performance for win32 Merlin Moncure (16:16)
• Re: insert performance for win32 Tom Lane (16:33)
• Re: Searching union views not using indices Tom Lane (17:53)
• Re: insert performance for win32 Merlin Moncure (17:56)
• Re: insert performance for win32 Tom Lane (18:01)
• Re: insert performance for win32 Merlin Moncure (18:07)
• Re: [PERFORM] insert performance for win32 David Fetter (18:14)
• Re: insert performance for win32 Tom Lane (18:14)
• Re: insert performance for win32 Bruce Momjian (18:15)
• Re: [HACKERS] insert performance for win32 Tom Lane (18:19)
• Re: insert performance for win32 Magnus Hagander (18:21)
• Re: [HACKERS] insert performance for win32 Bruce Momjian (18:21)
• Re: [HACKERS] insert performance for win32 Magnus Hagander (18:30)
• Re: insert performance for win32 Qingqing Zhou (18:30)
• Re: insert performance for win32 Qingqing Zhou (22:17)

2005-11-06

• Re: [HACKERS] insert performance for win32 Simon Riggs (09:00)
• 8.1 iss PostgreSQL (09:55)
• Performance PG 8.0 on dual opteron / 4GB / 3ware Raid5 / Debian?? Joost Kraaijeveld (13:30)
• Re: 8.1 iss Tom Lane (16:31)
• Re: [PERFORM] insert performance for win32 Andrew Dunstan (17:10)
• Re: Performance PG 8.0 on dual opteron / 4GB / 3ware Raid5 / Debian?? Tom Lane (17:17)
• Performance problem with pg8.0 Jeroen van Iddekinge (18:02)
• Re: 8.1 iss Greg Stark (19:24)
• Re: Performance PG 8.0 on dual opteron / 4GB / 3ware Joost Kraaijeveld (19:33)
• Re: 8.1 iss Luke Lonergan (20:19)
• Re: Performance PG 8.0 on dual opteron / 4GB / 3ware Tom Lane (20:26)

2005-11-07

• Re: Performance PG 8.0 on dual opteron / 4GB / 3ware Joost Kraaijeveld (04:25)
• Re: Performance PG 8.0 on dual opteron / 4GB / 3ware Christopher Kings-Lynne (04:37)
• Re: Performance PG 8.0 on dual opteron / 4GB / 3ware Joost Kraaijeveld (05:04)
• Re: 8.1 iss Dennis Bjorklund (05:44)
• Re: Performance PG 8.0 on dual opteron / 4GB / 3ware Joost Kraaijeveld (05:46)
• Re: Performance PG 8.0 on dual opteron / 4GB / 3ware Dave Page (08:51)
• Re: Performance PG 8.0 on dual opteron / 4GB / 3ware Joost Kraaijeveld (09:02)
• Re: Performance PG 8.0 on dual opteron / 4GB / 3ware Dave Page (09:17)
• Re: Performance problem with pg8.0 Richard Huxton (09:46)
• Re: Temporary Table Alvaro Herrera (11:07)
• Re: Performance PG 8.0 on dual opteron / 4GB / 3ware Raid5 / Debian?? Alex Turner (14:47)
• FW: Used Memory Christian Paul B. Cosinas (15:34)
• Temporary Table Christian Paul B. Cosinas (15:35)
• Re: 8.1 iss PostgreSQL (17:22)
• Re: Performance PG 8.0 on dual opteron / 4GB / 3ware Andreas Pflug (17:45)
• Index + mismatching datatypes [WAS: index on custom function; explain] Enrico Weigelt (18:07)
• Re: Index + mismatching datatypes [WAS: index on custom Neil Conway (20:45)
• Figuring out which command failed Ralph Mason (21:30)
• Re: Temporary Table Ralph Mason (21:40)

2005-11-08

• Expensive function and the optimizer Craig A. James (01:58)
• Re: Temporary Table Joshua D. Drake (02:10)
• Re: Temporary Table Christopher Kings-Lynne (02:14)
• Re: Temporary Table Christopher Kings-Lynne (02:15)
• Re: Temporary Table Jeff Frost (02:22)
• Re: Temporary Table Christopher Kings-Lynne (02:24)
• Re: Temporary Table Andrew McMillan (02:35)
• Re: Expensive function and the optimizer Tom Lane (04:12)
• Sort performance on large tables Charlie Savage (07:05)
• Re: Temporary Table Christian Paul B. Cosinas (10:04)
• Re: Temporary Table Christian Paul B. Cosinas (10:09)
• Re: Temporary Table Christian Paul B. Cosinas (10:22)
• Re: 8.1 iss Mario Weilguni (10:34)
• Re: Sort performance on large tables Richard Huxton (11:14)
• Re: Sort performance on large tables Marc Morin (13:19)
• Re: Sort performance on large tables Luke Lonergan (16:21)
• Re: Sort performance on large tables Stephan Szabo (17:38)
• Re: Sort performance on large tables Luke Lonergan (19:09)
• Re: Sort performance on large tables Stephan Szabo (20:48)
• Re: Sort performance on large tables Charlie Savage (22:06)
• Re: Sort performance on large tables Tom Lane (22:26)
• Re: Figuring out which command failed Thomas F. O'Connell (23:26)
• Re: Sort performance on large tables Charlie Savage (23:47)

2005-11-09

• Re: Sort performance on large tables Christopher Kings-Lynne (01:49)
• [No subject] William Lai (02:23)
• Re: Sort performance on large tables Charlie Savage (05:49)
• Re: Sort performance on large tables Simon Riggs (09:35)
• Improving performance on multicolumn query Jan Kesten (12:08)
• Re: Improving performance on multicolumn query Steinar H. Gunderson (12:44)
• Re: Improving performance on multicolumn query Richard Huxton (12:54)
• Re: Improving performance on multicolumn query Steinar H. Gunderson (13:00)
• Re: Improving performance on multicolumn query Christopher Kings-Lynne (13:19)
• Re: Sort performance on large tables Charlie Savage (17:13)
• Re: Improving performance on multicolumn query Jan Kesten (17:31)
• Re: Sort performance on large tables Ron Peacetree (18:26)
• Outer Join performance in PostgreSQL Ashok Agrawal (19:59)
• Some help on buffers and other performance tricks Yves Vindevogel (20:11)
• (View and SQL) VS plpgsql Eric Lauzon (20:43)
• Re: Outer Join performance in PostgreSQL Michael Alan Dorman (20:45)
• Re: Some help on buffers and other performance tricks Ron Peacetree (21:24)
• Re: Outer Join performance in PostgreSQL Stephan Szabo (22:47)
• Re: Some help on buffers and other performance tricks Alvaro Herrera (23:07)
• Re: Some help on buffers and other performance tricks Frank Wiles (23:53)

2005-11-10

• Re: Some help on buffers and other performance tricks Alvaro Herrera (00:43)
• Re: Some help on buffers and other performance tricks Frank Wiles (00:54)
• Re: Some help on buffers and other performance tricks Ron Peacetree (04:20)
• Re: (View and SQL) VS plpgsql Nörder-Tuitje (08:45)
• WAL sync behaviour Steinar H. Gunderson (13:32)
• same plan, add 1 condition, 1900x slower Mitch Skinner (13:42)
• Re: WAL sync behaviour Richard Huxton (14:14)
• Re: WAL sync behaviour Steinar H. Gunderson (14:25)
• Re: WAL sync behaviour Michael Stone (14:43)
• Re: Some help on buffers and other performance tricks Scott Marlowe (15:16)
• Re: Some help on buffers and other performance tricks Frank Wiles (15:25)
• Re: Some help on buffers and other performance tricks Merlin Moncure (15:43)
• Re: Some help on buffers and other performance tricks Scott Marlowe (15:51)
• Re: WAL sync behaviour Scott Marlowe (15:52)
• Re: WAL sync behaviour Michael Stone (16:00)
• Re: Sort performance on large tables Ron Peacetree (16:23)
• Re: Sort performance on large tables Alex Turner (16:34)
• Re: WAL sync behaviour Tom Lane (16:39)
• Re: WAL sync behaviour mark (16:53)
• Index Scan Costs versus Sort Charlie Savage (16:59)
• Re: WAL sync behaviour Scott Marlowe (17:00)
• Re: same plan, add 1 condition, 1900x slower Tom Lane (17:23)
• Re: WAL sync behaviour Tom Lane (17:44)
• Re: WAL sync behaviour Steinar H. Gunderson (17:58)
• Re: Index Scan Costs versus Sort Tom Lane (18:04)
• Re: Outer Join performance in PostgreSQL Ashok Agrawal (18:17)