• Text Size: Normal / Large
• Donate
• Contact

Section Navigation

• Community
• Contributors
• Mailing Lists
  • Subscribe
  • User lists
    • pgsql-admin
    • pgsql-advocacy
    • pgsql-announce
    • pgsql-bugs
    • pgsql-docs
    • pgsql-general
    • pgsql-jobs
    • pgsql-novice
    • pgsql-performance
    • pgsql-php
    • pgsql-sql
    • pgsql-students
  • Developer lists
  • Regional lists
  • Associations
  • User groups
  • Project lists
  • Inactive lists
• IRC
• Featured Users
• International Sites
• Propaganda
• Resources
• Weekly News
• Community login
  • Profile
  • Lost password

pgsql-performance 2007-08 Chronological Index (1/3)

• Thread Index
• [Prev Page]
• [Next Page]

• 01 September 2007
  • Re: Fwd: 8.2 Query 10 times slower than 8.1 (view-heavy) Mark Lewis (00:09)
• 31 August 2007
  • Re: 8.2 Autovacuum BUG ? Tom Lane (23:48)
  • Re: Fwd: 8.2 Query 10 times slower than 8.1 (view-heavy) Tom Lane (23:41)
  • Re: 8.2 Autovacuum BUG ? Greg Smith (23:25)
  • Re: 8.2 Autovacuum BUG ? Chris Browne (20:04)
  • Re: 8.2 Autovacuum BUG ? Tom Lane (19:48)
  • Re: [Solved] Postgres performance problem Vivek Khera (19:36)
  • Re: 8.2 Autovacuum BUG ? Erik Jones (19:36)
  • Re: 8.2 Autovacuum BUG ? Tom Lane (19:08)
  • Re: 8.2 Autovacuum BUG ? Alvaro Herrera (18:51)
  • Re: 8.2 Autovacuum BUG ? Alvaro Herrera (18:47)
  • Re: 8.2 Autovacuum BUG ? Pallav Kalva (18:42)
  • Re: 8.2 Autovacuum BUG ? Mikko Partio (18:31)
  • Re: 8.2 Autovacuum BUG ? Chris Browne (18:04)
  • Re: 8.2 Autovacuum BUG ? Mark Lewis (16:29)
  • Re: 8.2 Autovacuum BUG ? Pallav Kalva (16:25)
  • Re: 8.2 Autovacuum BUG ? Alvaro Herrera (16:12)
  • Re: 8.2 Autovacuum BUG ? Pallav Kalva (16:05)
  • Re: 8.2 Autovacuum BUG ? Tom Lane (15:39)
  • 8.2 Autovacuum BUG ? Pallav Kalva (15:31)
• 30 August 2007
  • Re: [Solved] Postgres performance problem Richard Huxton (18:13)
  • Re: [Solved] Postgres performance problem Mark Lewis (18:08)
  • Re: [Solved] Postgres performance problem Decibel! (17:32)
  • Re: [Solved] Postgres performance problem Ruben Rubio (09:50)
  • Re: Postgres performance problem ruben (07:52)
  • Re: Shared memory usage Max Zorloff (05:42)
• 29 August 2007
  • Re: Transaction Log Alan Hodgson (20:37)
  • Re: Transaction Log Bill Moran (20:22)
  • Re: Transaction Log Steinar H. Gunderson (20:18)
  • Re: Transaction Log Steve Atkins (20:11)
  • Re: Transaction Log Mark Mielke (19:54)
  • Transaction Log mbguy2000-1 (19:31)
  • Transaction Log Markus Benne (19:29)
  • Re: Shared memory usage Greg Smith (19:26)
  • Re: LIKE query verses = Tom Lane (17:52)
  • Re: LIKE query verses = Mark Lewis (17:12)
  • Performance issue with nested loop Jens Reufsteck (14:33)
  • LIKE query verses = Karthikeyan Mahadevan (12:41)
  • Performance issue with nested loop Jens Reufsteck (10:16)
  • Re: Performance problem with table containing a lot of text (blog) Heikki Linnakangas (10:15)
  • Re: Performance problem with table containing a lot of text (blog) Kari Lavikka (09:39)
  • Re: Performance problem with table containing a lot of text (blog) Heikki Linnakangas (08:29)
  • Re: index & Bitmap Heap Scan Paul (08:16)
  • Re: Performance across multiple schemas Robins (02:45)
  • Re: Performance across multiple schemas Robins Tharakan (01:50)
• 28 August 2007
  • Re: io storm on checkpoints, postgresql 8.2.4, linux Decibel! (21:34)
  • Re: 8.2.4 Chooses Bad Query Plan Tom Lane (21:06)
  • Re: 8.2.4 Chooses Bad Query Plan Pallav Kalva (19:29)
  • Re: Performance problem with table containing a lot of text (blog) Kari Lavikka (19:10)
  • Re: Performance problem with table containing a lot of text (blog) Dan Harris (19:04)
  • Performance problem with table containing a lot of text (blog) Kari Lavikka (18:53)
  • Re: Fwd: 8.2 Query 10 times slower than 8.1 (view-heavy) Tom Lane (18:48)
  • Re: 8.2.4 Chooses Bad Query Plan Tom Lane (18:36)
  • Re: Postgres performance problem Anton Melser (18:36)
  • Re: index & Bitmap Heap Scan Tom Lane (16:56)
  • Re: Fwd: 8.2 Query 10 times slower than 8.1 (view-heavy) Mark Lewis (16:51)
  • Re: 8.2 Query 10 times slower than 8.1 (view-heavy) Evan Carroll (16:36)
  • Re: 8.2 Query 10 times slower than 8.1 (view-heavy) Evan Carroll (16:28)
  • Fwd: 8.2 Query 10 times slower than 8.1 (view-heavy) Evan Carroll (16:25)
  • Re: 8.2 Query 10 times slower than 8.1 (view-heavy) Kevin Grittner (16:20)
  • Re: 8.2 Query 10 times slower than 8.1 (view-heavy) Joshua D. Drake (16:14)
  • Re: 8.2 Query 10 times slower than 8.1 (view-heavy) Gregory Stark (15:58)
  • Re: 8.2 Query 10 times slower than 8.1 (view-heavy) Scott Marlowe (15:32)
  • 8.2 Query 10 times slower than 8.1 (view-heavy) Evan Carroll (15:22)
  • 8.2.4 Chooses Bad Query Plan Pallav Kalva (15:09)
  • Re: io storm on checkpoints, postgresql 8.2.4, linux Erik Jones (15:01)
  • Re: server performance issues - suggestions for tuning Scott Marlowe (14:32)
  • Re: server performance issues - suggestions for tuning Andrew Sullivan (14:27)
  • Re: Performance across multiple schemas Tom Lane (13:50)
  • Re: Performance across multiple schemas Robins (13:44)
  • Re: server performance issues - suggestions for tuning Kevin Grittner (13:12)
  • Performance across multiple schemas Robins (13:05)
  • Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Heikki Linnakangas (10:21)
  • Re: Performance issue Willo van der Merwe (09:34)
  • index & Bitmap Heap Scan Paul (08:49)
  • Re: server performance issues - suggestions for tuning Richard Huxton (07:52)
  • server performance issues - suggestions for tuning Kevin Kempter (04:15)
• 27 August 2007
  • Re: significant vacuum issues - looking for suggestions Kevin Kempter (22:07)
  • Re: significant vacuum issues - looking for suggestions Kevin Kempter (22:05)
  • Re: significant vacuum issues - looking for suggestions Decibel! (22:04)
  • Re: significant vacuum issues - looking for suggestions Kevin Kempter (22:01)
  • Re: significant vacuum issues - looking for suggestions Kevin Grittner (21:56)
  • Re: asynchronous commit feature Merlin Moncure (21:18)
  • Re: significant vacuum issues - looking for suggestions Decibel! (21:00)
  • Re: asynchronous commit feature Decibel! (20:11)
  • Re: Performance issue Tom Lane (15:56)
  • Re: Performance issue Bill Moran (14:45)
  • Performance issue Willo van der Merwe (14:36)
  • Bitmap Heap Scan before using index GOERGLER Paul (13:33)
  • Re: Postgres performance problem Bill Moran (13:29)
  • Performance issue Willo van der Merwe (13:18)
  • Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Tomas Tamosaitis (13:14)
  • Re: Postgres performance problem ruben (12:52)
  • Re: Postgres performance problem Chris Mair (12:34)
  • Re: Shared memory usage Max Zorloff (12:20)
  • Postgres performance problem Ruben Rubio (11:48)
  • Re: Shared memory usage Adam Tauno Williams (10:21)
• 25 August 2007
  • Re: [GENERAL] Shared memory usage Max Zorloff (21:34)
  • Re: [GENERAL] Shared memory usage Max Zorloff (21:24)
  • Re: [GENERAL] Shared memory usage Martijn van Oosterhout (20:40)
  • Shared memory usage Max Zorloff (20:24)
  • Re: [GENERAL] Partioning tsearch2 a table into chunks and accessing via views Erik Jones (20:09)
  • Re: Partioning tsearch2 a table into chunks and accessing via views Erik Jones (19:58)
  • Re: [GENERAL] Partioning tsearch2 a table into chunks and accessing via views Benjamin Arai (19:49)
  • Re: [GENERAL] Partioning tsearch2 a table into chunks and accessing via views Joshua D. Drake (18:18)
  • Re: [GENERAL] Partioning tsearch2 a table into chunks and accessing via views Brandon Shalton (18:18)
  • Re: [GENERAL] Partioning tsearch2 a table into chunks and accessing via views Benjamin Arai (18:14)
  • Re: [GENERAL] Partioning tsearch2 a table into chunks and accessing via views Joshua D. Drake (16:18)
  • Re: significant vacuum issues - looking for suggestions Kevin Kempter (05:35)
  • Re: [GENERAL] Partioning tsearch2 a table into chunks and accessing via views Benjamin Arai (05:34)
  • Re: [GENERAL] Partioning tsearch2 a table into chunks and accessing via views Joshua D. Drake (01:29)
  • Re: Partioning tsearch2 a table into chunks and accessing via views Brandon Shalton (00:54)
  • Partioning tsearch2 a table into chunks and accessing via views Benjamin Arai (00:42)
• 24 August 2007
  • Re: When/if to Reindex Tom Lane (21:44)
  • Re: significant vacuum issues - looking for suggestions Tom Lane (21:39)
  • Re: significant vacuum issues - looking for suggestions Bill Moran (21:08)
  • Re: significant vacuum issues - looking for suggestions Kevin Grittner (20:53)
  • Re: significant vacuum issues - looking for suggestions Bill Moran (20:42)
  • Re: When/if to Reindex Gregory Stark (20:07)
  • significant vacuum issues - looking for suggestions Kevin Kempter (20:05)
  • Re: When/if to Reindex Steven Flatt (17:49)
  • Re: When/if to Reindex Tom Lane (17:29)
  • Re: When/if to Reindex Steven Flatt (16:56)
  • Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Luke Lonergan (16:26)
  • Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Luke Lonergan (16:20)
  • Re: When/if to Reindex Tom Lane (16:15)
  • Re: When/if to Reindex Steven Flatt (14:22)
  • Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Heikki Linnakangas (10:39)
  • Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Anton (10:32)
  • Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Mikko Partio (10:24)
  • partitioned table and ORDER BY indexed_field DESC LIMIT 1 Anton (08:53)
  • Re: When/if to Reindex Gregory Stark (06:49)
  • Re: When/if to Reindex Mark Kirkwood (05:27)
  • Re: When/if to Reindex Tom Lane (03:59)
  • Re: Optimising "in" queries Tom Lane (02:19)
• 23 August 2007
  • Re: Optimising "in" queries Stephen Davies (23:48)
  • Re: When/if to Reindex Steven Flatt (22:25)
  • Re: Raid Configurations Decibel! (21:31)
  • Re: Optimising "in" queries Alvaro Herrera (19:46)
  • Re: long-running query - needs tuning Tom Lane (18:56)
  • Re: deadlock_timeout parameter in Postgresql.cof Bill Moran (18:52)
  • deadlock_timeout parameter in Postgresql.cof Sachchida Ojha (18:29)
  • deadlock_timeout parameter in Postgresql.cof Sachchida Ojha (18:22)
  • Re: Installing PostgreSQL Campbell, Lance (17:38)
  • Re: Installing PostgreSQL Richard Huxton (17:28)
  • Re: Installing PostgreSQL Greg Smith (17:26)
  • long-running query - needs tuning Kevin Kempter (17:24)
  • Re: Installing PostgreSQL Campbell, Lance (17:19)
  • Re: Installing PostgreSQL Richard Huxton (17:12)
  • Re: io storm on checkpoints, postgresql 8.2.4, linux Greg Smith (17:01)
  • Installing PostgreSQL Campbell, Lance (16:47)
  • Re: io storm on checkpoints, postgresql 8.2.4, linux Dmitry Potapov (14:37)
  • asynchronous commit feature Merlin Moncure (13:09)
  • Re: Optimising "in" queries Russell Smith (07:46)
  • Re: Optimising "in" queries Russell Smith (07:38)
  • Re: Optimising "in" queries Michael Glaesemann (00:21)
• 22 August 2007
  • Re: When/if to Reindex Gregory Stark (23:51)
  • Re: Optimising "in" queries Stephen Davies (23:30)
  • Re: Long running transaction in pg_activity_log Farhan Mughal (21:58)
  • Re: Long running transaction in pg_activity_log Tobias Brox (21:41)
  • Re: Fast tsearch2, trigram matching on short phrases Carlo Stonebanks (21:09)
  • Re: Long running transaction in pg_activity_log Sachchida Ojha (20:58)
  • Long running transaction in pg_activity_log Sachchida Ojha (20:43)
  • Re: Fast tsearch2, trigram matching on short phrases Oleg Bartunov (20:43)
  • Re: io storm on checkpoints, postgresql 8.2.4, linux Greg Smith (20:30)
  • Re: Fast tsearch2, trigram matching on short phrases Carlo Stonebanks (20:30)
  • Re: Fast tsearch2, trigram matching on short phrases Carlo Stonebanks (20:24)
  • Re: Optimising "in" queries Kevin Grittner (18:50)
  • Re: Fast tsearch2, trigram matching on short phrases Oleg Bartunov (18:48)
  • Re: When/if to Reindex Steven Flatt (16:55)
  • Re: Fast tsearch2, trigram matching on short phrases Steinar H. Gunderson (16:30)
  • Re: io storm on checkpoints, postgresql 8.2.4, linux Dmitry Potapov (16:28)
  • Re: io storm on checkpoints, postgresql 8.2.4, linux Dmitry Potapov (16:23)
  • Re: io storm on checkpoints, postgresql 8.2.4, linux Dmitry Potapov (16:16)
  • Fast tsearch2, trigram matching on short phrases Carlo Stonebanks (16:02)
  • Re: io storm on checkpoints, postgresql 8.2.4, linux Joshua D. Drake (16:01)
  • Re: io storm on checkpoints, postgresql 8.2.4, linux Mark Mielke (15:57)
  • Re: io storm on checkpoints, postgresql 8.2.4, linux Kenneth Marshall (15:57)
  • io storm on checkpoints, postgresql 8.2.4, linux Dmitry Potapov (15:33)
  • Re: Optimising "in" queries Michael Glaesemann (13:25)

• Thread Index
• [Prev Page]
• [Next Page]