Peripheral Links

• Home
• About
• Download
• Documentation
• Community
• Developers
• Support
• Your account

pgsql-performance - March 2007

March 1, 2007

• 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

• 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 FreeBSDon 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

• 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

• 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

• 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

• 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

• 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

• Re: help Gavin Sherry (00:46)