pgsql-performance since 2005-04-06 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

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
Re: Use of data within indexes	Christopher Kings-Lynne	14:04
Re: Foreign key slows down copy/insert	Christopher Kings-Lynne	14:07
Re: speed of querry?	Dawid Kuroczko	14:20
Re: Foreign key slows down copy/insert	Richard van den Berg	14:26
Re: Foreign key slows down copy/insert	Christopher Kings-Lynne	14:35
Re: How to improve db performance with $7K?	Tom Lane	14:44
Re: Foreign key slows down copy/insert	Stephan Szabo	14:45
Re: speed of querry?	Joel Fradkin	14:45
Re: How to improve db performance with $7K?	Rosser Schwarz	14:48
Intel SRCS16 SATA raid?	Greg Stark	14:54
Re: How to improve db performance with $7K?	Mohan, Ross	15:02
Re: Foreign key slows down copy/insert	Tom Lane	15:05
Re: Foreign key slows down copy/insert	Richard van den Berg	15:08
Re: Intel SRCS16 SATA raid?	Mohan, Ross	15:08
Re: Foreign key slows down copy/insert	Christopher Kings-Lynne	15:13
Re: Foreign key slows down copy/insert	Richard van den Berg	15:25

Browse Archives

Prev | Next