• Text Size: Normal / Large
• Donate
• Contact

Section Navigation

• Community
• Contributors
• Mailing Lists
  • Subscribe
  • User lists
    • pgsql-admin
    • pgsql-advocacy
    • pgsql-announce
    • pgsql-bugs
    • pgsql-docs
    • pgsql-general
    • pgsql-jobs
    • pgsql-novice
    • pgsql-performance
    • pgsql-php
    • pgsql-sql
    • pgsql-students
  • Developer lists
  • Regional lists
  • Associations
  • User groups
  • Project lists
  • Inactive lists
• IRC
• Featured Users
• International Sites
• Propaganda
• Resources
• Weekly News
• Community login
  • Profile
  • Lost password

pgsql-performance 2011-06 Chronological Index (1/2)

• Thread Index
• [Prev Page]
• [Next Page]

• 30 June 2011
  • Re: near identical queries have vastly different plans Samuel Gendler (20:35)
  • Re: Poor performance when joining against inherited tables Robert Haas (19:07)
  • Re: is parallel union all possible over dblink? Greg Spiegelberg (12:37)
  • Re: near identical queries have vastly different plans Samuel Gendler (09:40)
  • near identical queries have vastly different plans Samuel Gendler (08:53)
  • Re: sequential scan unduly favored over text search gin index Jeff Janes (03:59)
  • Re: sequential scan unduly favored over text search gin index Jeff Janes (03:42)
• 29 June 2011
  • Re: is parallel union all possible over dblink? Shaun Thomas (19:38)
  • Re: is parallel union all possible over dblink? Greg Spiegelberg (19:14)
  • Re: is parallel union all possible over dblink? Marinos Yannikos (18:37)
  • is parallel union all possible over dblink? Svetlin Manavski (11:56)
  • Re: change sample size for statistics Robert Haas (02:55)
  • Re: Slow performance when querying millions of rows Greg Smith (01:02)
  • Re: Slow performance when querying millions of rows Greg Smith (00:51)
  • Re: Slow performance when querying millions of rows Tomas Vondra (00:11)
  • Re: Slow performance when querying millions of rows Tomas Vondra (00:03)
• 28 June 2011
  • Re: Slow performance when querying millions of rows Craig McIlwee (23:51)
  • Re: Slow performance when querying millions of rows Craig McIlwee (23:26)
  • Re: Slow performance when querying millions of rows Greg Smith (22:42)
  • Re: Slow performance when querying millions of rows Tomas Vondra (22:39)
  • Slow performance when querying millions of rows Craig McIlwee (21:29)
  • Re: Long Running Update - My Solution Harry Mantheakis (09:49)
  • Re: Long Running Update - My Solution Greg Smith (00:37)
• 27 June 2011
  • Fw: Getting rid of a seq scan in query on a large table Denis de Bernardy (23:01)
  • Re: Performance issue with Insert Kevin Grittner (20:56)
  • Re: Performance issue with Insert Tomas Vondra (20:47)
  • Re: Performance issue with Insert Jenish (20:14)
  • Re: Performance issue with Insert Tomas Vondra (19:48)
  • Re: Performance issue with Insert Tomas Vondra (19:46)
  • Re: Long Running Update - My Solution Robert Klemme (19:29)
  • Re: Performance issue with Insert Merlin Moncure (16:12)
  • Re: Performance issue with Insert Jenish (15:58)
  • Re: Long Running Update - My Solution tv (15:37)
  • Re: Performance issue with Insert tv (15:32)
  • Re: Long Running Update - My Solution Kevin Grittner (15:12)
  • Re: Long Running Update - My Solution Harry Mantheakis (15:02)
  • Re: Performance issue with Insert Jenish (15:02)
  • Re: Performance issue with Insert Kevin Grittner (14:38)
  • Re: Getting rid of a seq scan in query on a large table Kevin Grittner (14:30)
  • Performance issue with Insert Jenish (14:23)
  • Getting rid of a seq scan in query on a large table Jens Hoffrichter (12:46)
• 24 June 2011
  • Re: Cost of creating an emply WAL segment Greg Smith (23:26)
  • Re: Cost of creating an emply WAL segment Shaun Thomas (18:55)
  • Re: Long Running Update Harry Mantheakis (16:49)
  • Re: Long Running Update Kevin Grittner (16:41)
  • Re: Long Running Update Harry Mantheakis (16:32)
  • Re: Long Running Update Harry Mantheakis (16:29)
  • Re: Cost of creating an emply WAL segment Greg Smith (16:18)
  • Re: Long Running Update Kevin Grittner (15:12)
  • Cost of creating an emply WAL segment Devrim GÜNDÜZ (14:43)
  • Re: Long Running Update Kevin Grittner (14:00)
  • Re: Long Running Update Kevin Grittner (13:43)
  • Re: Long Running Update Mark Thornton (13:01)
  • Re: Long Running Update Harry Mantheakis (12:40)
  • Re: Long Running Update Vitalii Tymchyshyn (11:45)
  • Re: Long Running Update Claudio Freire (11:40)
  • Re: Long Running Update Harry Mantheakis (11:19)
  • Re: Long Running Update Harry Mantheakis (11:16)
• 23 June 2011
  • Re: Long Running Update Kevin Grittner (19:32)
  • Re: Long Running Update Claudio Freire (17:18)
  • Long Running Update Harry Mantheakis (16:05)
  • Re: bitmask index Robert Klemme (15:55)
• 22 June 2011
  • Re: bitmask index Greg Smith (21:42)
  • Re: seq scan in the case of max() on the primary key column Greg Smith (21:35)
  • bitmask index Marcus Engene (21:34)
  • Re: Improve the Postgres Query performance Tripura (20:57)
  • Re: seq scan in the case of max() on the primary key column Shaun Thomas (18:15)
  • Re: seq scan in the case of max() on the primary key column Scott Marlowe (18:12)
  • Re: seq scan in the case of max() on the primary key column Greg Smith (17:01)
  • Re: Contemplating SSD Hardware RAID Shaun Thomas (15:50)
  • Re: seq scan in the case of max() on the primary key column Shaun Thomas (13:12)
  • Re: seq scan in the case of max() on the primary key column Marti Raudsepp (09:56)
  • Re: Improve the Postgres Query performance Craig Ringer (07:05)
• 21 June 2011
  • Re: Contemplating SSD Hardware RAID Greg Smith (22:17)
  • Re: Contemplating SSD Hardware RAID Merlin Moncure (21:35)
  • Improve the Postgres Query performance Tripura (20:34)
  • Re: Contemplating SSD Hardware RAID Scott Marlowe (20:32)
  • Re: Contemplating SSD Hardware RAID Yeb Havinga (20:26)
  • Re: Contemplating SSD Hardware RAID Yeb Havinga (20:11)
  • Re: seq scan in the case of max() on the primary key column Shaun Thomas (19:49)
  • Re: Contemplating SSD Hardware RAID Anton Rommerskirchen (18:39)
  • Re: Contemplating SSD Hardware RAID Greg Smith (15:12)
  • Re: Contemplating SSD Hardware RAID Florian Weimer (11:19)
  • Re: Inoptimal query plan for max() and multicolumn index F. BROUARD / SQLpro (10:49)
  • Re: Contemplating SSD Hardware RAID Yeb Havinga (07:55)
  • Re: Contemplating SSD Hardware RAID Yeb Havinga (07:52)
  • Re: Contemplating SSD Hardware RAID Greg Smith (06:33)
  • Re: sequential scan unduly favored over text search gin index Tom Lane (05:53)
  • Contemplating SSD Hardware RAID Dan Harris (04:04)
  • Cross Table (Pivot) Mario Guerrero (03:42)
  • Re: sequential scan unduly favored over text search gin index Sushant Sinha (02:25)
• 20 June 2011
  • Re: bad plan: 8.4.8, hashagg, work_mem=1MB. Jon Nelson (19:31)
  • Re: how to know slowly query in lock postgre Tomas Vondra (19:09)
  • Re: sequential scan unduly favored over text search gin index Tomas Vondra (19:01)
  • Re: sequential scan unduly favored over text search gin index Jesper Krogh (18:59)
  • Re: Inoptimal query plan for max() and multicolumn index Vladimir Kulev (16:13)
  • Re: bad plan: 8.4.8, hashagg, work_mem=1MB. Tom Lane (16:08)
  • Re: sequential scan unduly favored over text search gin index Sushant Sinha (16:04)
  • bad plan: 8.4.8, hashagg, work_mem=1MB. Jon Nelson (16:01)
  • Re: sequential scan unduly favored over text search gin index Kevin Grittner (15:58)
  • sequential scan unduly favored over text search gin index Sushant Sinha (15:45)
  • Re: Inoptimal query plan for max() and multicolumn index Kevin Grittner (15:41)
  • Re: how to know slowly query in lock postgre Claudio Freire (09:45)
  • Re: generating a large XML document Julius Tuskenis (09:03)
  • Re: generating a large XML document Pavel Stehule (07:59)
  • how to know slowly query in lock postgre Didik Prasetyo (07:57)
  • Re: generating a large XML document Pavel Stehule (07:47)
  • Re: generating a large XML document Julius Tuskenis (07:38)
  • Re: generating a large XML document Julius Tuskenis (07:29)
  • Re: generating a large XML document Samuel Gendler (07:21)
  • Re: generating a large XML document Pavel Stehule (06:52)
  • Re: generating a large XML document Julius Tuskenis (06:36)
  • Inoptimal query plan for max() and multicolumn index Vladimir Kulev (05:44)
  • Re: Large rows number, and large objects Jose Ildefonso Camargo Tolosa (02:19)
• 19 June 2011
  • Re: Degrading PostgreSQL 8.4 write performance Pierre C (23:14)
  • hstore - Implementation and performance issues around its operators Stefan Keller (18:59)
  • Re: Large rows number, and large objects Craig James (15:49)
  • Re: Large rows number, and large objects Samuel Gendler (11:38)
  • Large rows number, and large objects Jose Ildefonso Camargo Tolosa (04:06)
• 17 June 2011
  • Re: seq scan in the case of max() on the primary key column Jim Nasby (23:19)
  • Re: seq scan in the case of max() on the primary key column Greg Smith (18:00)
  • Re: Degrading PostgreSQL 8.4 write performance Greg Smith (17:54)
  • Re: Degrading PostgreSQL 8.4 write performance Merlin Moncure (14:08)
  • Re: Performance advice for a new low(er)-power server Merlin Moncure (13:29)
  • Degrading PostgreSQL 8.4 write performance Kabu Taah (12:54)
  • Re: seq scan in the case of max() on the primary key column Shaun Thomas (12:43)
  • Re: seq scan in the case of max() on the primary key column Svetlin Manavski (11:22)
  • Re: Performance advice for a new low(er)-power server jesper (09:30)
  • Re: Performance advice for a new low(er)-power server Haestan (09:13)
  • Re: Performance advice for a new low(er)-power server Haestan (08:42)
• 16 June 2011
  • Re: Performance advice for a new low(er)-power server Merlin Moncure (22:44)
  • Re: Performance advice for a new low(er)-power server Greg Smith (22:12)
  • generating a large XML document Julius Tuskenis (19:40)
  • Re: Performance advice for a new low(er)-power server Merlin Moncure (19:04)
  • Re: Performance advice for a new low(er)-power server Scott Marlowe (18:52)
  • Re: Performance advice for a new low(er)-power server Greg Smith (18:43)
  • Re: seq scan in the case of max() on the primary key column Shaun Thomas (18:36)
  • Re: Performance advice for a new low(er)-power server Jesper Krogh (18:29)
  • Re: Performance advice for a new low(er)-power server Merlin Moncure (18:19)
  • Re: seq scan in the case of max() on the primary key column Magnus Hagander (17:26)
  • Re: seq scan in the case of max() on the primary key column Jesper Krogh (17:03)
  • Performance advice for a new low(er)-power server Haestan (15:10)
  • seq scan in the case of max() on the primary key column Svetlin Manavski (13:55)
  • Re: 100% CPU Utilization when we run queries. bakkiya (04:35)
• 15 June 2011
  • Re: need to repeat the same condition on joined tables in order to choose the proper plan Svetlin Manavski (08:55)
• 14 June 2011
  • Re: need to repeat the same condition on joined tables in order to choose the proper plan Robert Klemme (20:21)
  • Re: need to repeat the same condition on joined tables in order to choose the proper plan Tom Lane (16:29)
  • need to repeat the same condition on joined tables in order to choose the proper plan Svetlin Manavski (13:55)
• 13 June 2011
  • Re: change sample size for statistics Willy-Bas Loos (22:34)
• 12 June 2011
  • Re: how much postgres can scale up? Benjamin Krajmalnik (15:15)
  • Re: Triggering autovacuum Scott Marlowe (03:55)
• 11 June 2011
  • Re: Triggering autovacuum Reuven M. Lerner (22:38)
• 10 June 2011
  • Re: change sample size for statistics Nathan Boley (20:07)
  • Re: change sample size for statistics Josh Berkus (19:58)
  • Re: how much postgres can scale up? Anibal David Acosta (18:22)
  • Re: how much postgres can scale up? Greg Smith (16:49)
  • Re: how much postgres can scale up? Pierre C (16:21)
  • Re: strange query plan with LIMIT Claudio Freire (15:22)
  • Re: how much postgres can scale up? Pierre C (14:16)
  • Re: how much postgres can scale up? Anibal David Acosta (13:19)
  • Re: how much postgres can scale up? Craig Ringer (13:13)
  • Re: how much postgres can scale up? Craig Ringer (13:02)
  • Re: how much postgres can scale up? Anibal David Acosta (13:02)
  • Re: 100% CPU Utilization when we run queries. Craig Ringer (12:37)
  • change sample size for statistics Willy-Bas Loos (12:15)
  • Re: how much postgres can scale up? tv (12:10)
  • how much postgres can scale up? Anibal David Acosta (11:58)
  • Re: strange query plan with LIMIT tv (11:23)
  • Re: [GENERAL] [PERFORMANCE] expanding to SAN: which portion best to move Robert Klemme (10:02)
  • Re: 100% CPU Utilization when we run queries. Marti Raudsepp (09:01)
  • Re: strange query plan with LIMIT anthony . shipman (08:38)
  • Re: 100% CPU Utilization when we run queries. bakkiya (07:39)
  • Re: Oracle v. Postgres 9.0 query performance Tom Lane (02:25)
  • Re: Oracle v. Postgres 9.0 query performance Tatsuo Ishii (02:21)
• 09 June 2011
  • Re: [GENERAL] [PERFORMANCE] expanding to SAN: which portion best to move Greg Smith (17:44)
  • Re: Triggering autovacuum Greg Smith (16:52)
  • Re: Postgresql on itanium server Tom Lane (16:20)
  • Triggering autovacuum Reuven M. Lerner (15:24)
  • Re: poor performance when recreating constraints on large tables Samuel Gendler (12:04)
  • Re: [PERFORMANCE] expanding to SAN: which portion best to move Willy-Bas Loos (11:43)

• Thread Index
• [Prev Page]
• [Next Page]