• 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 2008-11 Chronological Index (1/2)

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

• 30 November 2008
  • Seq scan over 3.3 millions of rows instead of using date and pattern indexes Andrus (20:42)
  • Re: Query optimization Marc Cousin (19:37)
  • Query optimization tmp (19:12)
  • Re: Increasing GROUP BY CHAR columns speed Greg Stark (13:02)
• 29 November 2008
  • Re: Increasing GROUP BY CHAR columns speed Andrus (17:44)
• 28 November 2008
  • Re: Memory Allocation Kevin Grittner (22:28)
  • Re: Increasing GROUP BY CHAR columns speed Andrus (20:44)
  • Re: Increasing GROUP BY CHAR columns speed Scott Marlowe (20:34)
  • Re: Increasing GROUP BY CHAR columns speed Andrus (20:31)
  • Re: Increasing GROUP BY CHAR columns speed Andrus (19:57)
  • Re: Increasing GROUP BY CHAR columns speed Scott Carey (19:51)
  • Re: Increasing GROUP BY CHAR columns speed Scott Marlowe (18:24)
  • Re: Increasing GROUP BY CHAR columns speed Andrus (17:59)
  • Re: Increasing GROUP BY CHAR columns speed Scott Carey (17:07)
  • Re: Deteriorating performance when loading large objects Vegard Bønes (15:32)
  • Increasing GROUP BY CHAR columns speed Andrus (15:12)
  • Re: Increasing pattern index query speed Andrus (14:58)
  • Re: Deteriorating performance when loading large objects Mario Weilguni (08:30)
• 27 November 2008
  • Re: Deteriorating performance when loading large objects Tom Lane (21:29)
  • Re: Deteriorating performance when loading large objects Vegard Bønes (19:05)
  • Re: Partition table query performance Greg Jaman (17:25)
  • Re: many to many performance Chavdar Kopoev (16:40)
  • Re: performance tuning queries Mario Weilguni (10:09)
  • Re: performance tuning queries A. Kretschmer (08:55)
  • Re: performance tuning queries PFC (08:44)
  • performance tuning queries Kevin Kempter (04:50)
  • Re: Partition table query performance Gregory Stark (00:48)
• 26 November 2008
  • Re: Memory Allocation Scott Carey (23:52)
  • Re: Memory Allocation Kevin Grittner (23:09)
  • Re: Memory Allocation Scott Carey (23:00)
  • Re: Memory Allocation Tom Lane (22:58)
  • Re: Memory Allocation Carlos Moreno (22:57)
  • Re: Increasing pattern index query speed Scott Carey (22:27)
  • Re: Memory Allocation Alan Hodgson (22:18)
  • Memory Allocation Ryan Hansen (22:10)
  • Re: Increasing pattern index query speed Richard Huxton (20:33)
  • Re: Increasing pattern index query speed Andrus (20:21)
  • Re: Increasing pattern index query speed Andrus (20:11)
  • Re: Increasing pattern index query speed Richard Huxton (19:55)
  • many to many performance Chavdar Kopoev (19:47)
  • Re: Increasing pattern index query speed Andrus (19:40)
  • Re: Increasing pattern index query speed Andrus (19:25)
  • Re: Increasing pattern index query speed Richard Huxton (19:07)
  • Re: Increasing pattern index query speed Andrus (18:57)
  • Re: many to many performance Craig Ringer (17:40)
  • many to many performance Chavdar Kopoev (15:38)
  • Re: Increasing pattern index query speed Mario Weilguni (14:21)
  • Re: Increasing pattern index query speed Richard Huxton (10:41)
  • Partition table query performance Greg Jaman (04:07)
• 25 November 2008
  • Re: Monitoring buffercache... Mark Kirkwood (19:38)
  • Re: Deteriorating performance when loading large objects Tom Lane (13:37)
  • Re: Deteriorating performance when loading large objects Ivan Voras (13:18)
  • Deteriorating performance when loading large objects Vegard Bønes (12:54)
  • Re: Monitoring buffercache... Scott Marlowe (04:54)
  • Re: Monitoring buffercache... Greg Smith (04:48)
  • Re: Monitoring buffercache... Greg Smith (04:34)
• 24 November 2008
  • Re: limit clause produces wrong query plan Scott Carey (23:10)
  • Re: limit clause produces wrong query plan PFC (22:58)
  • Re: Increasing pattern index query speed Scott Carey (22:51)
  • Re: limit clause produces wrong query plan Chris (22:20)
  • Re: Monitoring buffercache... Scott Marlowe (21:24)
  • Re: Hash join on int takes 8..114 seconds Andrus (21:16)
  • Re: Increasing pattern index query speed Andrus (20:33)
  • Re: limit clause produces wrong query plan Andrus (20:05)
  • Re: Monitoring buffercache... Brad Nicholson (19:52)
  • Re: Monitoring buffercache... Scott Marlowe (19:46)
  • Re: Monitoring buffercache... Brad Nicholson (19:45)
  • Re: limit clause produces wrong query plan Scott Marlowe (19:23)
  • Re: limit clause produces wrong query plan Andrus (19:13)
  • Monitoring buffercache... Kevin Kempter (18:49)
  • Re: Perc 3 DC PFC (17:02)
  • Re: Perc 3 DC Scott Marlowe (16:24)
  • Re: Perc 3 DC Simon Waters (16:14)
  • Re: Perc 3 DC Scott Marlowe (15:18)
  • Re: Perc 3 DC Glyn Astill (15:06)
  • Re: Perc 3 DC Scott Marlowe (14:52)
  • Re: Perc 3 DC Glyn Astill (14:49)
  • Re: Hash join on int takes 8..114 seconds tv (13:39)
  • Re: Perc 3 DC Steve Clark (13:24)
  • Re: Hash join on int takes 8..114 seconds Andrus (13:16)
  • Re: Increasing pattern index query speed Richard Huxton (09:36)
• 23 November 2008
  • Re: Hash join on int takes 8..114 seconds Tomas Vondra (23:39)
  • Re: Hash join on int takes 8..114 seconds Tomas Vondra (23:11)
  • Re: Hash join on int takes 8..114 seconds Andrus (22:44)
  • Re: Hash join on int takes 8..114 seconds Andrus (21:41)
  • limit clause produces wrong query plan Andrus (21:41)
  • Re: Hash join on int takes 8..114 seconds Scott Carey (21:40)
  • Re: Hash join on int takes 8..114 seconds Tomas Vondra (18:47)
  • Re: Hash join on int takes 8..114 seconds Andrus (14:40)
  • Re: seq scan over 3.3 million rows instead of single keyindex access Andrus (12:41)
  • Re: seq scan over 3.3 million rows instead of single key index access A. Kretschmer (12:20)
  • Re: seq scan over 3.3 million rows instead of single key index access Andreas Kretschmer (08:13)
  • Re: seq scan over 3.3 million rows instead of single key index access Andreas Kretschmer (08:10)
  • Re: Hash join on int takes 8..114 seconds PFC (07:21)
  • Re: seq scan over 3.3 million rows instead of single key index access Andrus (04:21)
• 22 November 2008
  • Re: seq scan over 3.3 million rows instead of single key index access Tom Lane (23:59)
  • Re: seq scan over 3.3 million rows instead of single key index access Gregory Stark (23:04)
  • Re: Perc 3 DC Glyn Astill (22:00)
  • Increasing pattern index query speed Andrus (20:41)
  • seq scan over 3.3 million rows instead of single key index access Andrus (20:41)
  • Re: Hash join on int takes 8..114 seconds Andrus (20:19)
  • Re: Perc 3 DC Scott Marlowe (18:27)
  • Re: Hash join on int takes 8..114 seconds PFC (17:09)
  • Re: Perc 3 DC Glyn Astill (16:59)
  • Re: Perc 3 DC Scott Marlowe (16:16)
  • Perc 3 DC Glyn Astill (14:18)
• 21 November 2008
  • Re: Hash join on int takes 8..114 seconds Scott Carey (23:11)
  • Re: Hash join on int takes 8..114 seconds Andrus (21:53)
  • Re: Hash join on int takes 8..114 seconds Tomas Vondra (21:22)
  • Re: Hash join on int takes 8..114 seconds Tomas Vondra (20:48)
  • Re: Hash join on int takes 8..114 seconds Alvaro Herrera (20:21)
  • Re: Hash join on int takes 8..114 seconds Andrus (20:09)
  • Re: Hash join on int takes 8..114 seconds Tom Lane (20:07)
  • Re: Hash join on int takes 8..114 seconds Alvaro Herrera (19:48)
  • Re: Hash join on int takes 8..114 seconds Andrus (19:45)
  • Re: Hash join on int takes 8..114 seconds Alvaro Herrera (19:17)
  • Re: Hash join on int takes 8..114 seconds Alan Hodgson (19:13)
  • Re: Hash join on int takes 8..114 seconds Andrus (19:10)
  • Re: Hash join on int takes 8..114 seconds PFC (19:07)
  • Re: Hash join on int takes 8..114 seconds Andrus (19:00)
  • Re: Hash join on int takes 8..114 seconds PFC (18:31)
  • Re: Hash join on int takes 8..114 seconds PFC (17:57)
  • Re: Hash join on int takes 8..114 seconds Andrus (17:51)
  • Re: Hash join on int takes 8..114 seconds Richard Huxton (16:32)
  • Re: Hash join on int takes 8..114 seconds tv (16:14)
  • Re: Hash join on int takes 8..114 seconds Andrus (15:16)
  • Re: Hash join on int takes 8..114 seconds Andrus (13:49)
  • Re: Performance and IN clauses Tomas Vondra (01:35)
• 20 November 2008
  • Re: Hash join on int takes 8..114 seconds PFC (13:45)
  • Re: Hash join on int takes 8..114 seconds Richard Huxton (11:22)
  • Re: Hash join on int takes 8..114 seconds Andrus (11:14)
  • Re: Hash join on int takes 8..114 seconds Richard Huxton (10:45)
  • Re: Hash join on int takes 8..114 seconds Andrus (09:12)
  • Re: Very Urgent : Sequences Problem Greg Smith (05:04)
• 19 November 2008
  • Re: Hash join on int takes 8..114 seconds PFC (23:28)
  • Hash join on int takes 8..114 seconds Andrus (20:40)
  • Re: Very Urgent : Sequences Problem tv (16:52)
  • Re: Very Urgent : Sequences Problem Merlin Moncure (16:43)
  • Re: Very Urgent : Sequences Problem Josh Berkus (16:34)
  • Very Urgent : Sequences Problem Kranti™ K K Parisa (15:54)
  • Re: PostgreSQL NOT IN performance Віталій Тимчишин (15:12)
  • Re: PostgreSQL NOT IN performance Stephan Szabo (15:08)
  • Re: PostgreSQL NOT IN performance Віталій Тимчишин (14:55)
  • Re: PostgreSQL NOT IN performance Alvaro Herrera (13:11)
  • Re: PostgreSQL NOT IN performance DANIEL CRISTIAN CRUZ (12:50)
  • PostgreSQL NOT IN performance Віталій Тимчишин (11:51)
  • Re: Performance and IN clauses Tomas Vondra (00:49)
• 18 November 2008
  • Re: Performance and IN clauses Mark Roberts (23:27)
  • Re: Performance and IN clauses tv (16:38)
  • Re: Performance and IN clauses Matthew Wakeling (16:12)
  • Performance and IN clauses Kynn Jones (15:53)
• 17 November 2008
  • Re: Bad performance on simple query Dave Page (20:47)
  • Re: Bad performance on simple query Dimi Paun (18:14)
  • Re: Bad performance on simple query ries van Twisk (17:45)
  • Re: Bad performance on simple query Scott Marlowe (17:40)
  • Re: Bad performance on simple query Dimi Paun (17:31)
  • Re: Bad performance on simple query Scott Marlowe (17:16)
  • Re: Bad performance on simple query Dimi Paun (17:07)
  • Re: Bad performance on simple query Scott Marlowe (16:53)
  • Re: Bad performance on simple query Alan Hodgson (16:28)
  • Bad performance on simple query Dimi Paun (16:26)
  • Re: Improve Seq scan performance PFC (10:51)
  • Re: PostgreSQL OR performance Віталій Тимчишин (09:52)
• 16 November 2008
  • Re: Performance Question PFC (15:19)
  • Re: slow full table update PFC (14:56)
  • Re: Improve Seq scan performance PFC (14:55)
• 15 November 2008
  • Re: PostgreSQL OR performance Tom Lane (17:07)
  • Re: PostgreSQL OR performance Віталій Тимчишин (13:57)
  • Re: PostgreSQL OR performance Віталій Тимчишин (13:55)
• 14 November 2008
  • Re: Difference in query plan Richard Huxton (17:14)
  • Re: Difference in query plan Patrice Beliveau (17:07)
  • Re: Difference in query plan Richard Huxton (16:47)
  • Difference in query plan Patrice Beliveau (16:29)
• 13 November 2008
  • Re: crosstab speed Joe Conway (23:06)
  • Re: crosstab speed Scott Marlowe (21:41)
  • crosstab speed Jeremiah Elliott (20:42)
  • Re: Slow SQL query (14-15 seconds) Bruno Baguette (18:02)
  • Re: Slow SQL query (14-15 seconds) Bruno Baguette (18:02)
  • Re: Slow SQL query (14-15 seconds) Tom Lane (14:30)
  • Re: Slow SQL query (14-15 seconds) Vladimir Sitnikov (14:29)

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