pgsql-performance - March 2007

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

March 1, 2007

Thread	Author	Time
Re: Dead Space Map version 2	Takayuki Tsunakawa	00:45
Re: Two hard drives --- what to do with them?	Bruno Wolff III	03:28
Re: Two hard drives --- what to do with them?	Bruno Wolff III	03:31
Re: Two hard drives --- what to do with them?	Bruno Wolff III	03:35
increasing database connections	Shiva Sarna	05:18
Re: increasing database connections	Jonah H. Harris	05:49
Re: increasing database connections	Joshua D. Drake	06:18
Re: increasing database connections	Mark Kirkwood	07:07
Re: increasing database connections	Magnus Hagander	08:58
Re: performances with Pentium D	Ben Trewern	11:00
Re: increasing database connections	Florian Weimer	11:04
Re: increasing database connections	Ron	12:20
Performance Query	Abu Mushayeed	14:13
Identical Queries	Rob Schall	15:43
Re: Dead Space Map version 2	Jim C. Nasby	15:45
Re: increasing database connections	Joshua D. Drake	15:47
Re: Identical Queries	Stephan Szabo	19:39
Re: stats collector process high CPU utilization	Tom Lane	20:12
strange performance regression between 7.4 and 8.1	Alex Deucher	20:40
Re: stats collector process high CPU utilization	Benjamin Minshall	20:41
strange performance regression between 7.4 and 8.1	Alex Deucher	20:44
Re: strange performance regression between 7.4 and 8.1	Joshua D. Drake	20:50
Re: Identical Queries	Rob Schall	20:55
Re: strange performance regression between 7.4 and 8.1	Jeff Frost	20:56
Re: strange performance regression between 7.4 and 8.1	Alex Deucher	21:06
Re: Identical Queries	Chad Wagner	21:09
Re: strange performance regression between 7.4 and 8.1	Alex Deucher	21:11
Re: strange performance regression between 7.4 and 8.1	Jeff Frost	21:34
Re: strange performance regression between 7.4 and 8.1	Jeff Frost	21:36
Re: strange performance regression between 7.4 and 8.1	Alex Deucher	21:50
Re: stats collector process high CPU utilization	Merlin Moncure	21:58
Re: strange performance regression between 7.4 and 8.1	Jeff Frost	22:01
Re: strange performance regression between 7.4 and 8.1	Alex Deucher	22:12
Re: Identical Queries	Stephan Szabo	22:23
Re: performances with Pentium D	hatman	22:28
Re: Identical Queries	Craig A. James	22:41
Re: stats collector process high CPU utilization	Tom Lane	22:44
Re: strange performance regression between 7.4 and 8.1	Alex Deucher	23:11

March 2, 2007

Thread	Author	Time
Re: strange performance regression between 7.4 and 8.1	Jeff Frost	00:21
Re: strange performance regression between 7.4 and 8.1	Jeff Frost	00:36
Re: strange performance regression between 7.4 and 8.1	Ron	01:01
Re: stats collector process high CPU utilization	Merlin Moncure	01:30
Re: stats collector process high CPU utilization	Tom Lane	01:35
Re: strange performance regression between 7.4 and 8.1	Alex Deucher	01:44
Re: strange performance regression between 7.4 and 8.1	Joshua D. Drake	01:46
Re: strange performance regression between 7.4 and 8.1	Alex Deucher	01:47
Re: strange performance regression between 7.4 and 8.1	Jeff Frost	01:56
Re: strange performance regression between 7.4 and 8.1	Alex Deucher	02:06
Re: strange performance regression between 7.4 and 8.1	Joshua D. Drake	02:21
Re: strange performance regression between 7.4 and 8.1	Alex Deucher	03:16
Array indexes, GIN?	Adam L Beberg	03:59
Improving query performance	David Leangen	04:00
Re: Array indexes, GIN?	Josh Berkus	05:47
Re: Improving query performance	Tom Lane	05:48
Re: Array indexes, GIN?	Oleg Bartunov	06:45
Hibernate left join	hytech.qa	06:46
Re: Array indexes, GIN?	Adam L Beberg	07:50
Re: strange performance regression between 7.4 and 8.1	Florian Weimer	08:51
Re: Improving query performance	David Leangen	09:06
Re: stats collector process high CPU utilization	Magnus Hagander	10:32
Re: strange performance regression between 7.4 and 8.1	Carlos Moreno	13:56
Re: [[email protected]: Progress on scaling of FreeBSD on 8 CPU systems]	Alvaro Herrera	15:01
Re: strange performance regression between 7.4 and 8.1	Alex Deucher	15:16
Re: strange performance regression between 7.4 and 8.1	Ron	15:21
Re: strange performance regression between 7.4 and 8.1	Alex Deucher	15:28
Re: strange performance regression between 7.4 and 8.1	Ron	15:48
Re: [[email protected]: Progress on scaling of FreeBSD on 8 CPU systems]	Arjen van der Meijden	15:49
Re: strange performance regression between 7.4 and 8.1	Alex Deucher	16:03
Re: strange performance regression between 7.4 and 8.1	Tom Lane	16:10
Re: strange performance regression between 7.4 and 8.1	Alex Deucher	16:14
Re: [[email protected]: Progress on scaling of FreeBSD on 8 CPU systems]	Scott Marlowe	16:35
Re: strange performance regression between 7.4 and 8.1	Scott Marlowe	16:50
Re: strange performance regression between 7.4 and 8.1	Anton Rommerskirchen	17:45
Re: strange performance regression between 7.4 and 8.1	Ron	17:59
Re: strange performance regression between 7.4 and 8.1	Alvaro Herrera	19:33
Re: strange performance regression between 7.4 and 8.1	Alex Deucher	19:43
Re: Array indexes, GIN?	Jeff Davis	19:50
Re: strange performance regression between 7.4 and 8.1	Ron	20:28
Re: strange performance regression between 7.4 and 8.1	Alex Deucher	21:20
Re: strange performance regression between 7.4 and 8.1	Guido Neitzer	21:34
Re: strange performance regression between 7.4 and 8.1	Jeff Frost	22:59
Re: stats collector process high CPU utilization	Bruce Momjian	23:06
Re: stats collector process high CPU utilization	Joshua D. Drake	23:23
Re: strange performance regression between 7.4 and 8.1	Alex Deucher	23:31

March 3, 2007

Thread	Author	Time
Re: Performance Query	Josh Berkus	00:52
Re: Performance Query	Tom Lane	02:12
Re: Upgraded to 8.2.3 --- still having performance issues	Dennis Bjorklund	06:41
Re: Opinions on Raid	Arjen van der Meijden	11:30

March 5, 2007

Thread	Author	Time
Automatic adjustment of bgwriter_lru_maxpages (was: Dead Space Map version 2)	ITAGAKI Takahiro	04:10
Automatic adjustment of bgwriter_lru_maxpages (was: Dead Space Map version 2) 📎	ITAGAKI Takahiro	04:11
Re: Automatic adjustment of bgwriter_lru_maxpages 📎	ITAGAKI Takahiro	08:22
Aggressive freezing in lazy-vacuum 📎	ITAGAKI Takahiro	10:14
Re: [[email protected]: Progress on scaling of FreeBSD on 8 CPU systems]	Arjen van der Meijden	10:52
Re: [[email protected]: Progress on scaling of FreeBSD on 8 CPU systems]	Stefan Kaltenbrunner	11:44
Re: [[email protected]: Progress on scaling of FreeBSD on 8 CPU systems]	Richard Huxton	11:49
Re: [[email protected]: Progress on scaling of FreeBSD on 8 CPU systems]	Arjen van der Meijden	11:51
PostgreSQL 8.2.3 VACUUM Timings/Performance	Bruce McAlister	12:33
Re: Having performance problems with TSearch2	Ares	12:59
Re: PostgreSQL 8.2.3 VACUUM Timings/Performance	Heikki Linnakangas	13:20
Re: which Xeon processors don't have the context switching problem	Geoffrey	13:23
Re: PostgreSQL 8.2.3 VACUUM Timings/Performance	Bruce McAlister	14:06
Re: PostgreSQL 8.2.3 VACUUM Timings/Performance	Heikki Linnakangas	14:44
Estimate the size of the SQL file generated by pg_dump utility	Ravindran G-TLS,Chennai.	14:55
Re: PostgreSQL 8.2.3 VACUUM Timings/Performance	Aidan Van Dyk	15:18
Re: Estimate the size of the SQL file generated by pg_dump utility	A. Kretschmer	15:34
Turning off Autovacuum	Steven Flatt	16:00
Re: Aggressive freezing in lazy-vacuum	Tom Lane	16:02
Re: PostgreSQL 8.2.3 VACUUM Timings/Performance	Tom Lane	16:11
Re: PostgreSQL 8.2.3 VACUUM Timings/Performance	Heikki Linnakangas	16:25
Re: Aggressive freezing in lazy-vacuum	Florian G. Pflug	19:26
Re: [PATCHES] Aggressive freezing in lazy-vacuum	Heikki Linnakangas	19:30
Re: [PATCHES] Aggressive freezing in lazy-vacuum	Florian G. Pflug	19:41
Re: [[email protected]: Progress on scaling of FreeBSD on 8 CPU systems]	Stefan Kaltenbrunner	20:17
Re: Turning off Autovacuum	Tomas Vondra	20:26
Re: [[email protected]: Progress on scaling of FreeBSD on 8 CPU systems]	Tom Lane	20:38
Re: [[email protected]: Progress on scaling of FreeBSD on 8 CPU systems]	Arjen van der Meijden	20:50
Re: Turning off Autovacuum	Steven Flatt	21:47
[No subject]	Jeff Cole	22:05

March 6, 2007

Thread	Author	Time
Re: Estimate the size of the SQL file generated by pg_dump utility	Bruce Momjian	00:19
query slows down after vacuum analyze	Jeff Cole	01:27
Re: Opinions on Raid	Steinar H. Gunderson	01:31
Re:	Tom Lane	01:54
Re: strange performance regression between 7.4 and 8.1	Guido Neitzer	02:14
Re: Estimate the size of the SQL file generated by pg_dump utility	Bricklen Anderson	02:19
Re: Estimate the size of the SQL file generated by pg_dump utility	Bruce Momjian	02:22
Re: strange performance regression between 7.4 and 8.1	Alex Deucher	02:56
Re: strange performance regression between 7.4 and 8.1	Guido Neitzer	02:58
Re: query slows down after vacuum analyze	ismo.tuononen	05:56
Re: Insert performance	Richard Huxton	07:34
Re: Hibernate left join	Richard Huxton	07:37
Re: Insert performance	joël Winteregg	07:53
Re: Insert performance	Richard Huxton	08:08
Re: Insert performance	joël Winteregg	09:19
Re: Insert performance	Richard Huxton	09:43
Re: Aggressive freezing in lazy-vacuum	ITAGAKI Takahiro	10:03
Re: Aggressive freezing in lazy-vacuum	Gregory Stark	11:12
help	lissette	11:36
Re: Insert performance	Andreas Kostyrka	12:23
Re: Insert performance	Richard Huxton	12:24
Re: Insert performance	Andreas Kostyrka	12:49
Re: Estimate the size of the SQL file generated by pg_dump utility	Bill Moran	13:44
Re: Aggressive freezing in lazy-vacuum	Tom Lane	15:02
Re: Estimate the size of the SQL file generated by pg_dump utility	Craig A. James	15:07
Re: Estimate the size of the SQL file generated by pg_dump utility	Claus Guttesen	15:09
Re: strange performance regression between 7.4 and 8.1	Alex Deucher	15:25
Re: Estimate the size of the SQL file generated by pg_dump utility	Tom Lane	15:31
Re: Insert performance	hatman	15:38
Re:	Jeff Cole	15:40
Re: Insert performance	hatman	15:46
Re: Insert performance	Carlos Moreno	15:55
Re: Insert performance	Csaba Nagy	16:02
Re:	Tom Lane	16:40
Re: strange performance regression between 7.4 and 8.1	Ron	16:58
Re: Estimate the size of the SQL file generated by pg_dump utility	Richard Troy	17:05
Automated test-suite for Postgres	Neelam Goyal	17:40
Re: Insert performance	Carlos Moreno	17:54
Re: strange performance regression between 7.4 and 8.1	Alex Deucher	18:11
Re: Automated test-suite for Postgres	Heikki Linnakangas	19:03
Re:	Jeff Cole	21:47
Any advantage to integer vs stored date w. timestamp	Zoolin Lin	21:49
compact flash disks?	James Mansion	22:18
problem with wrong query planning and ineffective statistics	Paolo Negri	23:25

March 7, 2007

Thread	Author	Time
Re: Aggressive freezing in lazy-vacuum	ITAGAKI Takahiro	01:56
Re: compact flash disks?	Merlin Moncure	02:12
Re: Aggressive freezing in lazy-vacuum	ITAGAKI Takahiro	02:18
Re: Aggressive freezing in lazy-vacuum	Tom Lane	04:34
When the Record Got Updated.	Gauri Kanekar	06:43
Re: When the Record Got Updated.	A. Kretschmer	07:30
Re: Any advantage to integer vs stored date w. timestamp	Richard Huxton	09:05
Re: compact flash disks?	Florian Weimer	09:34
Re: Any advantage to integer vs stored date w. timestamp	Zoolin Lin	14:50
Re: Any advantage to integer vs stored date w. timestamp	Richard Huxton	15:04
Re: compact flash disks?	Ron	15:14
Re: compact flash disks?	Carlos Moreno	15:48
Re: compact flash disks?	Csaba Nagy	15:49
Re: compact flash disks?	cedric	16:12
Re:	Tom Lane	16:37
Re: [[email protected]: Progress on scaling of FreeBSD on 8 CPU systems]	Stefan Kaltenbrunner	18:48
Re: Any advantage to integer vs stored date w. timestamp	Zoolin Lin	21:45

March 8, 2007

Thread	Author	Time
Re: Any advantage to integer vs stored date w. timestamp	Shane Ambler	02:49
Re: compact flash disks?	James Mansion	06:24
Re: compact flash disks?	Magnus Hagander	08:48
configuring new server / many slow disks?	Axel Rau	11:30
Re: strange performance regression between 7.4 and 8.1	Rodrigo Madera	12:23
Re: compact flash disks?	Merlin Moncure	14:11
Re:	Jeff Cole	15:30
function performance vs in-line sql	Schwarz, Karl	16:24
Re: function performance vs in-line sql	Richard Huxton	17:49
Re: function performance vs in-line sql	Heikki Linnakangas	17:52
Re: strange performance regression between 7.4 and 8.1	Craig A. James	18:34
Re: compact flash disks?	Ron	18:40
Re: function performance vs in-line sql	Schwarz, Karl	18:45
Re: strange performance regression between 7.4 and 8.1	Ron	18:59
Re: strange performance regression between 7.4 and 8.1	Carlos Moreno	19:34
Re: strange performance regression between 7.4 and 8.1	Carlos Moreno	19:38
Re: compact flash disks?	Merlin Moncure	20:24
Re: strange performance regression between 7.4 and 8.1	Craig A. James	21:07
Question about PGSQL functions	Steve	22:36
Re: Question about PGSQL functions	Heikki Linnakangas	23:17

March 9, 2007

Thread	Author	Time
Re: help	Gavin Sherry	00:46

Browse Archives

Prev | Next