pgsql-performance since 2005-04-01 02:01

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