Mailing lists [pgsql-performance]

1 March 2010

• 02:16   Re: [HACKERS] full text search index scan query plan changed in 8.4.2? Chris
• 05:46   Autovacuum Tuning advice Plugge, Joe R.
• 06:27   Re: Autovacuum Tuning advice Scott Marlowe
• 07:23   Re: Autovacuum Tuning advice Greg Williamson
• 11:46   Re: Autovacuum Tuning advice Plugge, Joe R.
• 11:51   Re: Autovacuum Tuning advice Grzegorz Jaśkiewicz
• 11:57   Query slowing down significantly?? Rainer Pruy
• 12:04   Re: Autovacuum Tuning advice Plugge, Joe R.
• 15:15   Re: Query slowing down significantly?? Tom Lane
• 16:48   Re: Query slowing down significantly?? Rainer Pruy
• 17:15   Re: Query slowing down significantly?? Tom Lane
• 17:49   Re: Query slowing down significantly?? Rainer Pruy
• 18:29   partition pruning Anj Adu
• 18:34   Re: Query slowing down significantly?? Yeb Havinga

2 March 2010

• 02:34   Re: SSD + RAID Bruce Momjian
• 02:35   Re: SSD + RAID Bruce Momjian
• 05:13   Re: SSD + RAID Greg Smith
• 07:38   Re: SSD + RAID Pierre C
• 15:18   Re: No hash join across partitioned tables? Robert Haas
• 15:21   Re: GiST index performance Robert Haas
• 15:23   Re: No hash join across partitioned tables? Tom Lane
• 15:23   Re: GiST index performance Robert Haas
• 15:27   Re: No hash join across partitioned tables? Grzegorz Jaśkiewicz
• 19:42   10K vs 15k rpm for analytics Francisco Reyes
• 19:52   Re: 10K vs 15k rpm for analytics Yeb Havinga
• 20:03   Re: 10K vs 15k rpm for analytics Greg Smith
• 20:05   Re: 10K vs 15k rpm for analytics Dave Crooke
• 20:12   Re: 10K vs 15k rpm for analytics Scott Marlowe
• 20:15   Re: 10K vs 15k rpm for analytics david@lang.hm
• 20:21   Re: 10K vs 15k rpm for analytics Scott Marlowe
• 20:31   Re: 10K vs 15k rpm for analytics Francisco Reyes
• 20:32   Re: 10K vs 15k rpm for analytics Francisco Reyes
• 20:35   Re: 10K vs 15k rpm for analytics Scott Marlowe
• 20:36   Re: 10K vs 15k rpm for analytics Francisco Reyes
• 20:44   Re: 10K vs 15k rpm for analytics Francisco Reyes
• 20:47   Re: 10K vs 15k rpm for analytics Scott Marlowe
• 21:37   Re: 10K vs 15k rpm for analytics Francisco Reyes
• 21:57   Re: 10K vs 15k rpm for analytics Francisco Reyes
• 21:58   Re: 10K vs 15k rpm for analytics david@lang.hm
• 22:00   Re: 10K vs 15k rpm for analytics Francisco Reyes
• 22:01   Re: Query slowing down significantly?? Kris Jurka
• 22:38   Re: 10K vs 15k rpm for analytics Francisco Reyes
• 22:44   Re: 10K vs 15k rpm for analytics Greg Smith
• 22:50   Re: 10K vs 15k rpm for analytics Greg Smith
• 22:56   Re: 10K vs 15k rpm for analytics Scott Marlowe
• 22:57   Re: 10K vs 15k rpm for analytics Greg Smith
• 23:36   Re: 10K vs 15k rpm for analytics Scott Marlowe

3 March 2010

• 00:04   Re: 10K vs 15k rpm for analytics Greg Smith
• 00:17   Re: GiST index performance Bruce Momjian
• 00:18   Re: 10K vs 15k rpm for analytics Scott Marlowe
• 01:20   Re: 10K vs 15k rpm for analytics Greg Smith
• 01:44   Re: 10K vs 15k rpm for analytics Francisco Reyes
• 02:27   Re: 10K vs 15k rpm for analytics Scott Marlowe
• 08:05   Re: 10K vs 15k rpm for analytics Yeb Havinga
• 08:41   Re: 10K vs 15k rpm for analytics Yeb Havinga
• 08:45   Re: 10K vs 15k rpm for analytics Yeb Havinga
• 09:39   Re: 10K vs 15k rpm for analytics Pierre C
• 12:52   Re: 10K vs 15k rpm for analytics Francisco Reyes
• 13:00   Re: 10K vs 15k rpm for analytics Greg Smith
• 13:24   Re: 10K vs 15k rpm for analytics Yeb Havinga
• 14:16   Re: SSD + RAID Ron Mayer
• 16:09   Re: dbt2 performance Robert Haas
• 16:12   Re: Estimation issue with partitioned tables Robert Haas
• 17:33   Re: 10K vs 15k rpm for analytics Scott Marlowe
• 18:34   Re: bgwriter, checkpoints, curious (seeing delays) Robert Haas
• 20:46   Re: Estimation issue with partitioned tables Josh Berkus

4 March 2010

• 01:07   Re: Estimation issue with partitioned tables Robert Haas
• 21:40   Re: partition pruning Robert Haas

7 March 2010

• 16:57   Re: Estimation issue with partitioned tables Josh Berkus

8 March 2010

• 13:42   Testing FusionIO Devrim GÜNDÜZ
• 13:56   Re: Testing FusionIO Yeb Havinga
• 13:59   Re: Testing FusionIO Łukasz Jagiełło
• 16:25   prepared statements and partitioning (partition elimination not working) Kevin Kempter
• 16:29   Re: prepared statements and partitioning (partition elimination not working) Kenneth Marshall
• 16:39   Re: Testing FusionIO Ben Chobot
• 17:28   Paritioning vs. caching Konrad Garus
• 18:27   Re: Paritioning vs. caching Anj Adu
• 19:30   Re: Paritioning vs. caching Josh Berkus
• 19:50   Re: Testing FusionIO Greg Smith
• 20:10   Re: Testing FusionIO Ben Chobot
• 20:56   Re: Estimation issue with partitioned tables Robert Haas
• 21:39   Re: partition pruning Simon Riggs
• 22:51   Re: 10K vs 15k rpm for analytics Scott Carey
• 23:02   Re: 10K vs 15k rpm for analytics Scott Carey

9 March 2010

• 06:01   Re: 10K vs 15k rpm for analytics Greg Smith
• 08:39   Out of shared memory in postgres 8.4.2 and locks Vidhya Bondre
• 11:35   Re: Out of shared memory in postgres 8.4.2 and locks Merlin Moncure
• 11:46   Re: Extracting superlatives - SQL design philosophy Merlin Moncure
• 12:27   Re: Out of shared memory in postgres 8.4.2 and locks Vidhya Bondre
• 12:49   Re: 10K vs 15k rpm for analytics Pierre C
• 13:30   Re: 10K vs 15k rpm for analytics Ing. Marcos Ortiz Valmaseda
• 13:50   Re: 10K vs 15k rpm for analytics david@lang.hm
• 13:50   Re: 10K vs 15k rpm for analytics Kevin Grittner
• 14:03   Re: Out of shared memory in postgres 8.4.2 and locks Merlin Moncure
• 14:48   Re: 10K vs 15k rpm for analytics Michael Stone
• 15:13   Re: Extracting superlatives - SQL design philosophy Dave Crooke
• 18:23   Deleting Large Objects John KEA
• 18:44   Re: Deleting Large Objects Kevin Grittner
• 23:40   Re: 10K vs 15k rpm for analytics Scott Carey
• 23:48   Re: 10K vs 15k rpm for analytics Scott Carey

10 March 2010

• 01:33   Re: 10K vs 15k rpm for analytics Greg Smith
• 07:51   Strange workaround for slow query sverhagen@wps-nl.com
• 08:07   Strange workaround for slow query Kees van Dieren
• 08:11   Re: Strange workaround for slow query Yeb Havinga
• 08:27   Re: Strange workaround for slow query sverhagen@wps-nl.com
• 09:11   Re: Strange workaround for slow query Yeb Havinga
• 09:35   Re: Strange workaround for slow query sverhagen@wps-nl.com
• 10:05   Re: Strange workaround for slow query Yeb Havinga
• 12:33   Bad query plan inside EXISTS clause Benoit Delbosc
• 12:41   Re: Bad query plan inside EXISTS clause Kenneth Marshall
• 12:43   Re: Bad query plan inside EXISTS clause Grzegorz Jaśkiewicz
• 12:51   Re: Bad query plan inside EXISTS clause Yeb Havinga
• 13:05   Re: Bad query plan inside EXISTS clause Yeb Havinga
• 14:42   Re: Bad query plan inside EXISTS clause Benoit Delbosc
• 14:44   Re: Bad query plan inside EXISTS clause Tom Lane
• 15:35   Re: Strange workaround for slow query Harald Fuchs
• 15:59   Re: Bad query plan inside EXISTS clause Benoit Delbosc
• 20:55   Re: Strange workaround for slow query Robert Haas
• 21:37   Re: Strange workaround for slow query Tom Lane
• 21:41   Re: Strange workaround for slow query Robert Haas

11 March 2010

• 01:22   shared_buffers advice Paul McGarry
• 04:17   Re: shared_buffers advice Ben Chobot
• 05:56   How to SELECT Angayarkanni
• 06:14   Re: How to SELECT A. Kretschmer
• 06:15   Re: How to SELECT Dave Crooke
• 06:23   Re: How to SELECT Angayarkanni
• 07:40   Re: shared_buffers advice Greg Smith

12 March 2010

• 14:24   Is DBLINK transactional elias ghanem
• 16:07   Re: Is DBLINK transactional Merlin Moncure
• 20:54   Re: Is DBLINK transactional Jeff Davis

13 March 2010

• 11:11   Re: Is DBLINK transactional Craig Ringer
• 20:18   Deleting bytea, autovacuum, and 8.2/8.4 differences fkater@googlemail.com

14 March 2010

• 02:05   Re: Deleting bytea, autovacuum, and 8.2/8.4 differences Dave Crooke
• 08:07   pg_dump far too slow David Newall
• 16:31   Re: Deleting bytea, autovacuum, and 8.2/8.4 differences fkater@googlemail.com
• 20:22   Re: pg_dump far too slow Tom Lane
• 23:57   default_statistics_target Carlo Stonebanks

15 March 2010

• 08:20   Updated benchmarking category on the wiki Greg Smith
• 08:33   Re: default_statistics_target Albe Laurenz
• 13:18   Re: default_statistics_target Greg Smith
• 13:54   Re: Deleting bytea, autovacuum, and 8.2/8.4 differences VJK
• 14:02   Re: Deleting bytea, autovacuum, and 8.2/8.4 differences Kevin Grittner
• 14:12   Re: Deleting bytea, autovacuum, and 8.2/8.4 differences Kevin Grittner
• 14:43   Re: Deleting bytea, autovacuum, and 8.2/8.4 differences Greg Smith
• 14:46   Re: Deleting bytea, autovacuum, and 8.2/8.4 differences VJK
• 14:53   Re: Deleting bytea, autovacuum, and 8.2/8.4 differences Tom Lane
• 15:26   Re: Deleting bytea, autovacuum, and 8.2/8.4 differences Tom Lane
• 15:28   Re: Deleting bytea, autovacuum, and 8.2/8.4 differences VJK
• 15:34   Re: Deleting bytea, autovacuum, and 8.2/8.4 differences Matthew Wakeling
• 16:50   Re: GiST index performance Matthew Wakeling
• 16:56   Re: Deleting bytea, autovacuum, and 8.2/8.4 differences VJK
• 18:35   Re: shared_buffers advice Scott Carey
• 20:40   Strange workaround for slow query Kees van Dieren
• 20:40   shared_buffers advice Paul McGarry
• 20:42   Re: shared_buffers advice Paul McGarry
• 20:43   [offtopic] Problems subscribing to Postgres mailing lists Ognjen Blagojevic
• 20:44   Re: Is DBLINK transactional Hannu Krosing
• 21:13   Re: shared_buffers advice Scott Marlowe

16 March 2010

• 01:53   Re: pg_dump far too slow Robert Haas
• 01:59   Re: GiST index performance Robert Haas
• 03:05   Re: pg_dump far too slow Dave Crooke
• 05:18   Re: shared_buffers advice Dave Crooke
• 07:28   Re: shared_buffers advice Greg Smith
• 10:57   Re: Is DBLINK transactional Chris Browne
• 11:28   Re: shared_buffers advice Pierre C
• 13:26   Re: shared_buffers advice Nikolas Everett
• 13:52   Re: shared_buffers advice Pierre C
• 14:31   Re: shared_buffers advice Tom Lane
• 14:52   Re: shared_buffers advice Greg Stark
• 14:54   Re: shared_buffers advice Greg Stark
• 15:56   Postgres DB maintainenance - vacuum and reindex Meena_Ramkumar
• 17:01   Re: GiST index performance Yeb Havinga
• 17:08   Re: Postgres DB maintainenance - vacuum and reindex Scott Marlowe
• 17:11   Re: Postgres DB maintainenance - vacuum and reindex Ben Chobot
• 17:24   Re: Postgres DB maintainenance - vacuum and reindex Ing. Marcos Ortiz Valmaseda
• 20:54   Re: shared_buffers advice Greg Smith
• 20:56   Re: shared_buffers advice Greg Smith
• 21:34   Re: shared_buffers advice Alvaro Herrera
• 21:39   Re: shared_buffers advice Tom Lane
• 21:49   Re: shared_buffers advice Alvaro Herrera
• 21:58   Re: shared_buffers advice Tom Lane
• 22:21   Re: shared_buffers advice Alvaro Herrera
• 22:25   Re: shared_buffers advice Tom Lane
• 22:29   Re: shared_buffers advice Alvaro Herrera

17 March 2010

• 00:28   Re: shared_buffers advice Greg Smith
• 00:28   Block at a time ... Dave Crooke
• 00:43   Re: Block at a time ... Alvaro Herrera
• 01:14   Building multiple indexes concurrently Rob Wultsch
• 05:13   Re: Building multiple indexes concurrently Ben Chobot
• 07:36   Re: Block at a time ... Pierre C
• 09:26   Re: GiST index performance Yeb Havinga
• 09:52   Re: Block at a time ... Greg Stark
• 10:11   Re: Building multiple indexes concurrently Greg Smith
• 12:31   Re: Testing FusionIO Devrim GÜNDÜZ
• 13:03   Re: Testing FusionIO Brad Nicholson
• 13:18   Re: Testing FusionIO Brad Nicholson
• 14:27   Re: Block at a time ... Tom Lane
• 14:31   Re: Building multiple indexes concurrently Tom Lane
• 14:42   Re: Testing FusionIO Brad Nicholson
• 15:07   Re: Building multiple indexes concurrently Rob Wultsch
• 15:08   Fwd: shared_buffers advice VJK
• 15:16   Re: Block at a time ... Dave Crooke
• 16:47   Re: Block at a time ... Craig James
• 17:02   Re: Block at a time ... Bob Lunney
• 18:45   Re: Building multiple indexes concurrently Greg Smith
• 19:01   Re: Testing FusionIO Justin Pitts
• 19:01   Re: Testing FusionIO Justin Pitts
• 19:01   Re: Testing FusionIO Justin Pitts
• 20:02   Re: Building multiple indexes concurrently Andres Freund
• 20:06   Re: Testing FusionIO Kenny Gorman
• 20:07   Re: Testing FusionIO Brad Nicholson
• 20:14   Re: Testing FusionIO david@lang.hm
• 20:24   Re: Building multiple indexes concurrently Alvaro Herrera
• 20:49   Re: Building multiple indexes concurrently Greg Smith
• 21:45   Forcing index scan on query produces 16x faster Christian Brink
• 21:57   Re: Forcing index scan on query produces 16x faster David Wilson
• 22:04   Re: Forcing index scan on query produces 16x faster Tom Lane
• 22:54   Re: Testing FusionIO Ben Chobot

18 March 2010

• 01:18   Re: Forcing index scan on query produces 16x faster Eger, Patrick
• 10:29   Re: shared_buffers advice Dimitri Fontaine
• 12:15   Re: pg_dump far too slow Matthew Wakeling
• 14:31   mysql to postgresql, performance questions Corin
• 14:51   Re: mysql to postgresql, performance questions tv@fuzzy.cz
• 14:57   Re: mysql to postgresql, performance questions Kenneth Marshall
• 15:06   Re: mysql to postgresql, performance questions Thom Brown
• 15:08   Re: mysql to postgresql, performance questions Grzegorz Jaśkiewicz
• 15:09   Re: mysql to postgresql, performance questions Stephen Frost
• 15:22   Re: shared_buffers advice Greg Smith
• 15:28   Re: mysql to postgresql, performance questions Magnus Hagander
• 15:50   Re: mysql to postgresql, performance questions Scott Marlowe
• 17:08   Re: mysql to postgresql, performance questions Arjen van der Meijden
• 20:10   Re: Building multiple indexes concurrently Hannu Krosing

19 March 2010

• 00:09   Re: Forcing index scan on query produces 16x faster Dave Crooke
• 00:32   Re: mysql to postgresql, performance questions Ivan Voras
• 09:09   Re: mysql to postgresql, performance questions Dimitri Fontaine
• 09:36   Re: shared_buffers advice Dimitri Fontaine
• 12:26   too complex query plan for not exists query and multicolumn indexes Corin
• 13:46   PG using index+filter instead only use index Alexandre de Arruda Paes
• 13:51   Re: mysql to postgresql, performance questions Scott Marlowe
• 13:59   Re: too complex query plan for not exists query and multicolumn indexes Kevin Grittner
• 16:31   Re: GiST index performance Yeb Havinga
• 17:38   Re: Building multiple indexes concurrently Andres Freund
• 17:39   Re: mysql to postgresql, performance questions Pierre C
• 18:21   Re: mysql to postgresql, performance questions Merlin Moncure
• 18:28   Re: too complex query plan for not exists query and multicolumn indexes Stephen Frost
• 19:13   Re: too complex query plan for not exists query and multicolumn indexes Dave Crooke
• 19:49   Re: PG using index+filter instead only use index Tom Lane
• 20:20   Re: GiST index performance Yeb Havinga
• 20:49   Re: GiST index performance Yeb Havinga
• 21:05   Re: PG using index+filter instead only use index Alexandre de Arruda Paes
• 21:13   Re: GiST index performance Kenneth Marshall

20 March 2010

• 02:16   Re: PG using index+filter instead only use index Tom Lane
• 04:50   pgbench installation Reydan Cankur
• 16:16   Re: GiST index performance Yeb Havinga

21 March 2010

• 03:56   Re: mysql to postgresql, performance questions Andy Colson
• 13:18   Re: pg_dump far too slow David Newall
• 13:57   Re: pg_dump far too slow Craig Ringer
• 14:33   Re: pg_dump far too slow Dave Crooke
• 15:39   Re: pg_dump far too slow Tom Lane
• 15:50   Re: pg_dump far too slow David Newall
• 17:04   GZIP of pre-zipped output Dave Crooke
• 18:04   Re: pg_dump far too slow Bob Lunney
• 22:43   Re: mysql to postgresql, performance questions Merlin Moncure

22 March 2010

• 01:14   Re: mysql to postgresql, performance questions Dave Crooke
• 02:47   Re: GZIP of pre-zipped output Craig Ringer
• 03:00   Re: GZIP of pre-zipped output Scott Marlowe
• 05:00   Re: pgbench installation Greg Smith
• 11:15   Re: mysql to postgresql, performance questions Merlin Moncure
• 11:20   Re: mysql to postgresql, performance questions Pierre C
• 11:48   Re: too complex query plan for not exists query and multicolumn indexes Matthew Wakeling
• 12:40   Re: too complex query plan for not exists query and multicolumn indexes Tom Lane
• 13:30   Re: GiST index performance Matthew Wakeling
• 14:02   Re: GiST index performance Yeb Havinga
• 14:24   Re: GiST index performance Matthew Wakeling
• 15:32   Re: mysql to postgresql, performance questions Dave Crooke
• 17:38   Re: Building multiple indexes concurrently Justin Pitts
• 17:39   Re: Building multiple indexes concurrently Hannu Krosing
• 17:39   Re: Building multiple indexes concurrently Justin Pitts
• 17:39   Re: too complex query plan for not exists query and multicolumn indexes Justin Graf
• 18:49   Re: Block at a time ... Scott Carey
• 19:09   PostgreSQL upgraded to 8.2 but forcing index scan on query produces faster Christian Brink
• 19:21   Re: PostgreSQL upgraded to 8.2 but forcing index scan on query produces faster Tom Lane
• 21:00   Re: Block at a time ... Pierre C
• 21:06   Re: Block at a time ... Dave Crooke
• 21:25   Re: Block at a time ... Greg Stark
• 22:28   Re: default_statistics_target Carlo Stonebanks
• 22:58   Got that new server, now it's time for config! Carlo Stonebanks
• 23:12   Re: PostgreSQL upgraded to 8.2 but forcing index scan on query produces faster Eger, Patrick
• 23:23   Re: Got that new server, now it's time for config! Dan Harris
• 23:46   Re: Block at a time ... Craig James

23 March 2010

• 04:12   Re: Got that new server, now it's time for config! Greg Smith
• 13:08   Re: Got that new server, now it's time for config! Scott Mead
• 19:16   Re: mysql to postgresql, performance questions Ross J. Reedstrom
• 19:22   Re: mysql to postgresql, performance questions Tom Lane
• 20:10   Re: mysql to postgresql, performance questions Scott Marlowe
• 21:00   Performance Tuning Large PL/PGSQL Stored Procedure Eliot Gable
• 21:38   Re: mysql to postgresql, performance questions Greg Smith
• 21:39   Re: mysql to postgresql, performance questions Ross J. Reedstrom
• 21:42   Re: [ADMIN] tuning auto vacuum for highly active tables Scott Marlowe
• 23:07   Re: mysql to postgresql, performance questions Dave Crooke
• 23:31   Re: mysql to postgresql, performance questions Scott Marlowe
• 23:35   Re: mysql to postgresql, performance questions Tom Lane
• 23:37   Re: mysql to postgresql, performance questions Dave Crooke

24 March 2010

• 00:03   Re: mysql to postgresql, performance questions Scott Marlowe
• 08:56   Re: mysql to postgresql, performance questions Yeb Havinga
• 08:57   Re: mysql to postgresql, performance questions Yeb Havinga
• 12:10   Re: mysql to postgresql, performance questions Greg Smith
• 15:58   Re: mysql to postgresql, performance questions Chris Browne
• 15:59   Re: mysql to postgresql, performance questions Chris Browne
• 16:07   Re: PostgreSQL upgraded to 8.2 but forcing index scan on query produces faster Christian Brink

25 March 2010

• 00:47   Re: Forcing index scan on query produces 16x faster Robert Haas
• 00:51   memory question Campbell, Lance
• 01:17   Re: Forcing index scan on query produces 16x faster Eger, Patrick
• 02:06   Re: memory question Scott Marlowe
• 02:17   Re: Forcing index scan on query produces 16x faster Robert Haas
• 06:28   Re: memory question Dave Crooke
• 10:35   Re: memory question Matthew Wakeling
• 15:01   Why Wal_buffer is 64KB Tadipathri Raghu
• 15:44   Re: default_statistics_target Robert Haas
• 16:06   Re: Why Wal_buffer is 64KB Brad Nicholson
• 17:16   Re: Why Wal_buffer is 64KB Jaime Casanova
• 18:20   Re: Why Wal_buffer is 64KB Pierre C
• 18:53   tuning auto vacuum for highly active tables Bhella Paramjeet-PFCW67
• 18:54   Re: mysql to postgresql, performance questions Hannu Krosing
• 20:14   Re: mysql to postgresql, performance questions James Mansion
• 20:24   Re: mysql to postgresql, performance questions Scott Marlowe
• 20:35   Re: mysql to postgresql, performance questions Pierre C
• 20:38   Re: mysql to postgresql, performance questions Scott Marlowe
• 21:25   Re: mysql to postgresql, performance questions Yeb Havinga
• 21:28   experiments in query optimization Faheem Mitha

26 March 2010

• 02:00   Re: Performance Tuning Large PL/PGSQL Stored Procedure Merlin Moncure
• 03:28   Re: Why Wal_buffer is 64KB Tadipathri Raghu
• 03:56   Re: Performance Tuning Large PL/PGSQL Stored Procedure Eliot Gable
• 04:49   good effective_io_concurrency for FusionIO drives? Richard Yen
• 12:08   Re: Performance Tuning Large PL/PGSQL Stored Procedure Merlin Moncure
• 12:18   Re: Performance Tuning Large PL/PGSQL Stored Procedure Richard Huxton
• 13:49   Re: Why Wal_buffer is 64KB Pierre C
• 14:00   Re: Why Wal_buffer is 64KB Scott Marlowe
• 23:57   why does swap not recover? Richard Yen

27 March 2010

• 00:06   Re: why does swap not recover? Scott Marlowe
• 00:07   Re: pg_dump far too slow Scott Carey
• 00:28   Re: Block at a time ... Scott Carey
• 00:29   Re: why does swap not recover? Scott Carey
• 00:32   Re: why does swap not recover? Craig James
• 13:05   Database size growing over time and leads to performance impact Gnanakumar
• 13:35   Re: Database size growing over time and leads to performance impact Andy Colson
• 13:41   Re: Database size growing over time and leads to performance impact Pierre C
• 20:06   Pgbench TPS Calculation Reydan Cankur

28 March 2010

• 06:52   Optimizer showing wrong rows in plan Tadipathri Raghu
• 06:56   Re: why does swap not recover? Richard Yen
• 07:02   Re: Optimizer showing wrong rows in plan Szymon Guz
• 07:11   Re: Optimizer showing wrong rows in plan Tadipathri Raghu
• 07:29   Re: Optimizer showing wrong rows in plan Szymon Guz
• 07:34   Re: Optimizer showing wrong rows in plan Tadipathri Raghu
• 09:07   Re: Optimizer showing wrong rows in plan Tadipathri Raghu
• 09:18   Re: Optimizer showing wrong rows in plan Frank Heikens
• 09:40   Re: Optimizer showing wrong rows in plan Gary Doades
• 16:27   Re: Optimizer showing wrong rows in plan Tom Lane
• 17:26   Re: Optimizer showing wrong rows in plan Jeremy Harris
• 17:37   Re: Optimizer showing wrong rows in plan Tom Lane
• 21:04   Re: Forcing index scan on query produces 16x faster Cédric Villemain

29 March 2010

• 04:22   Re: Database size growing over time and leads to performance impact Greg Smith
• 04:23   Re: Pgbench TPS Calculation Greg Smith
• 04:56   Re: Optimizer showing wrong rows in plan Tadipathri Raghu
• 06:01   Re: Why Wal_buffer is 64KB Tadipathri Raghu
• 06:45   Re: Why Wal_buffer is 64KB Scott Marlowe
• 07:06   Re: Why Wal_buffer is 64KB Tadipathri Raghu
• 11:18   Re: Optimizer showing wrong rows in plan Matthew Wakeling
• 12:25   Re: Optimizer showing wrong rows in plan raghavendra t
• 13:43   Re: Optimizer showing wrong rows in plan Nikolas Everett
• 15:04   How much memory is PostgreSQL using Campbell, Lance
• 16:50   Performance regarding LIKE searches randalls@bioinfo.wsu.edu
• 16:54   Re: How much memory is PostgreSQL using Greg Smith
• 17:00   Re: Performance regarding LIKE searches Tom Lane
• 17:19   Re: Performance regarding LIKE searches randalls@bioinfo.wsu.edu
• 17:36   Re: Performance regarding LIKE searches Andy Colson
• 18:02   Re: experiments in query optimization Robert Haas
• 18:32   Re: experiments in query optimization Faheem Mitha
• 19:56   Re: experiments in query optimization Robert Haas
• 20:22   Re: experiments in query optimization Faheem Mitha

30 March 2010

• 06:18   Re: why does swap not recover? Josh Berkus
• 09:32   REINDEXing database-wide daily Gnanakumar
• 09:35   Re: Performance regarding LIKE searches Matthew Wakeling
• 11:18   Re: Database size growing over time and leads to performance impact Gnanakumar
• 13:21   3ware vs. MegaRAID Ireneusz Pluta
• 13:50   Re: Database size growing over time and leads to performance impact Andy Colson
• 14:06   Re: REINDEXing database-wide daily Andy Colson
• 14:43   Re: Why Wal_buffer is 64KB Robert Haas
• 14:58   Re: why does swap not recover? Robert Haas
• 15:05   Re: REINDEXing database-wide daily Kevin Grittner
• 16:08   Re: experiments in query optimization Kevin Grittner
• 17:07   Re: [ADMIN] Database size growing over time and leads to performance impact Tomeh, Husam
• 17:08   Re: Database size growing over time and leads to performance impact Greg Smith
• 17:08   temp table "on commit delete rows": transaction overhead Artiom Makarov
• 17:08   transaction overhead at "on commit delete rows"; admin@gifts.ru
• 17:15   Re: experiments in query optimization Faheem Mitha
• 17:17   Re: 3ware vs. MegaRAID Matteo Beccati
• 17:29   Re: 3ware vs. MegaRAID Greg Smith
• 17:29   Re: experiments in query optimization Faheem Mitha
• 17:51   Re: temp table "on commit delete rows": transaction overhead Tom Lane
• 19:59   Re: experiments in query optimization Robert Haas

31 March 2010

• 04:25   query has huge variance in execution times Brian Cox
• 04:37   Re: query has huge variance in execution times David Wilson
• 09:30   Re: experiments in query optimization Matthew Wakeling
• 09:36   Re: experiments in query optimization Faheem Mitha
• 10:11   Re: experiments in query optimization Faheem Mitha
• 12:43   Re: 3ware vs. MegaRAID Matteo Beccati
• 14:23   Re: mysql to postgresql, performance questions Bruce Momjian
• 15:04   Re: experiments in query optimization Robert Haas
• 16:59   Re: 3ware vs. MegaRAID Francisco Reyes
• 18:40   Re: query has huge variance in execution times Brian Cox
• 18:46   Re: query has huge variance in execution times David Wilson
• 20:38   Re: Database size growing over time and leads to performance impact Scott Carey
• 20:47   Re: Database size growing over time and leads to performance impact Robert Haas
• 20:48   Re: Database size growing over time and leads to performance impact Alvaro Herrera
• 20:51   How to fast the REINDEX raghavendra t
• 21:03   Re: How to fast the REINDEX Kevin Grittner
• 21:34   Re: How to fast the REINDEX raghavendra t
• 21:40   Re: How to fast the REINDEX Kevin Grittner
• 21:47   Re: How to fast the REINDEX raghavendra t
• 21:52   Re: How to fast the REINDEX Kevin Grittner
• 22:01   Re: How to fast the REINDEX raghavendra t
• 22:11   Re: How to fast the REINDEX Kevin Grittner
• 22:25   Re: How to fast the REINDEX Jaime Casanova
• 22:57   Re: How to fast the REINDEX raghavendra t