pgsql-performance since 2005-04-05 00:00

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 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
Re: 4 way JOIN using aliases Neil Conway 01:55
Server crashing Don Drake 03:16
Re: help on explain analyse John A Meinel 04:57
Re: Is Indexed View Supported in psql 7.1.3?? Christopher Kings-Lynne 05:03
Re: Is Indexed View Supported in psql 7.1.3?? Steve Poe 05:35
Re: Server crashing Tom Lane 06:29
Re: Never ending delete story Tom Lane 06:40
Re: performance - triggers, row existence etc. Tambet Matiisen 12:59
Re: Server crashing Don Drake 14:24
Re: Server crashing Gourish Singbal 15:15
Is there somthing I need to do on my production server? Joel Fradkin 17:14
Re: [sfpug] DATA directory on network attached storage Joe Conway 17:59
Re: [sfpug] DATA directory on network attached storage Aditya 18:20
Re: Is there somthing I need to do on my production server? Joel Fradkin 18:29
Re: [sfpug] DATA directory on network attached storage Joe Conway 20:17

April 12, 2005

Thread Author Time
Re: 4 way JOIN using aliases Keith Worthington 00:43
profiling postgresql queries? hubert lubaczewski 10:46
Re: 4 way JOIN using aliases Dave Held 13:41
Re: profiling postgresql queries? Tom Lane 14:10
Slow update Bendik R.Johansen 14:12
Re: profiling postgresql queries? Alex Turner 14:18
Re: Slow update Tom Lane 14:35
Re: profiling postgresql queries? Michael Fuhr 14:43
Re: profiling postgresql queries? hubert lubaczewski 14:45
Re: profiling postgresql queries? hubert lubaczewski 15:00
Re: Slow update Bendik R.Johansen 15:03
Re: Slow update Tom Lane 15:16
Re: Slow update Bendik R.Johansen 15:37
Re: Slow update Tom Lane 15:40
performance hit for replication Matthew Nuzum 16:25
Re: performance hit for replication Joshua D. Drake 16:37
Re: performance hit for replication Darcy Buskermolen 16:54
Re: performance hit for replication Matthew Nuzum 16:55
Re: performance hit for replication Joshua D. Drake 17:13
Re: 4 way JOIN using aliases Keith Worthington 18:14
Re: 4 way JOIN using aliases Dave Held 18:22
Re: performance hit for replication Chris Browne 20:25

April 13, 2005

Thread Author Time
Many connections lingering Slavisa Garic 02:29
Re: Many connections lingering Tom Lane 02:51
Re: [PERFORM] Many connections lingering Greg Stark 03:27
Re: [PERFORM] Many connections lingering Tom Lane 05:01
Re: [PERFORM] Many connections lingering Slavisa Garic 05:09
Re: performance hit for replication Dave Page 08:02
Re: [PERFORM] Many connections lingering John DeSoi 12:31
speed of querry? Joel Fradkin 14:41
Foreign keys and partial indexes Nichlas Löfdahl 15:45
Re: Foreign keys and partial indexes Tom Lane 16:05
Re: [PERFORM] Many connections lingering Mark Lewis 16:42
Re: speed of querry? Richard Huxton 17:30
Re: [NOVICE] Many connections lingering Richard Huxton 17:36
PLM pulling from CVS nightly for testing in STP Mark Wong 18:11
Re: speed of querry? Joel Fradkin 18:29
Re: PLM pulling from CVS nightly for testing in STP Josh Berkus 18:35
Re: PLM pulling from CVS nightly for testing in STP Mark Wong 20:41
Problem with slow query (caused by improper nestloop?) Tom Mack 21:06
Strange serialization problem Mischa Sandberg 22:16
Re: Compressing WAL Jim C. Nasby 22:27
Re: Compressing WAL Simon Riggs 23:33

April 14, 2005

Thread Author Time
Re: [NOVICE] Many connections lingering Slavisa Garic 01:11
Re: [PERFORM] Many connections lingering Slavisa Garic 01:15
Re: How to improve db performance with $7K? Kevin Brown 05:56
Re: How to improve db performance with $7K? Greg Stark 06:37
Re: speed of querry? Tom Lane 06:47
Re: How to improve db performance with $7K? Kevin Brown 08:36
Use of data within indexes Jacques Caron 09:45
Foreign key slows down copy/insert Richard van den Berg 11:59
Foreign key slows down copy/insert Richard van den Berg 12:21
Re: speed of querry? Joel Fradkin 13:52

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