Skip site navigation (1)
Skip section navigation (2)
pgsql-performance 2008-04 Chronological Index (2/3)
Last updated: Wed Jan 18 04:16:04 2012
475 messages
20 April 2008
Vacuum settings dforums (15:53)
Re: Group by more efficient than distinct? Francisco Reyes (15:15)
Re: Group by more efficient than distinct? Francisco Reyes (15:12)
Re: Background writer underemphasized ... James Mansion (14:37)
19 April 2008
Re: Oddly slow queries Christopher Browne (17:56)
Re: Oddly slow queries Scott Marlowe (17:04)
Re: Exact index overhead Scott Marlowe (16:48)
Re: Background writer underemphasized ... James Mansion (15:01)
Re: Background writer underemphasized ... Greg Smith (09:23)
Re: 3-days-long vacuum of 20GB table Heikki Linnakangas (05:57)
18 April 2008
full_page_write and also compressed logging James Mansion (19:51)
Re: Message queue table.. Tom Lane (19:27)
Re: Message queue table.. Jesper Krogh (19:23)
Re: 3-days-long vacuum of 20GB table Tom Lane (19:09)
Re: 3-days-long vacuum of 20GB table Alvaro Herrera (18:24)
Re: Message queue table.. Craig Ringer (18:19)
Re: 3-days-long vacuum of 20GB table Jeffrey Baker (17:54)
Message queue table.. Jesper Krogh (17:50)
Re: 3-days-long vacuum of 20GB table Jeffrey Baker (17:35)
Re: 3-days-long vacuum of 20GB table Jeffrey Baker (17:32)
Re: Strange behavior: pgbench and new Linux kernels Greg Smith (17:19)
Re: 3-days-long vacuum of 20GB table Tom Lane (17:04)
3-days-long vacuum of 20GB table Jeffrey Baker (16:35)
Re: Performance increase with elevator=deadline Enrico Sirola (14:38)
Re: Strange behavior: pgbench and new Linux kernels Matthew (11:01)
Re: Group by more efficient than distinct? PFC (10:30)
Re: Group by more efficient than distinct? Gregory Stark (09:36)
Re: Group by more efficient than distinct? Thomas Pundt (08:54)
Re: Strange behavior: pgbench and new Linux kernels Greg Smith (06:47)
Re: Strange behavior: pgbench and new Linux kernels Tom Lane (05:31)
Re: SQL Function Slowness, 8.3.0 Craig Ringer (04:22)
Re: SQL Function Slowness, 8.3.0 Tom Lane (04:01)
Group by more efficient than distinct? Francisco Reyes (03:55)
Re: SQL Function Slowness, 8.3.0 Craig Ringer (03:41)
Re: Strange behavior: pgbench and new Linux kernels Greg Smith (03:25)
Re: Strange behavior: pgbench and new Linux kernels david (00:35)
Re: Strange behavior: pgbench and new Linux kernels Greg Smith (00:26)
17 April 2008
Re: SQL Function Slowness, 8.3.0 Tom Lane (23:38)
Re: Background writer underemphasized ... Marinos Yannikos (18:46)
Re: seq scan issue... Rodrigo Gonzalez (18:31)
Re: seq scan issue... Jeffrey Baker (18:30)
seq scan issue... kevin kempter (18:24)
Re: POSIX file updates Greg Smith (18:19)
Re: Strange behavior: pgbench and new Linux kernels Greg Smith (18:15)
Re: Strange behavior: pgbench and new Linux kernels Matthew (17:50)
Re: SQL Function Slowness, 8.3.0 Alvaro Herrera (17:15)
Re: Strange behavior: pgbench and new Linux kernels Jeffrey Baker (17:09)
Re: SQL Function Slowness, 8.3.0 Craig Ringer (17:01)
Re: SQL Function Slowness, 8.3.0 Simon Riggs (16:49)
Re: SQL Function Slowness, 8.3.0 Tom Lane (16:41)
Re: SQL Function Slowness, 8.3.0 Simon Riggs (16:24)
Re: SQL Function Slowness, 8.3.0 Tom Lane (16:13)
Re: SQL Function Slowness, 8.3.0 Simon Riggs (16:11)
Re: Strange behavior: pgbench and new Linux kernels Matthew (15:52)
Re: Exact index overhead Gunther Mayer (15:49)
Re: rename constraint Thomas Spreng (12:14)
rename constraint sathiya psql (12:03)
Re: Exact index overhead Pavan Deolasee (10:16)
Re: Exact index overhead Heikki Linnakangas (10:03)
Re: Exact index overhead Richard Huxton (10:00)
Exact index overhead Gunther Mayer (09:35)
Re: db size Richard Huxton (08:52)
Re: db size Adrian Moisey (08:43)
Re: db size Adrian Moisey (08:37)
Re: db size Richard Huxton (08:15)
Strange behavior: pgbench and new Linux kernels Greg Smith (07:58)
Re: db size Adrian Moisey (06:28)
Re: Oddly slow queries Andrew Sullivan (03:20)
Re: Anybody using the Dell Powervault MD3000 array? Craig James (00:08)
16 April 2008
Re: Oddly slow queries Thomas Spreng (21:48)
Query running slow samantha mahindrakar (21:14)
Re: Anybody using the Dell Powervault MD3000 array? Gavin M. Roy (20:53)
Re: Anybody using the Dell Powervault MD3000 array? Joshua D. Drake (20:39)
Re: Anybody using the Dell Powervault MD3000 array? Jeffrey Baker (20:37)
Re: SQL Function Slowness, 8.3.0 Tom Lane (20:24)
Re: Anybody using the Dell Powervault MD3000 array? Joshua D. Drake (20:20)
Re: Anybody using the Dell Powervault MD3000 array? Gavin M. Roy (20:17)
Anybody using the Dell Powervault MD3000 array? Jeffrey Baker (20:15)
Re: Background writer underemphasized ... Bill Moran (20:07)
Re: Background writer underemphasized ... Greg Smith (19:56)
Re: Background writer underemphasized ... Greg Smith (19:45)
Re: SQL Function Slowness, 8.3.0 Joshua D. Drake (18:58)
Re: SQL Function Slowness, 8.3.0 Gavin M. Roy (18:48)
Re: Background writer underemphasized ... Bill Moran (18:48)
Re: Background writer underemphasized ... Chris Browne (18:34)
Re: Oddly slow queries Chris Browne (16:26)
Background writer underemphasized ... Marinos Yannikos (15:23)
Re: SQL Function Slowness, 8.3.0 Mark Mielke (15:14)
Re: SQL Function Slowness, 8.3.0 Tom Lane (15:10)
SQL Function Slowness, 8.3.0 Gavin M. Roy (15:06)
Re: Oddly slow queries PFC (08:17)
Re: Performance increase with elevator=deadline Albe Laurenz (05:31)
Re: Oddly slow queries Thomas Spreng (04:07)
15 April 2008
Re: Performance increase with elevator=deadline david (19:02)
Oddly slow queries Thomas Spreng (19:02)
Re: shared_buffers performance Gaetano Mendola (15:07)
Re: Performance increase with elevator=deadline Florian Weimer (13:27)
Re: db size Bill Moran (11:12)
Re: shared_buffers performance Gaetano Mendola (09:25)
Re: shared_buffers performance Gaetano Mendola (09:25)
Re: db size Adrian Moisey (07:33)
14 April 2008
Re: varchar index joins not working? Tom Lane (22:01)
Re: varchar index joins not working? Adam Gundy (21:12)
Re: shared_buffers performance Greg Smith (20:08)
Re: shared_buffers performance Gregory Stark (19:58)
Re: shared_buffers performance Tom Lane (19:32)
Re: varchar index joins not working? Richard Huxton (17:54)
Re: varchar index joins not working? Tom Lane (17:46)
Re: varchar index joins not working? Adam Gundy (17:02)
Re: shared_buffers performance Greg Smith (15:44)
Re: shared_buffers performance Greg Smith (15:43)
Re: db size Bill Moran (13:14)
Re: shared_buffers performance Richard Huxton (11:26)
Re: shared_buffers performance Gregory Stark (10:56)
Re: db size PFC (09:57)
Re: db size Adrian Moisey (09:44)
Re: db size Craig Ringer (09:41)
Re: db size PFC (09:29)
Re: db size Adrian Moisey (09:22)
Re: db size PFC (09:14)
shared_buffers performance Gaetano Mendola (09:12)
Re: db size Craig Ringer (07:38)
Re: varchar index joins not working? Richard Huxton (07:14)
Re: db size Vinubalaji Gopal (06:53)
db size Adrian Moisey (06:39)
12 April 2008
11 April 2008
Re: Performance increase with elevator=deadline Greg Smith (19:56)
Re: Performance increase with elevator=deadline Craig Ringer (18:04)
Re: Creating large database of MD5 hash values Florian Weimer (17:04)
Re: Performance increase with elevator=deadline Matthew (16:40)
Re: Performance increase with elevator=deadline Jeff (16:10)
Re: Creating large database of MD5 hash values Jon Stewart (15:29)
Re: Performance increase with elevator=deadline Gregory Stark (14:47)
Re: recommendations for web/db connection pooling or DBD::Gofer reviews Vivek Khera (14:44)
Re: Creating large database of MD5 hash values Alvaro Herrera (14:38)
Re: Creating large database of MD5 hash values Florian Weimer (14:13)
Re: Creating large database of MD5 hash values Chris (12:24)
Performance increase with elevator=deadline Albe Laurenz (11:22)
Re: Partitioned tables - planner wont use indexes PFC (10:37)
Re: Views and functions returning sets of records Craig Ringer (07:24)
Re: Performance is low Postgres+Solaris Reid Thompson (00:14)
10 April 2008
Re: shared_buffers in 8.2.x Erik Jones (22:33)
Re: large tables and simple "= constant" queries using indexes PFC (21:33)
Re: recommendations for web/db connection pooling or DBD::Gofer reviews Mark Stosberg (21:29)
Partitioned tables - planner wont use indexes kevin kempter (19:11)
Re: varchar index joins not working? Adam Gundy (18:54)
Re: large tables and simple "= constant" queries using indexes Greg Smith (18:48)
Re: large tables and simple "= constant" queries using indexes Bill Moran (17:09)
Re: large tables and simple "= constant" queries using indexes John Beaver (16:37)
Re: large tables and simple "= constant" queries using indexes Gaetano Mendola (16:25)
Re: Performance with temporary table valgog (15:26)
Re: large tables and simple "= constant" queries using indexes Erik Jones (15:03)
Re: varchar index joins not working? Adam Gundy (14:52)
Creating large database of MD5 hash values Jon Stewart (14:49)
Re: large tables and simple "= constant" queries using indexes John Beaver (14:45)
shared_buffers in 8.2.x Gaetano Mendola (12:45)
Re: large tables and simple "= constant" queries using indexes Matthew (09:51)
Re: varchar index joins not working? Richard Huxton (08:46)
Re: large tables and simple "= constant" queries using indexes PFC (08:21)
Re: large tables and simple "= constant" queries using indexes Arjen van der Meijden (07:22)
varchar index joins not working? Adam Gundy (03:14)
Re: Performance with temporary table samantha mahindrakar (02:43)
Re: Performance with temporary table Erik Jones (02:32)
09 April 2008
Re: Performance with temporary table samantha mahindrakar (23:33)
Re: large tables and simple "= constant" queries using indexes Jeremy Harris (22:31)
Re: large tables and simple "= constant" queries using indexes PFC (22:26)
Re: EXPLAIN detail Richard Broersma (22:17)
Re: large tables and simple "= constant" queries using indexes Bill Moran (21:36)
Re: large tables and simple "= constant" queries using indexes Arjen van der Meijden (21:21)