Mailing lists [pgsql-performance]

1 April 2012

• 02:20   Re: database slowdown while a lot of inserts occur Bob Lunney
• 20:25   TCP Overhead on Local Loopback Ofer Israeli
• 22:02   Re: TCP Overhead on Local Loopback Andy
• 23:49   Re: TCP Overhead on Local Loopback Rob Wultsch
• 23:55   Re: TCP Overhead on Local Loopback Andrew Dunstan

2 April 2012

• 00:29   Re: TCP Overhead on Local Loopback Claudio Freire
• 01:11   Re: TCP Overhead on Local Loopback Andrew Dunstan
• 07:14   Re: database slowdown while a lot of inserts occur Віталій Тимчишин
• 08:25   Re: TCP Overhead on Local Loopback Samuel Gendler
• 11:35   Re: TCP Overhead on Local Loopback Andrew Dunstan
• 16:51   Re: TCP Overhead on Local Loopback Jeff Janes

3 April 2012

• 12:21   H800 + md1200 Performance problem Cesar Martin
• 12:38   Re: H800 + md1200 Performance problem Mike DelNegro
• 12:59   Re: H800 + md1200 Performance problem Cesar Martin
• 13:11   Re: H800 + md1200 Performance problem Merlin Moncure
• 13:22   Re: H800 + md1200 Performance problem Tomas Vondra
• 14:21   Re: Performance of SQL Function versus View Robert Haas
• 14:30   Re: Performance of SQL Function versus View Andrew Dunstan
• 14:58   Re: ...WHERE TRUE" condition in union results in bad query pla Robert Haas
• 15:24   Re: TCP Overhead on Local Loopback Ofer Israeli
• 15:32   Re: H800 + md1200 Performance problem Scott Marlowe
• 15:34   Re: H800 + md1200 Performance problem Scott Marlowe
• 15:35   Re: ...WHERE TRUE" condition in union results in bad query pla Tom Lane
• 15:39   Re: TCP Overhead on Local Loopback Claudio Freire
• 15:42   Re: H800 + md1200 Performance problem Cesar Martin
• 15:50   Re: H800 + md1200 Performance problem Cesar Martin
• 15:52   Re: H800 + md1200 Performance problem Cesar Martin
• 16:04   Re: TCP Overhead on Local Loopback Dave Crooke
• 17:30   Update join performance issues Kevin Kempter
• 17:38   Re: Update join performance issues Kevin Grittner
• 17:39   Re: Update join performance issues Andrew Dunstan
• 17:50   Re: Update join performance issues Kevin Grittner
• 17:55   Re: Update join performance issues Thomas Kellerer
• 18:01   Re: H800 + md1200 Performance problem Tomas Vondra
• 18:45   Re: H800 + md1200 Performance problem Merlin Moncure
• 20:43   Re: Update join performance issues Merlin Moncure

4 April 2012

• 01:36   pg_autovacuum in PG9.x David Kerr
• 01:51   Re: pg_autovacuum in PG9.x David Kerr
• 09:42   Re: H800 + md1200 Performance problem Cesar Martin
• 13:15   Re: H800 + md1200 Performance problem Scott Marlowe
• 13:21   Re: H800 + md1200 Performance problem Tomas Vondra
• 15:53   about multiprocessingmassdata superman0920
• 16:23   Re: H800 + md1200 Performance problem Scott Marlowe
• 16:28   Re: H800 + md1200 Performance problem Claudio Freire
• 16:31   Re: H800 + md1200 Performance problem Scott Marlowe
• 16:35   Re: about multiprocessingmassdata Tomas Vondra
• 16:42   Re: H800 + md1200 Performance problem Scott Marlowe
• 16:54   Re: H800 + md1200 Performance problem Tomas Vondra
• 17:00   Re: about multiprocessingmassdata Tomas Vondra
• 17:16   Re: H800 + md1200 Performance problem Merlin Moncure
• 18:46   Re: H800 + md1200 Performance problem Cesar Martin
• 18:56   Re: H800 + md1200 Performance problem Scott Marlowe
• 18:59   Re: H800 + md1200 Performance problem Merlin Moncure
• 19:51   Re: H800 + md1200 Performance problem Tomas Vondra

5 April 2012

• 09:40   Re: TCP Overhead on Local Loopback Ofer Israeli
• 11:48   bad plan Julien Cigar
• 13:10   Re: H800 + md1200 Performance problem Glyn Astill
• 13:26   bad planning with 75% effective_cache_size Istvan Endredy
• 13:26   Re: pg_autovacuum in PG9.x Brett Mc Bride
• 13:26   Planner selects slow "Bitmap Heap Scan" when "Index Scan" is faster Kim Hansen
• 13:27   postgresql.conf setting for max_fsm_pages ahchuan
• 13:57   Re: postgresql.conf setting for max_fsm_pages Marcos Ortiz
• 14:26   Re: bad plan Kevin Grittner
• 14:39   Re: postgresql.conf setting for max_fsm_pages Scott Marlowe
• 14:48   Re: about multiprocessingmassdata Tomas Vondra
• 15:01   Re: about multiprocessingmassdata Kevin Grittner
• 15:34   Re: Planner selects slow "Bitmap Heap Scan" when "Index Scan" is faster Kevin Grittner
• 15:39   heavly load system spec Gregg Jaskiewicz
• 15:42   Re: bad planning with 75% effective_cache_size Kevin Grittner
• 15:50   Re: H800 + md1200 Performance problem Tomas Vondra
• 18:44   Re: H800 + md1200 Performance problem Merlin Moncure
• 19:48   Re: bad plan Ants Aasma
• 20:07   Re: H800 + md1200 Performance problem Tomas Vondra

6 April 2012

• 10:48   Re: Planner selects slow "Bitmap Heap Scan" when "Index Scan" is faster Kim Hansen
• 11:16   Re: bad plan Julien Cigar
• 17:11   Re: Planner selects slow "Bitmap Heap Scan" when "Index Scan" is faster Jeff Janes

7 April 2012

• 12:40   Re: Planner selects slow "Bitmap Heap Scan" when "Index Scan" is faster Kim Hansen
• 17:07   get/set priority of PostgreSQL backends Josh Kupershmidt
• 18:05   Re: get/set priority of PostgreSQL backends Scott Marlowe
• 18:31   Re: get/set priority of PostgreSQL backends Josh Kupershmidt

8 April 2012

• 18:31   Stats Lukas
• 20:36   Re: Stats Kevin Grittner

9 April 2012

• 16:24   Re: H800 + md1200 Performance problem Cesar Martin
• 22:38   Re: about multiprocessingmassdata Merlin Moncure
• 23:51   Re: about multiprocessingmassdata Tomas Vondra

10 April 2012

• 02:59   Re: Planner selects slow "Bitmap Heap Scan" when "Index Scan" is faster Jeff Janes
• 13:22   Re: about multiprocessingmassdata Merlin Moncure

12 April 2012

• 15:48   Re: Linux machine aggressively clearing cache Steve Crawford
• 18:41   Random performance hit, unknown cause. Brian Fehrle
• 18:50   Re: Random performance hit, unknown cause. Claudio Freire
• 19:52   Re: Random performance hit, unknown cause. Kevin Grittner
• 19:59   Re: Random performance hit, unknown cause. Claudio Freire
• 21:32   Re: Random performance hit, unknown cause. Brian Fehrle
• 22:00   Re: Random performance hit, unknown cause. Kevin Grittner
• 22:10   Slow fulltext query plan Benoit Delbosc
• 22:26   Re: Slow fulltext query plan Tom Lane
• 22:56   Re: Slow fulltext query plan Benoit Delbosc

13 April 2012

• 13:58   Re: bad planning with 75% effective_cache_size Istvan Endredy
• 13:58   Re: Planner selects slow "Bitmap Heap Scan" when "Index Scan" is faster Kim Hansen
• 13:58   scale up (postgresql vs mssql) Eyal Wilde
• 14:32   Re: scale up (postgresql vs mssql) Andrew Dunstan
• 14:40   Re: scale up (postgresql vs mssql) Kevin Grittner
• 15:04   Re: scale up (postgresql vs mssql) Claudio Freire
• 16:15   PostgreSQL - Help Optimizing performance - full text search on Heroku xlash
• 16:36   Re: scale up (postgresql vs mssql) Steve Crawford
• 16:44   Re: scale up (postgresql vs mssql) Claudio Freire
• 17:09   Re: PostgreSQL - Help Optimizing performance - full text search on Heroku Tomas Vondra
• 17:49   Re: scale up (postgresql vs mssql) Steve Crawford
• 17:53   Re: scale up (postgresql vs mssql) Claudio Freire

14 April 2012

• 01:17   Re: Slow fulltext query plan Tom Lane

15 April 2012

• 20:02   Re: bad planning with 75% effective_cache_size Filippos

16 April 2012

• 13:10   Re: scale up (postgresql vs mssql) Merlin Moncure
• 13:12   Re: Slow fulltext query plan Florent Guillaume
• 14:15   Re: H800 + md1200 Performance problem Cesar Martin
• 14:33   Re: scale up (postgresql vs mssql) Eyal Wilde
• 14:34   SeqScan with full text search Tomek Walkuski
• 15:43   Re: scale up (postgresql vs mssql) Andy Colson
• 15:46   Re: H800 + md1200 Performance problem Scott Marlowe
• 15:56   Re: scale up (postgresql vs mssql) Richard Huxton
• 16:09   Re: H800 + md1200 Performance problem Merlin Moncure
• 16:19   Re: SeqScan with full text search Tomas Vondra
• 19:38   Re: SeqScan with full text search Merlin Moncure

17 April 2012

• 17:12   Re: SeqScan with full text search Віталій Тимчишин
• 20:10   Re: H800 + md1200 Performance problem Scott Marlowe
• 20:10   Re: H800 + md1200 Performance problem Scott Marlowe
• 20:10   Re: H800 + md1200 Performance problem Glyn Astill
• 20:10   Re: bad planning with 75% effective_cache_size Istvan Endredy

18 April 2012

• 06:51   Re: bad planning with 75% effective_cache_size Віталій Тимчишин
• 16:57   Re: scale up (postgresql vs mssql) Eyal Wilde
• 16:57   Re: Random performance hit, unknown cause. Strange, John W
• 19:48   Re: scale up (postgresql vs mssql) Andy Colson
• 20:14   Re: scale up (postgresql vs mssql) Merlin Moncure

19 April 2012

• 00:09   Re: Linux machine aggressively clearing cache Josh Berkus
• 00:45   Re: bad planning with 75% effective_cache_size Josh Berkus
• 10:33   Re: bad planning with 75% effective_cache_size Ants Aasma
• 15:25   Re: bad planning with 75% effective_cache_size Istvan Endredy

24 April 2012

• 02:57   Configuration Recommendations Jan Nielsen
• 05:53   Re: Configuration Recommendations Robert Klemme
• 19:33   Re: Configuration Recommendations Shaun Thomas

25 April 2012

• 05:08   Re: Configuration Recommendations Jan Nielsen
• 05:09   Re: Configuration Recommendations Jan Nielsen
• 17:08   Re: Configuration Recommendations Greg Sabino Mullane
• 18:52   Parallel Scaling of a pgplsql problem Venki Ramachandran
• 18:55   Re: Configuration Recommendations Robert Klemme
• 19:36   Re: Parallel Scaling of a pgplsql problem Samuel Gendler
• 20:05   Re: Parallel Scaling of a pgplsql problem Kevin Grittner
• 20:10   Re: Parallel Scaling of a pgplsql problem Pavel Stehule
• 21:12   Re: Parallel Scaling of a pgplsql problem Venki Ramachandran
• 21:27   Re: Parallel Scaling of a pgplsql problem Pavel Stehule
• 21:29   Re: Configuration Recommendations Shaun Thomas
• 21:46   Re: Parallel Scaling of a pgplsql problem Venki Ramachandran
• 21:52   Re: Parallel Scaling of a pgplsql problem Tom Lane
• 22:06   Re: Parallel Scaling of a pgplsql problem Merlin Moncure

26 April 2012

• 00:11   Re: Configuration Recommendations Greg Smith
• 02:40   Re: Parallel Scaling of a pgplsql problem Venki Ramachandran
• 03:41   Re: Parallel Scaling of a pgplsql problem Jan Nielsen
• 06:49   Re: Parallel Scaling of a pgplsql problem Yeb Havinga
• 16:13   Re: Parallel Scaling of a pgplsql problem Greg Spiegelberg
• 17:38   Weird plan variation with recursive CTEs Claudio Freire
• 18:11   query optimization Richard Kojedzinszky
• 18:12   Re: Configuration Recommendations John Lister
• 18:23   Re: Weird plan variation with recursive CTEs Claudio Freire
• 18:23   Re: query optimization Kevin Grittner
• 19:17   Re: query optimization Tom Lane
• 19:38   Re: query optimization Thomas Kellerer
• 19:49   auto-vacuum vs. full table update Craig James
• 19:54   Re: auto-vacuum vs. full table update Joshua D. Drake
• 20:00   Re: auto-vacuum vs. full table update Steve Crawford
• 20:09   Re: query optimization Tom Lane
• 20:11   Re: auto-vacuum vs. full table update Kevin Grittner
• 20:28   Re: query optimization Andrew Dunstan
• 20:58   Re: Weird plan variation with recursive CTEs Tom Lane

29 April 2012

• 09:27   NOT EXISTS or LEFT JOIN which one is better? AI Rumman
• 15:10   Re: NOT EXISTS or LEFT JOIN which one is better? Rich

30 April 2012

• 13:50   Tuning Postgres 9.1 on Windows Walker, James Les
• 16:26   Re: Tuning Postgres 9.1 on Windows Andy Colson
• 21:43   Re: Tuning Postgres 9.1 on Windows Merlin Moncure
• 22:00   Re: Tuning Postgres 9.1 on Windows Thomas Kellerer
• 22:04   Re: Tuning Postgres 9.1 on Windows Merlin Moncure