Peripheral Links

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

pgsql-performance - April 2005

April 1, 2005

• Follow-Up: How to improve db performance with $7K? Steve Poe (02:01)
• Re: How to speed up word count in tsearch2? Yudie Pg (04:03)
• Re: Follow-Up: How to improve db performance with $7K? Thomas F.O'Connell (08:09)
• date - range H.J. Sanders (10:05)
• Re: How to speed up word count in tsearch2? Mike Rylander (12:17)
• Tuning PostgreSQL Mindaugas Riauba (14:54)
• enable_XXX options Peterson, Bjorn (16:04)
• Triggers with FOR EACH STATEMENT Keith Worthington (16:20)
• Re: enable_XXX options Tom Lane (16:36)
• Re: enable_XXX options Peterson, Bjorn (16:50)
• Re: enable_XXX options Tom Lane (17:27)
• Sustained inserts per sec ... ? Marc G. Fournier (18:06)
• Re: Sustained inserts per sec ... ? Mike Nolan (19:27)
• Re: Sustained inserts per sec ... ? Christopher Petrilli (19:38)
• Re: Sustained inserts per sec ... ? Tom Lane (20:42)
• Re: Sustained inserts per sec ... ? Christopher Petrilli (20:46)
• Re: Sustained inserts per sec ... ? Joshua D. Drake (20:53)
• Re: Sustained inserts per sec ... ? Tom Lane (20:58)
• Re: Sustained inserts per sec ... ? Christopher Petrilli (20:59)
• Re: Sustained inserts per sec ... ? Tom Lane (21:03)
• Re: Sustained inserts per sec ... ? Alex Turner (21:17)
• Re: Sustained inserts per sec ... ? Alex Turner (21:20)
• Re: Follow-Up: How to improve db performance with $7K? Vivek Khera (21:23)
• Re: Sustained inserts per sec ... ? Tom Lane (22:03)
• Re: Sustained inserts per sec ... ? Mike Nolan (22:36)
• Re: date - range Michael Fuhr (23:24)

April 2, 2005

• Re: date - range Mischa (05:59)
• Re: date - range Mischa (06:25)
• Re: date - range Michael Fuhr (07:01)
• Re: date - range Bruno Wolff III (14:14)
• Re: Follow-Up: How to improve db performance with $7K? Will LaShell (16:21)

April 3, 2005

• Re: Query Optimizer Failure / Possible Bug PFC (08:01)
• Re: Delete query takes exorbitant amount of time Bruno Wolff III (12:18)
• Re: coalesce alternative Bruno Wolff III (13:04)

April 4, 2005

• Correcting Hash Join Estimates mark.lubratt (05:08)
• Re: Correcting Hash Join Estimates Tom Lane (05:54)
• Re: Correcting Hash Join Estimates Mark Lubratt (06:15)
• Postgresql vs SQLserver for this application ? bsimon (08:02)
• 8.0.1 much slower than 7.4.2? anon permutation (10:21)
• 8.0.1 performance question. alvin.yk (10:32)
• Re: How to improve db performance with $7K? Alex Turner (13:43)
• Re: Sustained inserts per sec ... ? Christopher Petrilli (13:48)
• Re: How to improve db performance with $7K? Steve Poe (14:39)
• Re: Sustained inserts per sec ... ? Alex Turner (14:47)
• Re: Query Optimizer Failure / Possible Bug Hannes Dorbath (15:18)
• Re: 8.0.1 performance question. Tom Lane (15:49)
• Re: Sustained inserts per sec ... ? Tom Lane (15:52)
• 8.0.1 performance question. alvin.yk (16:00)
• Re: Sustained inserts per sec ... ? Christopher Petrilli (16:09)
• Re: 8.0.1 performance question. Kris Jurka (16:15)
• Re: Sustained inserts per sec ... ? Tom Lane (16:23)
• Re: 8.0.1 performance question. alvin.yk (16:44)
• Re: Sustained inserts per sec ... ? Christopher Petrilli (16:51)
• Re: 8.0.1 performance question. Kris Jurka (17:05)
• Re: How to improve db performance with $7K? Alex Turner (19:12)
• Re: How to improve db performance with $7K? Vivek Khera (19:23)
• Re: How to improve db performance with $7K? Alex Turner (19:33)
• Re: Sustained inserts per sec ... ? Simon Riggs (19:46)
• Re: Sustained inserts per sec ... ? Christopher Petrilli (19:56)
• Re: Sustained inserts per sec ... ? Simon Riggs (20:11)
• Re: Sustained inserts per sec ... ? Christopher Petrilli (20:18)
• Re: Sustained inserts per sec ... ? PFC (20:53)
• Re: Sustained inserts per sec ... ? Christopher Petrilli (20:56)
• Re: Sustained inserts per sec ... ? Simon Riggs (20:58)
• Re: Sustained inserts per sec ... ? Christopher Petrilli (21:03)
• Re: Sustained inserts per sec ... ? Simon Riggs (22:44)
• Re: Sustained inserts per sec ... ? Mike Rylander (23:28)
• Bulk COPY end of copy delimiter Steven Rosenstein (23:40)

April 5, 2005

• Re: Bulk COPY end of copy delimiter Gavin Sherry (00:00)
• Re: Sustained inserts per sec ... ? Christopher Petrilli (01:31)
• Re: Sustained inserts per sec ... ? Tom Lane (02:36)
• Re: Sustained inserts per sec ... ? Christopher Petrilli (02:54)
• Re: Bulk COPY end of copy delimiter Steven Rosenstein (03:05)
• Re: Sustained inserts per sec ... ? Tom Lane (03:35)
• Re: Sustained inserts per sec ... ? Greg Stark (03:45)
• Re: Sustained inserts per sec ... ? Christopher Petrilli (03:55)
• Re: Sustained inserts per sec ... ? Tom Lane (03:57)
• Compressing WAL Jim C. Nasby (04:04)
• Re: Sustained inserts per sec ... ? Christopher Petrilli (04:16)
• Re: Sustained inserts per sec ... ? Jim C. Nasby (05:03)
• Re: Sustained inserts per sec ... ? Christopher Petrilli (14:27)
• Re: Sustained inserts per sec ... ? Simon Riggs (19:48)
• Re: Sustained inserts per sec ... ? Christopher Petrilli (20:05)
• Re: Sustained inserts per sec ... ? Christopher Petrilli (22:55)

April 6, 2005

• Re: Follow-Up: How to improve db performance with $7K? Kevin Brown (04:44)
• RE : RE: Postgresql vs SQLserver for this application ? bsimon (07:17)
• Re: How to improve db performance with $7K? William Yu (07:30)
• Re: Sustained inserts per sec ... ? Simon Riggs (08:09)
• Re: Sustained inserts per sec ... ? Simon Riggs (08:14)
• Re: Follow-Up: How to improve db performance with $7K? Steinar H. Gunderson (11:28)
• Is Indexed View Supported in psql 7.1.3?? S.Thanga Prakash (12:31)
• Re: Follow-Up: How to improve db performance with $7K? PFC (13:26)
• Re: Follow-Up: How to improve db performance with $7K? Steinar H. Gunderson (13:33)
• Re: How to improve db performance with $7K? Alex Turner (15:35)
• Re: RE : RE: Postgresql vs SQLserver for this application ? Alex Turner (15:37)
• Re: RE : RE: Postgresql vs SQLserver for this application ? Mohan, Ross (16:12)
• Re: RE : RE: Postgresql vs SQLserver for this application Steve Wampler (16:38)
• Re: RE : RE: Postgresql vs SQLserver for this Rod Taylor (16:40)
• Re: RE : RE: Postgresql vs SQLserver for this application ? Mohan, Ross (16:43)
• Re: RE : RE: Postgresql vs SQLserver for thisapplication ? Mohan, Ross (16:47)
• Plan for relatively simple query seems to be very inefficient Arjen van der Meijden (16:52)
• Re: Plan for relatively simple query seems to be very inefficient Steve Atkins (17:04)
• Réf. : Re: RE : RE: Postgresql vs SQLserver for this bsimon (17:08)
• Re: Réf. : Re: RE : RE: Postgresql Rod Taylor (17:18)
• Re: Plan for relatively simple query seems to be very inefficient Arjen van der Meijden (17:40)
• Re: Plan for relatively simple query seems to be very inefficient Tom Lane (17:42)
• Re: Réf Steinar H. Gunderson (17:42)
• Re: Plan for relatively simple query seems to be very inefficient Dave Held (17:45)
• Re: Plan for relatively simple query seems to be very inefficient Arjen van der Meijden (18:00)
• Re: Plan for relatively simple query seems to be very inefficient Tom Lane (18:09)
• Re: RE : RE: Postgresql vs SQLserver for thisapplication ? Alex Turner (18:18)
• Re: Réf Rod Taylor (18:23)
• Re: Plan for relatively simple query seems to be very inefficient Mischa (18:35)
• Re: Réf Alex Turner (18:40)
• COPY Hacks (WAS: RE: Postgresql vs SQLserver for this application ?) Mischa (18:46)
• Re: Réf Rod Taylor (19:01)
• Re: Plan for relatively simple query seems to be very inefficient Tom Lane (19:54)
• Re: How to improve db performance with $7K? William Yu (20:01)
• Re: COPY Hacks (WAS: RE: Postgresql vs SQLserver for this application ?) Dave Held (20:06)
• Re: COPY Hacks (WAS: RE: Postgresql vs SQLserver for this application ?) Tom Lane (20:27)
• Re: Plan for relatively simple query seems to be very inefficient Tom Lane (20:51)
• Never ending delete story Jarosław Pałka (21:05)
• Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient) Tom Lane (22:09)
• Re: How to improve db performance with $7K? Alex Turner (22:12)
• Re: [HACKERS] Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient) Jim C. Nasby (22:25)
• Re: [HACKERS] Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient) Tom Lane (22:35)
• Re: How to improve db performance with $7K? Jim C. Nasby (22:41)
• Re: [HACKERS] Recognizing range constraints (was Re: Plan John A Meinel (22:54)
• Re: [HACKERS] Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient) Tom Lane (23:06)
• Tweaking a C Function I wrote Adam Palmblad (23:22)
• Re: Recognizing range constraints (was Re: Plan for Simon Riggs (23:24)
• Re: Tweaking a C Function I wrote Neil Conway (23:42)

April 7, 2005

• Re: How to improve db performance with $7K? Alex Turner (00:32)
• Re: How to improve db performance with $7K? Alex Turner (01:12)
• Re: How to improve db performance with $7K? Alex Turner (01:23)
• Re: COPY Hacks (WAS: RE: Postgresql vs SQLserver for this Christopher Kings-Lynne (02:04)
• Re: How to improve db performance with $7K? Greg Stark (03:00)
• Re: How to improve db performance with $7K? Alex Turner (03:06)
• Re: Tweaking a C Function I wrote Tom Lane (04:03)
• Re: How to improve db performance with $7K? Tom Lane (04:14)
• Re: Follow-Up: How to improve db performance with $7K? Thomas F.O'Connell (04:40)
• Re: How to improve db performance with $7K? Douglas J. Trainor (04:58)
• help on explain analyse in psql 7.1.3 (linux) S.Thanga Prakash (07:21)
• help on explain analyse S.Thanga Prakash (07:21)
• help on time calculation S.Thanga Prakash (07:44)
• Re: help on explain analyse in psql 7.1.3 (linux) Christopher Kings-Lynne (07:49)
• Re: help on time calculation Christopher Kings-Lynne (08:18)
• Re: help on explain analyse in psql 7.1.3 (linux) S.Thanga Prakash (08:45)
• Re: How to improve db performance with $7K? Douglas J. Trainor (09:55)
• Re: COPY Hacks (WAS: RE: Postgresql vs SQLserver for this application ?) Harald Fuchs (12:21)
• 4 way JOIN using aliases Keith Worthington (14:17)
• Re: Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient) Tom Lane (14:20)
• Re: Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient) Bruno Wolff III (14:31)
• Any way to speed this up? Joel Fradkin (15:13)
• Building postmaster with Profiling Support WAS "Tweaking a C Function I wrote" Mohan, Ross (15:21)
• Re: Any way to speed this up? Keith Worthington (15:27)
• Re: Any way to speed this up? John Arbash Meinel (15:36)
• Re: How to improve db performance with $7K? Richard_D_Levine (15:37)
• Re: help on explain analyse in psql 7.1.3 (linux) Tom Lane (15:43)
• Re: How to improve db performance with $7K? Alex Turner (15:46)
• Re: Building postmaster with Profiling Support WAS "Tweaking a C Function I wrote" Tom Lane (15:57)
• Re: Any way to speed this up? Tom Lane (16:04)
• Re: Any way to speed this up? Tom Lane (16:13)
• Re: How to improve db performance with $7K? Richard_D_Levine (16:28)
• Re: Any way to speed this up? Joel Fradkin (16:33)
• Re: Any way to speed this up? Tom Lane (16:42)
• Re: Any way to speed this up? John Arbash Meinel (16:43)
• Re: Any way to speed this up? Joel Fradkin (17:14)
• Re: Any way to speed this up? John Arbash Meinel (17:22)
• Re: Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient) Mischa (21:26)
• Re: [HACKERS] Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient) Jim C. Nasby (21:40)
• Re: Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient) Tom Lane (23:58)

April 8, 2005

• Re: Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient) a3a18850 (00:30)
• Re: help on explain analyse in psql 7.1.3 (linux) Greg Sabino Mullane (01:30)
• Re: COPY Hacks (WAS: RE: Postgresql vs SQLserver for this application ?) Greg Sabino Mullane (02:03)
• Re: multi-line copy (was: Re: COPY Hacks) Mischa Sandberg (04:53)
• Re: Compressing WAL Qingqing Zhou (05:36)
• DATA directory on network attached storage Jeff Frost (17:01)
• Re: [sfpug] DATA directory on network attached storage Josh Berkus (17:05)
• Re: DATA directory on network attached storage Jeff Frost (17:11)
• Re: [sfpug] DATA directory on network attached storage Aditya (19:21)
• Functionscan estimates Josh Berkus (22:15)
• Re: Functionscan estimates Michael Fuhr (22:38)
• Re: Functionscan estimates Alvaro Herrera (22:45)
• Re: Functionscan estimates Josh Berkus (23:04)
• Re: Functionscan estimates Alvaro Herrera (23:57)

April 9, 2005

• Re: Functionscan estimates Tom Lane (04:00)
• Re: Functionscan estimates PFC (11:25)
• Re: Functionscan estimates PFC (11:29)
• Re: Postgresql vs SQLserver for this application ? BarryS (13:19)
• Re: Any way to speed this up? Jim C. Nasby (15:17)
• Re: Functionscan estimates Jim C. Nasby (15:22)
• Re: Functionscan estimates Tom Lane (15:45)

April 10, 2005

• performance - triggers, row existence etc. tv (04:36)
• Re: Functionscan estimates Neil Conway (05:25)
• Re: Functionscan estimates Neil Conway (05:44)
• Re: performance - triggers, row existence etc. John A Meinel (13:09)

April 11, 2005

• Re: Compressing WAL Bruce Momjian (01:12)
• Re: Functionscan estimates Josh Berkus (01:29)
• Re: 4 way JOIN using aliases Josh Berkus (01:41)