pgsql-performance - April 2005

Discussion of PostgreSQL's performance issues. Please see Guide to reporting problems and Slow Query Questions for some tips on how to write your performance question.

Search the Archives

(enter a message-id to go directly to that message)
Advanced Search

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29

April 1, 2005

Thread Author Time
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

Thread Author Time
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

Thread Author Time
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

Thread Author Time
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

Thread Author Time
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

Thread Author Time
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

Thread Author Time
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

Thread Author Time
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

Thread Author Time
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

Thread Author Time
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

Thread Author Time
Re: Compressing WAL Bruce Momjian 01:12
Re: Functionscan estimates Josh Berkus 01:29
Re: 4 way JOIN using aliases Josh Berkus 01:41

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29