Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Text Size: Normal / Large
Donate
Contact

PostgreSQL

The world's most advanced open source database.

pgsql-performance - April 2012

Prev | Next

Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 24 25 26 28 29 30

2012-04-01

Re: database slowdown while a lot of inserts occur Bob Lunney (02:20)
TCP Overhead on Local Loopback Ofer Israeli (20:24)
Re: TCP Overhead on Local Loopback Andy (22:01)
Re: TCP Overhead on Local Loopback Rob Wultsch (23:48)
Re: TCP Overhead on Local Loopback Andrew Dunstan (23:54)

2012-04-02

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

2012-04-03

H800 + md1200 Performance problem Cesar Martin (12:20)
Re: H800 + md1200 Performance problem Mike DelNegro (12:37)
Re: H800 + md1200 Performance problem Cesar Martin (12:59)
Re: H800 + md1200 Performance problem Merlin Moncure (13:11)
Re: H800 + md1200 Performance problem Tomas Vondra (13:21)
Re: Performance of SQL Function versus View Robert Haas (14:21)
Re: Performance of SQL Function versus View Andrew Dunstan (14:30)
Re: ...WHERE TRUE" condition in union results in bad query pla Robert Haas (14:57)
bad planning with 75% effective_cache_size Istvan Endredy (15:11)
Re: TCP Overhead on Local Loopback Ofer Israeli (15:24)
Re: H800 + md1200 Performance problem Scott Marlowe (15:32)
Re: H800 + md1200 Performance problem Scott Marlowe (15:34)
Re: ...WHERE TRUE" condition in union results in bad query pla Tom Lane (15:35)
Re: TCP Overhead on Local Loopback Claudio Freire (15:38)
Re: H800 + md1200 Performance problem Cesar Martin (15:42)
Re: H800 + md1200 Performance problem Cesar Martin (15:50)
Re: H800 + md1200 Performance problem Cesar Martin (15:51)
Re: TCP Overhead on Local Loopback Dave Crooke (16:04)
Update join performance issues Kevin Kempter (17:29)
Re: Update join performance issues Kevin Grittner (17:37)
Re: Update join performance issues Andrew Dunstan (17:39)
Re: Update join performance issues Kevin Grittner (17:49)
Re: Update join performance issues Thomas Kellerer (17:51)
Re: H800 + md1200 Performance problem Tomas Vondra (18:01)
Re: H800 + md1200 Performance problem Merlin Moncure (18:44)
Re: Update join performance issues Merlin Moncure (20:43)

2012-04-04

pg_autovacuum in PG9.x David Kerr (01:36)
Re: pg_autovacuum in PG9.x Brett Mc Bride (01:40)
Re: pg_autovacuum in PG9.x David Kerr (01:51)
postgresql.conf setting for max_fsm_pages ahchuan (09:22)
Re: H800 + md1200 Performance problem Cesar Martin (09:42)
Re: H800 + md1200 Performance problem Scott Marlowe (13:15)
Re: H800 + md1200 Performance problem Tomas Vondra (13:20)
Planner selects slow "Bitmap Heap Scan" when "Index Scan" is faster Kim Hansen (13:47)
about multiprocessingmassdata superman0920 (15:52)
Re: H800 + md1200 Performance problem Scott Marlowe (16:22)
Re: H800 + md1200 Performance problem Claudio Freire (16:28)
Re: H800 + md1200 Performance problem Scott Marlowe (16:31)
Re: about multiprocessingmassdata Tomas Vondra (16:34)
Re: H800 + md1200 Performance problem Scott Marlowe (16:42)
Re: H800 + md1200 Performance problem Tomas Vondra (16:54)
Re: about multiprocessingmassdata Tomas Vondra (16:59)
Re: H800 + md1200 Performance problem Merlin Moncure (17:16)
Re: H800 + md1200 Performance problem Cesar Martin (18:46)
Re: H800 + md1200 Performance problem Scott Marlowe (18:55)
Re: H800 + md1200 Performance problem Merlin Moncure (18:58)
Re: H800 + md1200 Performance problem Tomas Vondra (19:50)

2012-04-05

Re: TCP Overhead on Local Loopback Ofer Israeli (09:39)
bad plan Julien Cigar (11:47)
Re: H800 + md1200 Performance problem Glyn Astill (13:10)
Re: postgresql.conf setting for max_fsm_pages Marcos Ortiz (13:56)
Re: bad plan Kevin Grittner (14:26)
Re: postgresql.conf setting for max_fsm_pages Scott Marlowe (14:38)
Re: about multiprocessingmassdata Tomas Vondra (14:47)
Re: about multiprocessingmassdata Kevin Grittner (15:01)
Re: Planner selects slow "Bitmap Heap Scan" when "Index Scan" is faster Kevin Grittner (15:34)
heavly load system spec Gregg Jaskiewicz (15:39)
Re: bad planning with 75% effective_cache_size Kevin Grittner (15:41)
Re: H800 + md1200 Performance problem Tomas Vondra (15:49)
Re: Planner selects slow "Bitmap Heap Scan" when "Index Scan" is faster Kim Hansen (16:01)
Re: H800 + md1200 Performance problem Merlin Moncure (18:43)
Re: bad plan Ants Aasma (19:47)
Re: H800 + md1200 Performance problem Tomas Vondra (20:06)

2012-04-06

Re: bad plan Julien Cigar (11:16)
Re: Planner selects slow "Bitmap Heap Scan" when "Index Scan" is faster Jeff Janes (17:11)
Re: Planner selects slow "Bitmap Heap Scan" when "Index Scan" is faster Kim Hansen (22:09)

2012-04-07

get/set priority of PostgreSQL backends Josh Kupershmidt (17:06)
Re: get/set priority of PostgreSQL backends Scott Marlowe (18:05)
Re: get/set priority of PostgreSQL backends Josh Kupershmidt (18:31)

2012-04-08

Stats Lukas (18:30)
Re: Stats Kevin Grittner (20:36)

2012-04-09

Re: H800 + md1200 Performance problem Cesar Martin (16:24)
Re: about multiprocessingmassdata Merlin Moncure (22:37)
Re: about multiprocessingmassdata Tomas Vondra (23:50)

2012-04-10

Re: Planner selects slow "Bitmap Heap Scan" when "Index Scan" is faster Jeff Janes (02:59)
Re: bad planning with 75% effective_cache_size Istvan Endredy (07:19)
Re: Planner selects slow "Bitmap Heap Scan" when "Index Scan" is faster Kim Hansen (09:55)
Re: about multiprocessingmassdata Merlin Moncure (13:21)

2012-04-11

scale up (postgresql vs mssql) Eyal Wilde (22:11)

2012-04-12

Re: Linux machine aggressively clearing cache Steve Crawford (15:47)
Random performance hit, unknown cause. Brian Fehrle (18:41)
Re: Random performance hit, unknown cause. Claudio Freire (18:49)
Re: Random performance hit, unknown cause. Kevin Grittner (19:52)
Re: Random performance hit, unknown cause. Claudio Freire (19:59)
Re: Random performance hit, unknown cause. Brian Fehrle (21:31)
Re: Random performance hit, unknown cause. Kevin Grittner (22:00)
Slow fulltext query plan Benoit Delbosc (22:09)
Re: Slow fulltext query plan Tom Lane (22:25)
Re: Slow fulltext query plan Benoit Delbosc (22:56)

2012-04-13

Re: scale up (postgresql vs mssql) Andrew Dunstan (14:32)
Re: scale up (postgresql vs mssql) Kevin Grittner (14:40)
Re: scale up (postgresql vs mssql) Claudio Freire (15:04)
PostgreSQL - Help Optimizing performance - full text search on Heroku xlash (16:14)
Re: scale up (postgresql vs mssql) Steve Crawford (16:36)
Re: scale up (postgresql vs mssql) Claudio Freire (16:43)
Re: PostgreSQL - Help Optimizing performance - full text search on Heroku Tomas Vondra (17:09)
Re: scale up (postgresql vs mssql) Steve Crawford (17:49)
Re: scale up (postgresql vs mssql) Claudio Freire (17:52)

2012-04-14

Re: Slow fulltext query plan Tom Lane (01:16)

2012-04-15

Re: scale up (postgresql vs mssql) Eyal Wilde (12:43)
Re: bad planning with 75% effective_cache_size Filippos (20:01)

2012-04-16

Re: scale up (postgresql vs mssql) Merlin Moncure (13:10)
Re: Slow fulltext query plan Florent Guillaume (13:11)
SeqScan with full text search Tomek Walkuski (14:02)
Re: H800 + md1200 Performance problem Cesar Martin (14:13)
Re: scale up (postgresql vs mssql) Andy Colson (15:43)
Re: H800 + md1200 Performance problem Scott Marlowe (15:45)
Re: scale up (postgresql vs mssql) Richard Huxton (15:55)
Re: H800 + md1200 Performance problem Merlin Moncure (16:08)
Re: H800 + md1200 Performance problem Scott Marlowe (16:18)
Re: SeqScan with full text search Tomas Vondra (16:19)
Re: H800 + md1200 Performance problem Glyn Astill (16:31)
Re: H800 + md1200 Performance problem Scott Marlowe (17:47)
Re: SeqScan with full text search Merlin Moncure (19:38)

2012-04-17

Re: bad planning with 75% effective_cache_size Istvan Endredy (09:49)
Re: SeqScan with full text search Віталій Тимчишин (17:12)

2012-04-18

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

2012-04-19

Re: Linux machine aggressively clearing cache Josh Berkus (00:09)
Re: bad planning with 75% effective_cache_size Josh Berkus (00:44)
Re: bad planning with 75% effective_cache_size Ants Aasma (10:32)
Re: bad planning with 75% effective_cache_size Istvan Endredy (14:15)

2012-04-24

Configuration Recommendations Jan Nielsen (02:56)
Re: Configuration Recommendations Robert Klemme (05:53)
query optimization Richard Kojedzinszky (08:11)
Re: Configuration Recommendations Shaun Thomas (19:32)

2012-04-25

Re: Configuration Recommendations Jan Nielsen (05:07)
Re: Configuration Recommendations Jan Nielsen (05:09)
Re: Configuration Recommendations John Lister (07:46)
Re: Configuration Recommendations Greg Sabino Mullane (17:08)
Parallel Scaling of a pgplsql problem Venki Ramachandran (18:52)
Re: Configuration Recommendations Robert Klemme (18:55)
Re: Parallel Scaling of a pgplsql problem Samuel Gendler (19:36)
Re: Parallel Scaling of a pgplsql problem Kevin Grittner (20:04)
Re: Parallel Scaling of a pgplsql problem Pavel Stehule (20:09)
Re: Parallel Scaling of a pgplsql problem Venki Ramachandran (21:12)
Re: Parallel Scaling of a pgplsql problem Pavel Stehule (21:26)
Re: Configuration Recommendations Shaun Thomas (21:29)
Re: Parallel Scaling of a pgplsql problem Venki Ramachandran (21:45)
Re: Parallel Scaling of a pgplsql problem Tom Lane (21:52)
Re: Parallel Scaling of a pgplsql problem Merlin Moncure (22:05)

2012-04-26

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

2012-04-28

Re: query optimization Richard Kojedzinszky (06:11)

2012-04-29

NOT EXISTS or LEFT JOIN which one is better? AI Rumman (09:27)
Re: scale up (postgresql vs mssql) Eyal Wilde (13:21)
Re: NOT EXISTS or LEFT JOIN which one is better? Rich (15:10)

2012-04-30

Tuning Postgres 9.1 on Windows Walker, James Les (13:49)
Re: Tuning Postgres 9.1 on Windows Andy Colson (16:26)
Result Set over Network Question Ronald Hahn, DOCFOCUS INC. (18:32)
Query got slow from 9.0 to 9.1 upgrade Josh Turmel (21:17)
Re: Tuning Postgres 9.1 on Windows Merlin Moncure (21:43)
Re: Tuning Postgres 9.1 on Windows Thomas Kellerer (22:00)
Re: Tuning Postgres 9.1 on Windows Merlin Moncure (22:04)

Prev | Next

Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 24 25 26 28 29 30

Privacy Policy | About PostgreSQL
Copyright © 1996-2013 The PostgreSQL Global Development Group