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)

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: [kris@obsecurity.org: 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: [kris@obsecurity.org: 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: [kris@obsecurity.org: 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: [kris@obsecurity.org: Progress on scaling of FreeBSD on 8 CPU systems] Arjen van der Meijden 10:52
Re: [kris@obsecurity.org: Progress on scaling of FreeBSD on 8 CPU systems] Stefan Kaltenbrunner 11:44
Re: [kris@obsecurity.org: Progress on scaling of FreeBSD on 8 CPU systems] Richard Huxton 11:49
Re: [kris@obsecurity.org: 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: [kris@obsecurity.org: Progress on scaling of FreeBSD on 8 CPU systems] Stefan Kaltenbrunner 20:17
Re: Turning off Autovacuum Tomas Vondra 20:26
Re: [kris@obsecurity.org: Progress on scaling of FreeBSD on 8 CPU systems] Tom Lane 20:38
Re: [kris@obsecurity.org: 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: [kris@obsecurity.org: 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