Mailing lists [pgsql-performance]

1 September 2011

• 12:28   Re: issue related to logging facility of postgres Justin Pitts
• 20:14   Re: 8.4 optimization regression? Tom Lane
• 20:24   Re: Summaries on SSD usage? Jim Nasby
• 20:26   Re: 8.4 optimization regression? Mark Kirkwood
• 20:26   Re: Summaries on SSD usage? Stefan Keller
• 20:55   Re: 8.4 optimization regression? Mark Kirkwood

2 September 2011

• 01:15   Re: Summaries on SSD usage? Jesper Krogh
• 01:58   Re: Summaries on SSD usage? Scott Marlowe
• 02:46   Re: Re: How to track number of connections and hosts to Postgres cluster Venkat Balaji
• 03:42   Re: Re: How to track number of connections and hosts to Postgres cluster Scott Marlowe
• 11:30   Re: Summaries on SSD usage? Shaun Thomas
• 19:04   Re: Summaries on SSD usage? Stefan Keller

3 September 2011

• 02:06   Re: Query performance issue Jayadevan
• 03:49   Re: Summaries on SSD usage? Jesper Krogh
• 05:56   Re: Summaries on SSD usage? Stefan Keller

4 September 2011

• 05:18   Re: Re: How to track number of connections and hosts to Postgres cluster Venkat Balaji
• 07:38   Re: Query performance issue Grzegorz Jaśkiewicz
• 11:31   Re: Query performance issue Kevin Grittner
• 12:18   Re: Query performance issue Tom Lane
• 15:06   Re: Query performance issue Jayadevan
• 17:18   Re: Query performance issue Tomas Vondra
• 19:15   Re: 8.4 optimization regression? Tom Lane

5 September 2011

• 01:20   Re: Query performance issue Jayadevan M
• 04:12   Sudden drop in DBb performance Gerhard Wohlgenannt
• 04:12   Embedded VACUUM C Pond
• 04:28   Re: Sudden drop in DBb performance pasman pasmański
• 04:48   Re: Sudden drop in DBb performance Tomas Vondra
• 06:21   Re: Slow performance Kai Otto
• 06:27   Re: Embedded VACUUM Craig Ringer
• 07:35   Rather large LA Richard Shaw
• 07:50   Re: Rather large LA Craig Ringer
• 07:55   Re: Rather large LA Richard Shaw
• 08:17   Re: Rather large LA Craig Ringer
• 10:39   Re: Rather large LA Andy Colson
• 10:51   Re: Sudden drop in DBb performance Andy Colson
• 10:57   Re: Rather large LA Richard Shaw
• 11:15   Re: Sudden drop in DBb performance Tomas Vondra
• 11:39   Re: Sudden drop in DBb performance Tomas Vondra
• 12:14   Re: Rather large LA pasman pasmański
• 12:17   Re: Sudden drop in DBb performance Andy Colson
• 13:18   Re: Sudden drop in DBb performance Gerhard Wohlgenannt
• 13:18   Re: Sudden drop in DBb performance Gerhard Wohlgenannt
• 13:18   Re: Sudden drop in DBb performance Gerhard Wohlgenannt
• 13:47   Re: Rather large LA Andy Colson
• 14:24   Re: Rather large LA Andres Freund
• 15:46   Re: Sudden drop in DBb performance Scott Marlowe
• 16:07   Re: Sudden drop in DBb performance Andy Colson
• 17:05   Re: Rather large LA Alan Hodgson
• 17:23   Re: Rather large LA Scott Marlowe
• 17:39   Re: Sudden drop in DBb performance Tomas Vondra
• 19:36   Re: Rather large LA Richard Shaw
• 20:31   Re: Rather large LA Scott Marlowe

6 September 2011

• 00:30   Re: Query performance issue Jayadevan
• 06:04   Re: Sudden drop in DBb performance Tomas Vondra
• 10:46   Fwd: Summaries on SSD usage? Stefan Keller
• 11:07   Re: Fwd: Summaries on SSD usage? Shaun Thomas
• 11:20   Re: Rather large LA Richard Shaw
• 11:51   Re: Rather large LA Andres Freund
• 13:10   Re: Sudden drop in DBb performance Gerhard Wohlgenannt
• 13:10   Re: Sudden drop in DBb performance Gerhard Wohlgenannt
• 13:10   Re: Sudden drop in DBb performance Gerhard Wohlgenannt
• 13:10   Re: Sudden drop in DBb performance Gerhard Wohlgenannt
• 13:50   Re: Sudden drop in DBb performance Tomas Vondra
• 15:58   how fast index works? Anibal David Acosta
• 16:08   Re: Rather large LA Alan Hodgson
• 16:11   Re: Rather large LA Richard Shaw
• 16:16   Re: how fast index works? Craig James
• 16:22   Re: Rather large LA Alan Hodgson
• 16:35   Re: Rather large LA Richard Shaw
• 16:48   Re: Rather large LA Alan Hodgson
• 17:28   Re: how fast index works? Anibal David Acosta
• 18:01   Re: Rather large LA Damon Snyder
• 22:03   Re: how fast index works? Craig Ringer

7 September 2011

• 03:54   Re: Rather large LA Vitalii Tymchyshyn

8 September 2011

• 09:56   how delete/insert/update affects select performace? Anibal David Acosta
• 11:10   Re: how delete/insert/update affects select performace? Tomas Vondra
• 11:51   Re: how delete/insert/update affects select performace? Kevin Grittner
• 13:39   Re: how delete/insert/update affects select performace? Anibal David Acosta
• 14:00   Re: how delete/insert/update affects select performace? Kevin Grittner
• 14:36   Re: how fast index works? Merlin Moncure
• 16:33   Re: how delete/insert/update affects select performace? Anibal David Acosta
• 16:52   Re: how delete/insert/update affects select performace? Kevin Grittner
• 18:04   Re: how fast index works? Hany ABOU-GHOURY
• 18:30   Re: how fast index works? Kevin Grittner
• 22:28   Re: how delete/insert/update affects select performace? Greg Smith
• 23:42   Re: how delete/insert/update affects select performace? Anibal David Acosta

9 September 2011

• 09:04   Re: how delete/insert/update affects select performace? Kevin Grittner
• 13:34   Migrated from 8.3 to 9.0 - need to update config (re-post) Carlo Stonebanks
• 14:55   PostgreSQL insights: does it use DMA? Antonio Rodriges
• 15:16   Re: Migrated from 8.3 to 9.0 - need to update config (re-post) Kevin Grittner
• 16:37   Re: PostgreSQL insights: does it use DMA? Scott Marlowe
• 16:58   Re: PostgreSQL insights: does it use DMA? Antonio Rodriges
• 17:03   Re: PostgreSQL insights: does it use DMA? pasman pasmański
• 17:30   Re: PostgreSQL insights: does it use DMA? Kevin Grittner
• 18:05   Re: Migrated from 8.3 to 9.0 - need to update config (re-post) Claudio Freire
• 18:05   Re: Migrated from 8.3 to 9.0 - need to update config (re-post) Claudio Freire
• 18:09   Re: Migrated from 8.3 to 9.0 - need to update config (re-post) Kevin Grittner
• 18:10   Re: Migrated from 8.3 to 9.0 - need to update config (re-post) Kevin Grittner
• 21:00   Re: PostgreSQL insights: does it use DMA? Craig Ringer

10 September 2011

• 09:07   Re: PostgreSQL insights: does it use DMA? Antonio Rodriges
• 11:54   Re: Migrated from 8.3 to 9.0 - need to update config (re-post) Carlo Stonebanks
• 14:03   should i expected performance degradation over time Anibal David Acosta
• 14:20   Re: should i expected performance degradation over time Andy Colson
• 15:30   Re: should i expected performance degradation over time Scott Marlowe

11 September 2011

• 07:54   Databases optimization Hany ABOU-GHOURY
• 09:36   Postgres for a "data warehouse", 5-10 TB Igor Chudov
• 09:52   Re: Postgres for a "data warehouse", 5-10 TB Scott Marlowe
• 10:36   Re: Postgres for a "data warehouse", 5-10 TB pasman pasmański
• 11:00   Re: Postgres for a "data warehouse", 5-10 TB Igor Chudov
• 11:01   Re: Postgres for a "data warehouse", 5-10 TB Igor Chudov
• 11:16   Re: Postgres for a "data warehouse", 5-10 TB Claudio Freire
• 11:16   Re: Postgres for a "data warehouse", 5-10 TB Andy Colson
• 11:22   Re: Postgres for a "data warehouse", 5-10 TB Igor Chudov
• 11:23   Re: Postgres for a "data warehouse", 5-10 TB Andy Colson
• 11:27   Re: Postgres for a "data warehouse", 5-10 TB Claudio Freire
• 11:36   Re: Postgres for a "data warehouse", 5-10 TB Andy Colson
• 11:44   Re: Postgres for a "data warehouse", 5-10 TB Claudio Freire
• 14:02   Re: Postgres for a "data warehouse", 5-10 TB Marti Raudsepp
• 15:37   Re: Postgres for a "data warehouse", 5-10 TB Ogden
• 16:08   Re: Postgres for a "data warehouse", 5-10 TB J Sisson
• 16:30   Re: Postgres for a "data warehouse", 5-10 TB J Sisson
• 16:50   PostgreSQL performance tweaking on new hardware Ogden
• 17:10   Re: Postgres for a "data warehouse", 5-10 TB Scott Marlowe
• 17:16   Re: PostgreSQL performance tweaking on new hardware Scott Marlowe
• 19:22   Re: Databases optimization Maciek Sakrejda
• 19:44   RAID Controller (HP P400) beat by SW-RAID? Anthony Presley
• 19:49   Re: Databases optimization Hany ABOU-GHOURY
• 19:51   Re: RAID Controller (HP P400) beat by SW-RAID? Stephen Frost
• 20:01   Re: Postgres for a "data warehouse", 5-10 TB Stephen Frost
• 20:17   Re: Postgres for a "data warehouse", 5-10 TB Igor Chudov
• 20:19   Re: RAID Controller (HP P400) beat by SW-RAID? Tomas Vondra
• 20:50   Re: Postgres for a "data warehouse", 5-10 TB Claudio Freire
• 23:12   Re: RAID Controller (HP P400) beat by SW-RAID? Alan Hodgson
• 23:25   Re: RAID Controller (HP P400) beat by SW-RAID? Scott Marlowe
• 23:28   Re: Postgres for a "data warehouse", 5-10 TB Stephen Frost
• 23:29   Re: Postgres for a "data warehouse", 5-10 TB Stephen Frost
• 23:47   Re: Databases optimization J Sisson
• 23:56   Re: Postgres for a "data warehouse", 5-10 TB Ondrej Ivanič

12 September 2011

• 00:10   Re: RAID Controller (HP P400) beat by SW-RAID? mark
• 13:09   Re: Postgres for a "data warehouse", 5-10 TB Shaun Thomas
• 13:23   Re: Postgres for a "data warehouse", 5-10 TB Shaun Thomas
• 13:36   Re: Postgres for a "data warehouse", 5-10 TB Shaun Thomas
• 13:42   Re: RAID Controller (HP P400) beat by SW-RAID? Anthony Presley
• 13:56   Re: RAID Controller (HP P400) beat by SW-RAID? Anthony Presley
• 14:00   Re: Re: How to track number of connections and hosts to Postgres cluster Merlin Moncure
• 14:04   Re: Postgres for a "data warehouse", 5-10 TB Robert Klemme
• 14:16   Re: Postgres for a "data warehouse", 5-10 TB Robert Klemme
• 14:22   Re: Postgres for a "data warehouse", 5-10 TB Andy Colson
• 14:33   Allow sorts to use more available memory Robert Schnabel
• 14:47   Re: Allow sorts to use more available memory Andy Colson
• 14:58   Re: Allow sorts to use more available memory Shaun Thomas
• 15:02   Re: Allow sorts to use more available memory Andy Colson
• 15:24   Re: Allow sorts to use more available memory Robert Schnabel
• 15:56   Re: Allow sorts to use more available memory Andy Colson
• 16:03   Re: Allow sorts to use more available memory Andy Colson
• 16:08   Re: Postgres for a "data warehouse", 5-10 TB Scott Marlowe
• 16:12   Re: Allow sorts to use more available memory pasman pasmański
• 16:49   Re: Postgres for a "data warehouse", 5-10 TB Scott Marlowe
• 17:04   Re: Postgres for a "data warehouse", 5-10 TB Shaun Thomas
• 17:20   Re: Postgres for a "data warehouse", 5-10 TB Marti Raudsepp
• 17:44   Re: Postgres for a "data warehouse", 5-10 TB Scott Marlowe
• 17:55   Re: Postgres for a "data warehouse", 5-10 TB Shaun Thomas
• 17:59   Re: Allow sorts to use more available memory Scott Marlowe
• 18:00   Re: Postgres for a "data warehouse", 5-10 TB Scott Marlowe
• 18:26   Re: Postgres for a "data warehouse", 5-10 TB Robert Klemme
• 19:09   Re: Allow sorts to use more available memory Robert Schnabel
• 19:22   Re: Allow sorts to use more available memory Robert Schnabel
• 19:58   Re: Raid 5 vs Raid 10 Benchmarks Using bonnie++ david@lang.hm
• 20:20   Re: Sudden drop in DBb performance Marinos Yannikos
• 20:20   Re: Allow sorts to use more available memory Tom Lane
• 20:28   Re: Databases optimization Hany ABOU-GHOURY
• 21:08   Re: Raid 5 vs Raid 10 Benchmarks Using bonnie++ Aidan Van Dyk
• 21:48   Re: Raid 5 vs Raid 10 Benchmarks Using bonnie++ david@lang.hm
• 22:08   Re: RAID Controller (HP P400) beat by SW-RAID? Anthony Presley
• 22:13   Re: Allow sorts to use more available memory Stephen Frost
• 22:15   Re: Allow sorts to use more available memory Stephen Frost
• 23:15   Re: Raid 5 vs Raid 10 Benchmarks Using bonnie++ Aidan Van Dyk
• 23:49   Re: Databases optimization Anthony Presley

13 September 2011

• 00:14   Re: Databases optimization Hany ABOU-GHOURY
• 02:38   Re: RAID Controller (HP P400) beat by SW-RAID? Gavin Flower
• 03:32   Re: RAID Controller (HP P400) beat by SW-RAID? Arjen van der Meijden
• 08:56   PG 9.x prefers slower Hash Joins? Anthony Presley
• 12:45   Re: Postgres for a "data warehouse", 5-10 TB Marti Raudsepp
• 13:34   Re: Postgres for a "data warehouse", 5-10 TB Robert Klemme
• 15:09   Re: Postgres for a "data warehouse", 5-10 TB Marc Mamin
• 15:19   Re: Postgres for a "data warehouse", 5-10 TB Marti Raudsepp
• 15:39   Re: Postgres for a "data warehouse", 5-10 TB Igor Chudov
• 15:57   Re: Migrated from 8.3 to 9.0 - need to update config (re-post) Carlo Stonebanks
• 15:57   Re: Postgres for a "data warehouse", 5-10 TB Stefan Keller
• 16:21   raid array seek performance Samuel Gendler
• 16:27   Re: Postgres for a "data warehouse", 5-10 TB Scott Marlowe
• 17:23   Re: Postgres for a "data warehouse", 5-10 TB Robert Klemme
• 17:30   Re: Postgres for a "data warehouse", 5-10 TB Robert Klemme
• 17:34   Re: Postgres for a "data warehouse", 5-10 TB Kevin Grittner
• 17:59   Re: Postgres for a "data warehouse", 5-10 TB Gianni Ciolli
• 18:13   Re: Migrated from 8.3 to 9.0 - need to update config (re-post) Kevin Grittner
• 20:04   Hash index use presently(?) discouraged since 2005: revive or bury it? Stefan Keller
• 20:33   Re: raid array seek performance Samuel Gendler
• 21:04   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Peter Geoghegan
• 21:24   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Tom Lane
• 21:30   Re: RAID Controller (HP P400) beat by SW-RAID? Anthony Presley
• 22:27   Re: Migrated from 8.3 to 9.0 - need to update config (re-post) Carlo Stonebanks
• 22:52   Re: Migrated from 8.3 to 9.0 - need to update config (re-post) Craig Ringer
• 23:22   Re: Migrated from 8.3 to 9.0 - need to update config (re-post) Kevin Grittner

14 September 2011

• 03:40   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Stefan Keller
• 05:22   Re: RAID Controller (HP P400) beat by SW-RAID? Greg Smith
• 05:45   Re: raid array seek performance Greg Smith
• 05:59   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Heikki Linnakangas
• 06:04   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Heikki Linnakangas
• 06:49   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Leonardo Francalanci
• 10:09   Re: cannot use multicolumn index MirrorX
• 10:18   Re: cannot use multicolumn index Grzegorz Jaśkiewicz
• 11:02   Re: cannot use multicolumn index MirrorX
• 11:15   Re: cannot use multicolumn index Tomas Vondra
• 12:14   Re: cannot use multicolumn index MirrorX
• 12:28   Re: cannot use multicolumn index Vitalii Tymchyshyn
• 13:05   Re: cannot use multicolumn index Tomas Vondra
• 15:19   Re: raid array seek performance Merlin Moncure
• 16:40   Re: Migrated from 8.3 to 9.0 - need to update config (re-post) Igor Neyman
• 16:43   Re: Migrated from 8.3 to 9.0 - need to update config (re-post) ktm@rice.edu
• 20:03   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Stefan Keller
• 20:40   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Tom Lane

15 September 2011

• 01:27   Re: Migrated from 8.3 to 9.0 - need to update config (re-post) Carlo Stonebanks
• 06:43   Re: cannot use multicolumn index MirrorX
• 17:00   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Merlin Moncure
• 17:28   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Claudio Freire
• 19:14   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Merlin Moncure
• 19:38   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Tom Lane
• 21:34   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Claudio Freire
• 22:00   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Merlin Moncure
• 22:05   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Claudio Freire

16 September 2011

• 03:15   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Merlin Moncure
• 11:50   Odd misprediction Claudio Freire
• 20:15   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Stefan Keller
• 22:06   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Tomas Vondra
• 23:41   Re: Odd misprediction Marti Raudsepp

17 September 2011

• 17:01   PostgreSQL-related topics of theses and seminary works sought (Was: Hash index use presently(?) discouraged...) Stefan Keller
• 17:22   Re: PG 9.x prefers slower Hash Joins? Jeff Janes
• 18:48   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Jeff Janes
• 19:11   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Jeff Janes
• 19:15   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Merlin Moncure
• 19:29   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Jeff Janes

18 September 2011

• 11:59   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Stefan Keller
• 12:17   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Kevin Grittner
• 16:32   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Stefan Keller
• 16:45   What about implementing a bitmap index? Any use cases? Stefan Keller
• 17:06   Re: What about implementing a bitmap index? Any use cases? Peter Geoghegan
• 17:19   Index containing records instead of pointers to the data? Stefan Keller
• 17:22   Re: Index containing records instead of pointers to the data? Thom Brown
• 22:13   Re: Index containing records instead of pointers to the data? Craig James
• 22:17   How to make hash indexes fast Craig James
• 22:25   Re: How to make hash indexes fast Ondrej Ivanič
• 22:27   Re: How to make hash indexes fast Claudio Freire
• 23:14   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Jeff Janes
• 23:27   cannot use multicolumn index MirrorX
• 23:27   Constraint exclusion on UNION ALL subqueries with WHERE conditions Gunnlaugur Þór Briem
• 23:37   Re: cannot use multicolumn index Scott Marlowe
• 23:39   Re: cannot use multicolumn index Scott Marlowe
• 23:58   Re: How to make hash indexes fast Jeff Janes

19 September 2011

• 00:59   Re: Constraint exclusion on UNION ALL subqueries with WHERE conditions Tom Lane
• 06:37   Re: PostgreSQL-related topics of theses and seminary works sought (Was: Hash index use presently(?) discouraged...) Vitalii Tymchyshyn
• 07:33   Re: PostgreSQL-related topics of theses and seminary works sought (Was: Hash index use presently(?) discouraged...) Thomas Kellerer
• 08:44   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Robert Klemme
• 08:57   Re: PostgreSQL-related topics of theses and seminary works sought (Was: Hash index use presently(?) discouraged...) Cédric Villemain
• 09:28   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Thomas Kellerer
• 10:06   Re: PostgreSQL-related topics of theses and seminary works sought (Was: Hash index use presently(?) discouraged...) Vitalii Tymchyshyn
• 10:25   Re: PostgreSQL-related topics of theses and seminary works sought (Was: Hash index use presently(?) discouraged...) Ivan Voras
• 11:04   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Merlin Moncure
• 12:20   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Robert Klemme
• 12:29   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Vitalii Tymchyshyn
• 12:35   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Tom Lane
• 12:54   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Vitalii Tymchyshyn
• 13:14   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Claudio Freire
• 13:15   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Jeff Janes
• 15:43   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Merlin Moncure
• 15:53   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Claudio Freire
• 19:12   Postgres INSERT performance and scalability Igor Chudov
• 20:32   Re: Postgres INSERT performance and scalability Scott Marlowe
• 21:53   Re: Postgres INSERT performance and scalability Stephen Frost
• 22:12   Re: Postgres INSERT performance and scalability Igor Chudov
• 22:15   Re: Postgres INSERT performance and scalability Stephen Frost
• 22:29   Re: Postgres INSERT performance and scalability Jon Nelson
• 22:32   Re: Postgres INSERT performance and scalability Stephen Frost

20 September 2011

• 01:28   where is max_fsm_pages in PG9.0? Anibal David Acosta
• 01:49   Re: where is max_fsm_pages in PG9.0? Scott Marlowe
• 02:05   Re: Postgres INSERT performance and scalability Craig Ringer
• 13:11   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Merlin Moncure
• 13:22   : Performance Improvement Strategy Venkat Balaji
• 13:25   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Tom Lane
• 14:59   Re: : Performance Improvement Strategy Marcin Mirosław
• 15:09   Re: : Performance Improvement Strategy Josh Berkus
• 19:05   Re: : Performance Improvement Strategy Mark Kirkwood
• 19:10   Re: : Performance Improvement Strategy Mark Kirkwood
• 20:27   Prepared statements and suboptimal plans Royce Ausburn
• 20:39   Re: Prepared statements and suboptimal plans Craig Ringer
• 21:20   Re: Prepared statements and suboptimal plans Royce Ausburn
• 21:36   Re: Prepared statements and suboptimal plans Tom Lane
• 21:43   Re: Prepared statements and suboptimal plans Andy Lester
• 22:00   Re: Prepared statements and suboptimal plans Tom Lane
• 23:36   Re: Prepared statements and suboptimal plans Stephen Frost
• 23:38   Re: Prepared statements and suboptimal plans Stephen Frost

21 September 2011

• 00:43   Re: Prepared statements and suboptimal plans Tom Lane
• 00:57   PG 9 adminstrations Hany ABOU-GHOURY
• 01:16   Re: PG 9 adminstrations Derrick Rice
• 01:29   Re: PG 9 adminstrations Hany ABOU-GHOURY
• 02:38   Re: : Performance Improvement Strategy Venkat Balaji
• 02:59   Re: : Performance Improvement Strategy Venkat Balaji
• 04:01   REINDEX not working for wastedspace AI Rumman
• 04:07   Re: REINDEX not working for wastedspace Guillaume Lelarge
• 04:07   Re: REINDEX not working for wastedspace Venkat Balaji
• 04:10   Re: REINDEX not working for wastedspace AI Rumman
• 09:21   Re: REINDEX not working for wastedspace Reid Thompson
• 09:43   Show_database_bloat reliability? [was: Re: REINDEX not working for wastedspace] Guillaume Cottenceau
• 09:48   Re: PG 9 adminstrations Shaun Thomas
• 10:03   Re: : Performance Improvement Strategy Shaun Thomas
• 10:30   Re: REINDEX not working for wastedspace Shaun Thomas
• 10:32   parámetros de postgres y linux en maquinas virtuales Hellmuth Vargas
• 10:57   Re: : Performance Improvement Strategy Kevin Grittner
• 11:13   Re: REINDEX not working for wastedspace Tom Lane
• 11:15   Re: REINDEX not working for wastedspace Andy Lester
• 11:19   Re: [PERFORM] parámetros de postgres y linux en maquinas virtuales Claudio Freire
• 11:21   Prepared statements and suboptimal plans Royce Ausburn
• 11:21   Slow query with self-join, group by, 100m rows Thomas Kappler
• 11:21   Re: Constraint exclusion on UNION ALL subqueries with WHERE conditions Gunnlaugur Þór Briem
• 11:50   Re: Prepared statements and suboptimal plans Grzegorz Jaśkiewicz
• 11:51   Re: Slow query with self-join, group by, 100m rows Robert Klemme
• 11:56   Re: REINDEX not working for wastedspace Shaun Thomas
• 12:02   Re: Slow query with self-join, group by, 100m rows Tom Lane
• 13:13   Re: Show_database_bloat reliability? [was: Re: REINDEX not working for wastedspace] Greg Smith
• 13:14   Re: : Performance Improvement Strategy Venkat Balaji
• 13:20   Re: REINDEX not working for wastedspace Venkat Balaji
• 13:30   Re: REINDEX not working for wastedspace Shaun Thomas
• 13:39   Re: Prepared statements and suboptimal plans Merlin Moncure
• 14:11   Re: Constraint exclusion on UNION ALL subqueries with WHERE conditions Tom Lane
• 14:58   Re: : Performance Improvement Strategy Greg Smith
• 15:26   Re: : Performance Improvement Strategy Venkat Balaji
• 15:41   Re: : Performance Improvement Strategy Kevin Grittner
• 21:59   Re: Prepared statements and suboptimal plans Royce Ausburn
• 21:59   Query optimization using order by and limit Michael Viscuso
• 22:48   Re: Query optimization using order by and limit Greg Smith
• 23:09   Re: Query optimization using order by and limit Tom Lane

22 September 2011

• 00:17   Re: Query optimization using order by and limit Michael Viscuso
• 00:23   Re: Query optimization using order by and limit Tom Lane
• 10:41   Re: Query optimization using order by and limit ktm@rice.edu
• 10:55   Re: Query optimization using order by and limit Michael Viscuso
• 11:53   Re: Query optimization using order by and limit Stephen Frost
• 13:40   Optimizing Trigram searches in PG 9.1 Jonathan Bartlett
• 19:55   Re: Query optimization using order by and limit Michael Viscuso
• 20:04   Re: Optimizing Trigram searches in PG 9.1 Dave Crooke
• 20:15   Re: Query optimization using order by and limit Stephen Frost
• 20:21   Re: Query optimization using order by and limit Michael Viscuso
• 22:32   Re: IN or EXISTS Jeff Davis

23 September 2011

• 12:39   Re: Constraint exclusion on UNION ALL subqueries with WHERE conditions Gunnlaugur Þór Briem
• 16:47   slow query on tables with new columns added. M. D.

24 September 2011

• 03:10   Re: slow query on tables with new columns added. Filip Rembiałkowski
• 03:49   [PERFORMANCE] Insights: fseek OR read_cluster? Antonio Rodriges
• 12:46   Re: DBT-5 & Postgres 9.0.3 Mark Wong

25 September 2011

• 19:22   Re: Query optimization using order by and limit Tom Lane
• 21:40   Re: Query optimization using order by and limit Stephen Frost
• 22:24   Re: Query optimization using order by and limit Tom Lane

26 September 2011

• 03:53   overzealous sorting? anthony.shipman@symstream.com
• 05:26   Re: [PERFORMANCE] Insights: fseek OR read_cluster? Craig Ringer
• 06:44   Re: overzealous sorting? Marc Cousin
• 09:51   Re: [PERFORMANCE] Insights: fseek OR read_cluster? Antonio Rodriges
• 12:41   [PERFORMANCE] Insights: fseek OR read_cluster? Antonio Rodriges
• 12:41   Performance Anomaly with "col in (A,B)" vs. "col = A OR col = B" ver. 9.0.3 Timothy Garnett
• 12:41   How to find record having % as part of data. Biswa
• 12:41   Re: How to find record having % as part of data. Biswa
• 14:08   Re: Performance Anomaly with "col in (A,B)" vs. "col = A OR col = B" ver. 9.0.3 Tom Lane
• 14:24   Re: Performance Anomaly with "col in (A,B)" vs. "col = A OR col = B" ver. 9.0.3 Craig James
• 14:35   Re: Performance Anomaly with "col in (A,B)" vs. "col = A OR col = B" ver. 9.0.3 Tom Lane
• 16:07   Re: [PERFORMANCE] Insights: fseek OR read_cluster? Marti Raudsepp
• 18:14   Re: slow query on tables with new columns added. M. D.
• 20:46   Re: slow query on tables with new columns added. Filip Rembiałkowski
• 21:09   Re: Performance Anomaly with "col in (A,B)" vs. "col = A OR col = B" ver. 9.0.3 Craig Ringer
• 21:39   Re: Performance Anomaly with "col in (A,B)" vs. "col = A OR col = B" ver. 9.0.3 Tom Lane
• 23:45   Re: overzealous sorting? anthony.shipman@symstream.com

27 September 2011

• 00:19   postgres constraint triggers Maria L. Wilson
• 00:19   Re: Performance Anomaly with "col in (A,B)" vs. "col = A OR col = B" ver. 9.0.3 Timothy Garnett
• 00:55   Ineffective autovacuum Royce Ausburn
• 01:21   Re: Ineffective autovacuum Tom Lane
• 02:00   Re: postgres constraint triggers Ben Chobot
• 02:08   Re: Ineffective autovacuum Royce Ausburn
• 03:14   Re: Performance Anomaly with "col in (A,B)" vs. "col = A OR col = B" ver. 9.0.3 Samuel Gendler
• 05:54   Re: overzealous sorting? Marc Cousin
• 06:05   Re: overzealous sorting? anthony.shipman@symstream.com
• 06:29   Re: overzealous sorting? Mark Kirkwood
• 07:57   Re: Ineffective autovacuum Marti Raudsepp
• 09:29   Re: : Performance Improvement Strategy Venkat Balaji
• 09:31   Re: : Performance Improvement Strategy Venkat Balaji
• 09:36   : Tracking Full Table Scans Venkat Balaji
• 10:49   Re: Ineffective autovacuum Tom Lane
• 11:00   Re: Ineffective autovacuum Scott Marlowe
• 11:27   Re: Ineffective autovacuum Royce Ausburn
• 11:32   Re: : Tracking Full Table Scans Kevin Grittner
• 12:00   Re: overzealous sorting? Marc Cousin
• 13:12   Re: [PERFORMANCE] Insights: fseek OR read_cluster? Antonio Rodriges
• 13:35   Re: : Tracking Full Table Scans Venkat Balaji
• 13:44   PostgreSQL-9.0 Monitoring System to improve performance Venkat Balaji
• 13:49   Re: : Tracking Full Table Scans Venkat Balaji
• 13:49   Re: Performance Anomaly with "col in (A,B)" vs. "col = A OR col = B" ver. 9.0.3 Timothy Garnett
• 13:50   Re: Performance Anomaly with "col in (A,B)" vs. "col = A OR col = B" ver. 9.0.3 Timothy Garnett
• 14:15   Re: : Tracking Full Table Scans Kevin Grittner
• 21:37   Re: postgres constraint triggers Craig Ringer
• 21:55   Re: : Tracking Full Table Scans Craig Ringer

28 September 2011

• 02:13   Re: overzealous sorting? anthony.shipman@symstream.com
• 03:09   Re: : Tracking Full Table Scans Venkat Balaji
• 03:13   Re: : Tracking Full Table Scans Venkat Balaji
• 04:10   Re: PostgreSQL-9.0 Monitoring System to improve performance Greg Smith
• 09:21   Re: PostgreSQL-9.0 Monitoring System to improve performance Tomas Vondra
• 14:07   : Create table taking time Venkat Balaji
• 14:17   : Looking for PG Books Venkat Balaji
• 15:54   Re: : Looking for PG Books Josh Berkus
• 15:55   Re: : Create table taking time Josh Berkus
• 16:15   Re: : Create table taking time Scott Marlowe

29 September 2011

• 05:02   Re: : Create table taking time Venkat Balaji
• 09:43   Select se bloquea Numael Vacca Duran
• 10:49   Re: : Create table taking time Kevin Grittner
• 11:21   Re: Select se bloquea Claudio Freire
• 11:30   the number of child tables --table partitioning Jian Shi
• 12:09   Re: the number of child tables --table partitioning Kevin Grittner
• 13:52   Re: : Create table taking time Merlin Moncure
• 18:12   Re: the number of child tables --table partitioning Ondrej Ivanič
• 21:39   Shortcutting too-large offsets? Josh Berkus
• 23:32   array_except -- Find elements that are not common to both arrays bricklen

30 September 2011

• 00:12   Re: postgres constraint triggers Ben Chobot
• 00:14   Re: array_except -- Find elements that are not common to both arrays Merlin Moncure
• 00:27   Re: array_except -- Find elements that are not common to both arrays bricklen
• 02:22   Re: : Create table taking time Venkat Balaji
• 07:30   Re: PostgreSQL-9.0 Monitoring System to improve performance Venkat Balaji
• 07:32   Re: PostgreSQL-9.0 Monitoring System to improve performance Venkat Balaji
• 08:20   Re: : Create table taking time Venkat Balaji
• 08:54   Re: PostgreSQL-9.0 Monitoring System to improve performance Gregg Jaskiewicz
• 09:23   Re: array_except -- Find elements that are not common to both arrays Vitalii Tymchyshyn
• 11:28   Re: array_except -- Find elements that are not common to both arrays bricklen
• 11:37   Re: Shortcutting too-large offsets? Tom Lane
• 12:08   Re: Shortcutting too-large offsets? pasman pasmański
• 14:01   Re: the number of child tables --table partitioning Merlin Moncure
• 14:13   Re: the number of child tables --table partitioning alexandre - aldeia digital
• 15:08   Re: array_except -- Find elements that are not common to both arrays bricklen
• 15:44   Re: Shortcutting too-large offsets? Josh Berkus
• 15:56   Re: Shortcutting too-large offsets? Tom Lane
• 17:15   Re: array_except -- Find elements that are not common to both arrays Ben Chobot
• 18:12   Re: array_except -- Find elements that are not common to both arrays Merlin Moncure
• 18:34   Re: PostgreSQL-9.0 Monitoring System to improve performance Bobby Dewitt
• 20:44   Re: array_except -- Find elements that are not common to both arrays bricklen