pgsql-performance - April 2008

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
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

April 1, 2008

Thread Author Time
Performance Implications of Using Exceptions Ravi Chemudugunta 00:20
Re: Performance Implications of Using Exceptions Stephen Frost 00:52
Re: Performance Implications of Using Exceptions Stephen Denne 00:56
Re: Performance Implications of Using Exceptions Ravi Chemudugunta 01:23
Re: Performance Implications of Using Exceptions Robins Tharakan 02:26
Re: Performance Implications of Using Exceptions Tom Lane 04:29
Re: POSIX file updates Tom Lane 05:07
Re: Bad prepare performance Cédric Villemain 07:53
check performance parameters Sabin Coanda 11:40
Cursors and different settings for default_statistics_target Hell, Robert 12:14
Re: check performance parameters Matthew 13:55
Re: Cursors and different settings for default_statistics_target Tom Lane 15:30
Insert time Ioana Danes 15:38
Re: Cursors and different settings for default_statistics_target Hell, Robert 15:48
Re: Cursors and different settings for default_statistics_target Tom Lane 16:16
Re: Cursors and different settings for default_statistics_target Hell, Robert 16:33
Re: Cursors and different settings for default_statistics_target Tom Lane 16:42
Re: Cursors and different settings for default_statistics_target Steinar H. Gunderson 19:57
Too many commands in a transaction samantha mahindrakar 20:58
Re: Cursors and different settings for default_statistics_target Hell, Robert 21:12
Re: Cursors and different settings for default_statistics_target Tom Lane 22:23

April 2, 2008

Thread Author Time
SSDs James Mansion 06:16
Re: SSDs Arjen van der Meijden 06:44
Re: Cursors and different settings for default_statistics_target Hell, Robert 10:11
Re: POSIX file updates James Mansion 19:10
Re: Performance Implications of Using Exceptions James Mansion 19:19
Re: POSIX file updates Andreas Kostyrka 20:24
Re: POSIX file updates James Mansion 22:48
Re: POSIX file updates Greg Smith 23:39
Re: POSIX file updates Greg Smith 23:49

April 3, 2008

Thread Author Time
Re: SSDs Merlin Moncure 04:36
Max shared_buffers bitaoxiao 04:56
Re: POSIX file updates James Mansion 05:32
Re: Performance Implications of Using Exceptions chemuduguntar@gmail.com 09:18
Re: Max shared_buffers sathiya psql 10:10
Performance is low Postgres+Solaris MUNAGALA REDDY 11:45
Re: Performance Implications of Using Exceptions Robins Tharakan 13:27
Re: Max shared_buffers Scott Marlowe 16:49
Re: Max shared_buffers Andrej Ricnik-Bay 17:16
Re: Max shared_buffers Matthew 17:20
Re: Max shared_buffers Scott Marlowe 17:48
Re: Max shared_buffers Craig Ringer 17:58
[Fwd: Re: Max shared_buffers] Justin 18:21
Query plan excluding index on view Matt Klinker 23:31
Re: Query plan excluding index on view Tom Lane 23:50

April 4, 2008

Thread Author Time
Forcing more agressive index scans for BITMAP AND Ow Mun Heng 03:39
Re: Query plan excluding index on view Matt Klinker 04:58
Re: Query plan excluding index on view Tom Lane 05:49
Re: Forcing more agressive index scans for BITMAP AND Matthew 10:40
Re: Forcing more agressive index scans for BITMAP AND PFC 11:02
Re: Query plan excluding index on view Matt Klinker 14:26
Partitioned tables - planner wont use indexes kevin kempter 22:36

April 5, 2008

Thread Author Time
Partitioned tables - planner wont use indexes kevin kempter 00:48
Re: Partitioned tables - planner wont use indexes paul rivers 01:07
Re: Partitioned tables - planner wont use indexes Gregory Stark 01:26
Re: Query plan excluding index on view Tom Lane 04:20

April 6, 2008

Thread Author Time
Re: Performance Implications of Using Exceptions James Mansion 20:21

April 7, 2008

Thread Author Time
Forcing more agressive index scans for BITMAP AND Ow Mun Heng 08:15
Re: Forcing more agressive index scans for BITMAP AND Matthew 10:50
Looking for bottleneck during load test Hell, Robert 12:16
Re: Looking for bottleneck during load test Ivan Voras 12:37
Severe performance problems for simple query Dimi Paun 15:21
Re: [SOLVED] Query plan excluding index on view Matt Klinker 15:46
Re: Partitioned tables - planner wont use indexes Bricklen Anderson 15:52
Re: Severe performance problems for simple query Matthew 16:19
Re: Severe performance problems for simple query Matthew 16:27
Re: Severe performance problems for simple query Heikki Linnakangas 16:32
Re: Severe performance problems for simple query Dimi Paun 16:41
Re: Severe performance problems for simple query Dimi Paun 16:45
performance using table partitions in Postgres 8.2.6 Janet Jacobsen 16:57
Re: Severe performance problems for simple query Matthew 17:02
Re: performance using table partitions in Postgres 8.2.6 Albert Cervera Areny 18:06
Performance with temporary table samantha mahindrakar 18:27
what worked: performance improvements for geo-spatial searching on FreeBSD Mark Stosberg 18:35
recommendations for web/db connection pooling or DBD::Gofer reviews Mark Stosberg 18:36
Re: recommendations for web/db connection pooling or DBD::Gofer reviews Joshua D. Drake 18:44
Re: what worked: performance improvements for geo-spatial searching on FreeBSD Oleg Bartunov 18:47
Re: Severe performance problems for simple query Florian Weimer 18:53
per-review of PgBouncer / Slony design Mark Stosberg 19:50
Re: Looking for bottleneck during load test Hell, Robert 20:12
Re: Looking for bottleneck during load test Bill Moran 20:20
Re: Looking for bottleneck during load test Greg Smith 20:40
Re: Looking for bottleneck during load test Bill Moran 20:49

April 8, 2008

Thread Author Time
bulk insert performance problem Christian Bourque 03:01
Re: bulk insert performance problem Craig Ringer 03:18
Re: bulk insert performance problem Chris 03:32
bulk data loading 📎 Potluri Srikanth 03:41
Re: bulk insert performance problem bitaoxiao 03:50
Re: Forcing more agressive index scans for BITMAP AND Ow Mun Heng 05:42
Re: bulk data loading Magnus Hagander 07:40
Re: bulk insert performance problem hubert depesz lubaczewski 08:41
Re: Looking for bottleneck during load test Ivan Voras 09:01
Re: Looking for bottleneck during load test Ivan Voras 09:02
Re: Looking for bottleneck during load test Hell, Robert 09:16
Re: Forcing more agressive index scans for BITMAP AND Matthew 11:02
Re: Views and functions returning sets of records Rajashri Tupe 11:54
Re: what worked: performance improvements for geo-spatial searching on FreeBSD Mark Stosberg 13:45
Re: bulk insert performance problem Mark Stosberg 13:50
Re: bulk insert performance problem Matthew 14:00
Re: Performance with temporary table Richard Huxton 15:50
Re: Performance with temporary table Alvaro Herrera 16:17
Re: Re: what worked: performance improvements for geo-spatial searching on FreeBSD Oleg Bartunov 17:38
Re: Performance with temporary table samantha mahindrakar 19:28
Re: Performance with temporary table Alvaro Herrera 19:43
Re: recommendations for web/db connection pooling or DBD::Gofer reviews PFC 22:40
Re: bulk insert performance problem PFC 22:48

April 9, 2008

Thread Author Time
EXPLAIN detail Luigi N. Puleio 09:51
Re: EXPLAIN detail Pavan Deolasee 10:04
Re: EXPLAIN detail Craig Ringer 10:28
Re: EXPLAIN detail Matthew 10:33
Re: Performance with temporary table valgog 10:44
Re: EXPLAIN detail Luigi N. Puleio 11:05
Re: EXPLAIN detail Craig Ringer 11:16
Re: EXPLAIN detail Luigi N. Puleio 13:45
Re: EXPLAIN detail Craig Ringer 14:15
Re: EXPLAIN detail Luigi N. Puleio 14:44
Re: EXPLAIN detail Craig Ringer 15:28
Re: EXPLAIN detail PFC 18:41
Re: Performance Implications of Using Exceptions Decibel! 20:00
Re: Performance with temporary table Decibel! 20:09
large tables and simple "= constant" queries using indexes John Beaver 20:58
Re: large tables and simple "= constant" queries using indexes Arjen van der Meijden 21:21
Re: large tables and simple "= constant" queries using indexes Bill Moran 21:36
Re: large tables and simple "= constant" queries using indexes Jeremy Harris 22:07
Re: EXPLAIN detail Richard Broersma 22:17
Re: large tables and simple "= constant" queries using indexes PFC 22:31
Re: Performance with temporary table samantha mahindrakar 23:33
Re: Performance with temporary table samantha mahindrakar 23:41

April 10, 2008

Thread Author Time
Re: Performance with temporary table Erik Jones 02:31
Re: Performance with temporary table samantha mahindrakar 02:43
varchar index joins not working? Adam Gundy 03:13
Re: large tables and simple "= constant" queries using indexes Arjen van der Meijden 07:13
Re: large tables and simple "= constant" queries using indexes PFC 08:25
Re: varchar index joins not working? Richard Huxton 08:46
Re: large tables and simple "= constant" queries using indexes Matthew 09:51
shared_buffers in 8.2.x Gaetano Mendola 12:39
Re: large tables and simple "= constant" queries using indexes John Beaver 14:44
Creating large database of MD5 hash values Jon Stewart 14:48
Re: varchar index joins not working? Adam Gundy 14:52
Re: Performance with temporary table valgog 14:58
Re: large tables and simple "= constant" queries using indexes Erik Jones 15:02
Re: large tables and simple "= constant" queries using indexes Gaetano Mendola 16:18
Re: large tables and simple "= constant" queries using indexes 📎 John Beaver 16:37
Re: large tables and simple "= constant" queries using indexes Bill Moran 17:08
Re: large tables and simple "= constant" queries using indexes Greg Smith 18:47
Re: varchar index joins not working? Adam Gundy 18:54
Re: recommendations for web/db connection pooling or DBD::Gofer reviews Mark Stosberg 21:28
Re: large tables and simple "= constant" queries using indexes PFC 21:37
Re: shared_buffers in 8.2.x Erik Jones 22:33
Re: Performance is low Postgres+Solaris Reid Thompson 23:22
Re: Performance is low Postgres+Solaris Reid Thompson 23:30

April 11, 2008

Thread Author Time
Re: Creating large database of MD5 hash values Chris 05:11
Re: Views and functions returning sets of records Craig Ringer 07:23
Re: Partitioned tables - planner wont use indexes PFC 10:41
Performance increase with elevator=deadline Albe Laurenz 11:22
Re: Creating large database of MD5 hash values Florian Weimer 14:05
Re: Creating large database of MD5 hash values Alvaro Herrera 14:25
Re: recommendations for web/db connection pooling or DBD::Gofer reviews Vivek Khera 14:41
Re: Performance increase with elevator=deadline Gregory Stark 14:47
Re: Performance increase with elevator=deadline Jeff 15:09
Re: Creating large database of MD5 hash values Jon Stewart 15:28
Re: Performance increase with elevator=deadline Matthew 16:40
Re: Creating large database of MD5 hash values Florian Weimer 17:04
Re: Performance increase with elevator=deadline Craig Ringer 18:03
Re: Performance increase with elevator=deadline Greg Smith 19:56
Re: Performance is low Postgres+Solaris Greg Smith 20:26

April 12, 2008

Thread Author Time
Re: Cached Query Plans PFC 09:13

April 14, 2008

Thread Author Time
db size Adrian Moisey 06:29
Re: db size Vinubalaji Gopal 06:55
Re: varchar index joins not working? Richard Huxton 07:14
Re: db size Craig Ringer 08:37
shared_buffers performance Gaetano Mendola 09:13
Re: db size PFC 09:18
Re: db size Adrian Moisey 09:21
Re: db size PFC 09:33
Re: db size Adrian Moisey 09:44
Re: db size PFC 10:01
Re: db size Craig Ringer 10:40
Re: shared_buffers performance Gregory Stark 10:56
Re: shared_buffers performance Richard Huxton 11:25
Re: db size Bill Moran 13:12
Re: shared_buffers performance Greg Smith 15:42
Re: shared_buffers performance Greg Smith 15:44
Re: varchar index joins not working? Adam Gundy 17:02
Re: varchar index joins not working? Tom Lane 17:46
Re: varchar index joins not working? Richard Huxton 17:54
Re: shared_buffers performance Tom Lane 19:31
Re: shared_buffers performance Gregory Stark 19:58
Re: shared_buffers performance Greg Smith 20:08
Re: varchar index joins not working? Adam Gundy 21:13
Re: varchar index joins not working? Tom Lane 22:01
Re: varchar index joins not working? Adam Gundy 22:16

April 15, 2008

Thread Author Time
Re: db size Adrian Moisey 07:33
Re: shared_buffers performance Gaetano Mendola 09:05
Re: shared_buffers performance Gaetano Mendola 09:11
Re: db size Bill Moran 11:12
Re: Performance increase with elevator=deadline Florian Weimer 13:27
Re: shared_buffers performance Gaetano Mendola 15:08
Oddly slow queries Thomas Spreng 19:01
Re: Performance increase with elevator=deadline david 19:08

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30