Mailing lists [pgsql-performance]

1 September 2011

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

2 September 2011

• 04:15   Re: Summaries on SSD usage? Jesper Krogh
• 04:58   Re: Summaries on SSD usage? Scott Marlowe
• 05:46   Re: Re: How to track number of connections and hosts to Postgres cluster Venkat Balaji
• 06:42   Re: Re: How to track number of connections and hosts to Postgres cluster Scott Marlowe
• 14:30   Re: Summaries on SSD usage? Shaun Thomas
• 22:04   Re: Summaries on SSD usage? Stefan Keller

3 September 2011

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

4 September 2011

• 08:18   Re: Re: How to track number of connections and hosts to Postgres cluster Venkat Balaji
• 10:38   Re: Query performance issue Grzegorz Jaśkiewicz
• 14:31   Re: Query performance issue Kevin Grittner
• 15:18   Re: Query performance issue Tom Lane
• 18:06   Re: Query performance issue Jayadevan
• 20:18   Re: Query performance issue Tomas Vondra
• 22:15   Re: 8.4 optimization regression? Tom Lane

5 September 2011

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

6 September 2011

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

7 September 2011

• 01:03   Re: how fast index works? Craig Ringer
• 06:54   Re: Rather large LA Vitalii Tymchyshyn

8 September 2011

• 12:56   how delete/insert/update affects select performace? Anibal David Acosta
• 14:10   Re: how delete/insert/update affects select performace? Tomas Vondra
• 14:51   Re: how delete/insert/update affects select performace? Kevin Grittner
• 16:39   Re: how delete/insert/update affects select performace? Anibal David Acosta
• 17:00   Re: how delete/insert/update affects select performace? Kevin Grittner
• 17:36   Re: how fast index works? Merlin Moncure
• 19:33   Re: how delete/insert/update affects select performace? Anibal David Acosta
• 19:52   Re: how delete/insert/update affects select performace? Kevin Grittner
• 21:04   Re: how fast index works? Hany ABOU-GHOURY
• 21:30   Re: how fast index works? Kevin Grittner

9 September 2011

• 01:28   Re: how delete/insert/update affects select performace? Greg Smith
• 02:42   Re: how delete/insert/update affects select performace? Anibal David Acosta
• 12:04   Re: how delete/insert/update affects select performace? Kevin Grittner
• 16:34   Migrated from 8.3 to 9.0 - need to update config (re-post) Carlo Stonebanks
• 17:55   PostgreSQL insights: does it use DMA? Antonio Rodriges
• 18:16   Re: Migrated from 8.3 to 9.0 - need to update config (re-post) Kevin Grittner
• 19:37   Re: PostgreSQL insights: does it use DMA? Scott Marlowe
• 19:58   Re: PostgreSQL insights: does it use DMA? Antonio Rodriges
• 20:03   Re: PostgreSQL insights: does it use DMA? pasman pasmański
• 20:30   Re: PostgreSQL insights: does it use DMA? Kevin Grittner
• 21:05   Re: Migrated from 8.3 to 9.0 - need to update config (re-post) Claudio Freire
• 21:05   Re: Migrated from 8.3 to 9.0 - need to update config (re-post) Claudio Freire
• 21:09   Re: Migrated from 8.3 to 9.0 - need to update config (re-post) Kevin Grittner
• 21:10   Re: Migrated from 8.3 to 9.0 - need to update config (re-post) Kevin Grittner

10 September 2011

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

11 September 2011

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

12 September 2011

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

13 September 2011

• 00:08   Re: Raid 5 vs Raid 10 Benchmarks Using bonnie++ Aidan Van Dyk
• 00:48   Re: Raid 5 vs Raid 10 Benchmarks Using bonnie++ david@lang.hm
• 01:08   Re: RAID Controller (HP P400) beat by SW-RAID? Anthony Presley
• 01:13   Re: Allow sorts to use more available memory Stephen Frost
• 01:15   Re: Allow sorts to use more available memory Stephen Frost
• 02:15   Re: Raid 5 vs Raid 10 Benchmarks Using bonnie++ Aidan Van Dyk
• 02:49   Re: Databases optimization Anthony Presley
• 03:14   Re: Databases optimization Hany ABOU-GHOURY
• 05:38   Re: RAID Controller (HP P400) beat by SW-RAID? Gavin Flower
• 06:32   Re: RAID Controller (HP P400) beat by SW-RAID? Arjen van der Meijden
• 11:56   PG 9.x prefers slower Hash Joins? Anthony Presley
• 15:45   Re: Postgres for a "data warehouse", 5-10 TB Marti Raudsepp
• 16:34   Re: Postgres for a "data warehouse", 5-10 TB Robert Klemme
• 18:09   Re: Postgres for a "data warehouse", 5-10 TB Marc Mamin
• 18:19   Re: Postgres for a "data warehouse", 5-10 TB Marti Raudsepp
• 18:39   Re: Postgres for a "data warehouse", 5-10 TB Igor Chudov
• 18:57   Re: Migrated from 8.3 to 9.0 - need to update config (re-post) Carlo Stonebanks
• 18:57   Re: Postgres for a "data warehouse", 5-10 TB Stefan Keller
• 19:21   raid array seek performance Samuel Gendler
• 19:27   Re: Postgres for a "data warehouse", 5-10 TB Scott Marlowe
• 20:23   Re: Postgres for a "data warehouse", 5-10 TB Robert Klemme
• 20:30   Re: Postgres for a "data warehouse", 5-10 TB Robert Klemme
• 20:34   Re: Postgres for a "data warehouse", 5-10 TB Kevin Grittner
• 20:59   Re: Postgres for a "data warehouse", 5-10 TB Gianni Ciolli
• 21:13   Re: Migrated from 8.3 to 9.0 - need to update config (re-post) Kevin Grittner
• 23:04   Hash index use presently(?) discouraged since 2005: revive or bury it? Stefan Keller
• 23:33   Re: raid array seek performance Samuel Gendler

14 September 2011

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

15 September 2011

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

16 September 2011

• 00:34   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Claudio Freire
• 01:00   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Merlin Moncure
• 01:05   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Claudio Freire
• 06:15   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Merlin Moncure
• 14:50   Odd misprediction Claudio Freire
• 23:15   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Stefan Keller

17 September 2011

• 01:06   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Tomas Vondra
• 02:41   Re: Odd misprediction Marti Raudsepp
• 20:01   PostgreSQL-related topics of theses and seminary works sought (Was: Hash index use presently(?) discouraged...) Stefan Keller
• 20:22   Re: PG 9.x prefers slower Hash Joins? Jeff Janes
• 21:48   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Jeff Janes
• 22:11   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Jeff Janes
• 22:15   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Merlin Moncure
• 22:29   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Jeff Janes

18 September 2011

• 14:59   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Stefan Keller
• 15:17   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Kevin Grittner
• 19:32   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Stefan Keller
• 19:45   What about implementing a bitmap index? Any use cases? Stefan Keller
• 20:06   Re: What about implementing a bitmap index? Any use cases? Peter Geoghegan
• 20:19   Index containing records instead of pointers to the data? Stefan Keller
• 20:22   Re: Index containing records instead of pointers to the data? Thom Brown

19 September 2011

• 01:13   Re: Index containing records instead of pointers to the data? Craig James
• 01:17   How to make hash indexes fast Craig James
• 01:25   Re: How to make hash indexes fast Ondrej Ivanič
• 01:27   Re: How to make hash indexes fast Claudio Freire
• 02:14   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Jeff Janes
• 02:27   cannot use multicolumn index MirrorX
• 02:27   Constraint exclusion on UNION ALL subqueries with WHERE conditions Gunnlaugur Þór Briem
• 02:37   Re: cannot use multicolumn index Scott Marlowe
• 02:39   Re: cannot use multicolumn index Scott Marlowe
• 02:58   Re: How to make hash indexes fast Jeff Janes
• 03:59   Re: Constraint exclusion on UNION ALL subqueries with WHERE conditions Tom Lane
• 09:37   Re: PostgreSQL-related topics of theses and seminary works sought (Was: Hash index use presently(?) discouraged...) Vitalii Tymchyshyn
• 10:33   Re: PostgreSQL-related topics of theses and seminary works sought (Was: Hash index use presently(?) discouraged...) Thomas Kellerer
• 11:44   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Robert Klemme
• 11:57   Re: PostgreSQL-related topics of theses and seminary works sought (Was: Hash index use presently(?) discouraged...) Cédric Villemain
• 12:28   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Thomas Kellerer
• 13:06   Re: PostgreSQL-related topics of theses and seminary works sought (Was: Hash index use presently(?) discouraged...) Vitalii Tymchyshyn
• 13:25   Re: PostgreSQL-related topics of theses and seminary works sought (Was: Hash index use presently(?) discouraged...) Ivan Voras
• 14:04   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Merlin Moncure
• 15:20   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Robert Klemme
• 15:29   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Vitalii Tymchyshyn
• 15:35   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Tom Lane
• 15:54   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Vitalii Tymchyshyn
• 16:14   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Claudio Freire
• 16:15   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Jeff Janes
• 18:43   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Merlin Moncure
• 18:53   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Claudio Freire
• 22:12   Postgres INSERT performance and scalability Igor Chudov
• 23:32   Re: Postgres INSERT performance and scalability Scott Marlowe

20 September 2011

• 00:53   Re: Postgres INSERT performance and scalability Stephen Frost
• 01:12   Re: Postgres INSERT performance and scalability Igor Chudov
• 01:15   Re: Postgres INSERT performance and scalability Stephen Frost
• 01:29   Re: Postgres INSERT performance and scalability Jon Nelson
• 01:32   Re: Postgres INSERT performance and scalability Stephen Frost
• 04:28   where is max_fsm_pages in PG9.0? Anibal David Acosta
• 04:49   Re: where is max_fsm_pages in PG9.0? Scott Marlowe
• 05:05   Re: Postgres INSERT performance and scalability Craig Ringer
• 16:11   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Merlin Moncure
• 16:22   : Performance Improvement Strategy Venkat Balaji
• 16:25   Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Tom Lane
• 17:59   Re: : Performance Improvement Strategy Marcin Mirosław
• 18:09   Re: : Performance Improvement Strategy Josh Berkus
• 22:05   Re: : Performance Improvement Strategy Mark Kirkwood
• 22:10   Re: : Performance Improvement Strategy Mark Kirkwood
• 23:27   Prepared statements and suboptimal plans Royce Ausburn
• 23:39   Re: Prepared statements and suboptimal plans Craig Ringer

21 September 2011

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

22 September 2011

• 00:59   Re: Prepared statements and suboptimal plans Royce Ausburn
• 00:59   Query optimization using order by and limit Michael Viscuso
• 01:48   Re: Query optimization using order by and limit Greg Smith
• 02:09   Re: Query optimization using order by and limit Tom Lane
• 03:17   Re: Query optimization using order by and limit Michael Viscuso
• 03:23   Re: Query optimization using order by and limit Tom Lane
• 13:41   Re: Query optimization using order by and limit ktm@rice.edu
• 13:55   Re: Query optimization using order by and limit Michael Viscuso
• 14:53   Re: Query optimization using order by and limit Stephen Frost
• 16:40   Optimizing Trigram searches in PG 9.1 Jonathan Bartlett
• 22:55   Re: Query optimization using order by and limit Michael Viscuso
• 23:04   Re: Optimizing Trigram searches in PG 9.1 Dave Crooke
• 23:15   Re: Query optimization using order by and limit Stephen Frost
• 23:21   Re: Query optimization using order by and limit Michael Viscuso

23 September 2011

• 01:32   Re: IN or EXISTS Jeff Davis
• 15:39   Re: Constraint exclusion on UNION ALL subqueries with WHERE conditions Gunnlaugur Þór Briem
• 19:47   slow query on tables with new columns added. M. D.

24 September 2011

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

25 September 2011

• 22:22   Re: Query optimization using order by and limit Tom Lane

26 September 2011

• 00:40   Re: Query optimization using order by and limit Stephen Frost
• 01:24   Re: Query optimization using order by and limit Tom Lane
• 06:53   overzealous sorting? anthony.shipman@symstream.com
• 08:26   Re: [PERFORMANCE] Insights: fseek OR read_cluster? Craig Ringer
• 09:44   Re: overzealous sorting? Marc Cousin
• 12:51   Re: [PERFORMANCE] Insights: fseek OR read_cluster? Antonio Rodriges
• 15:41   [PERFORMANCE] Insights: fseek OR read_cluster? Antonio Rodriges
• 15:41   Performance Anomaly with "col in (A,B)" vs. "col = A OR col = B" ver. 9.0.3 Timothy Garnett
• 15:41   How to find record having % as part of data. Biswa
• 15:41   Re: How to find record having % as part of data. Biswa
• 17:08   Re: Performance Anomaly with "col in (A,B)" vs. "col = A OR col = B" ver. 9.0.3 Tom Lane
• 17:24   Re: Performance Anomaly with "col in (A,B)" vs. "col = A OR col = B" ver. 9.0.3 Craig James
• 17:35   Re: Performance Anomaly with "col in (A,B)" vs. "col = A OR col = B" ver. 9.0.3 Tom Lane
• 19:07   Re: [PERFORMANCE] Insights: fseek OR read_cluster? Marti Raudsepp
• 21:14   Re: slow query on tables with new columns added. M. D.
• 23:46   Re: slow query on tables with new columns added. Filip Rembiałkowski

27 September 2011

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

28 September 2011

• 00:37   Re: postgres constraint triggers Craig Ringer
• 00:55   Re: : Tracking Full Table Scans Craig Ringer
• 05:13   Re: overzealous sorting? anthony.shipman@symstream.com
• 06:09   Re: : Tracking Full Table Scans Venkat Balaji
• 06:13   Re: : Tracking Full Table Scans Venkat Balaji
• 07:10   Re: PostgreSQL-9.0 Monitoring System to improve performance Greg Smith
• 12:21   Re: PostgreSQL-9.0 Monitoring System to improve performance Tomas Vondra
• 17:07   : Create table taking time Venkat Balaji
• 17:17   : Looking for PG Books Venkat Balaji
• 18:54   Re: : Looking for PG Books Josh Berkus
• 18:55   Re: : Create table taking time Josh Berkus
• 19:15   Re: : Create table taking time Scott Marlowe

29 September 2011

• 08:02   Re: : Create table taking time Venkat Balaji
• 12:43   Select se bloquea Numael Vacca Duran
• 13:49   Re: : Create table taking time Kevin Grittner
• 14:21   Re: Select se bloquea Claudio Freire
• 14:30   the number of child tables --table partitioning Jian Shi
• 15:09   Re: the number of child tables --table partitioning Kevin Grittner
• 16:52   Re: : Create table taking time Merlin Moncure
• 21:12   Re: the number of child tables --table partitioning Ondrej Ivanič

30 September 2011

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