tag:blogger.com,1999:blog-20038672.post176374130451591295..comments2024-03-28T00:58:29.187-04:00Comments on Robert Haas: Reducing Lock ContentionRobert Haashttp://www.blogger.com/profile/08393677427643988650noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-20038672.post-71749998965590090522011-06-07T05:34:13.262-04:002011-06-07T05:34:13.262-04:00@WildRAiD: I do not think PostgreSQL has any probl...@WildRAiD: I do not think PostgreSQL has any problems with locks on large SELECTs, assuming you mean selects which touch many rows. I believe it is when you have many short read-only transactions with a high level of concurrency you will hit this bottleneck.Andreas Karlssonnoreply@blogger.comtag:blogger.com,1999:blog-20038672.post-46592971557810327582011-06-07T02:18:19.552-04:002011-06-07T02:18:19.552-04:00Yes! It's a really important optimization. We ...Yes! It's a really important optimization. We encounter heavy locking on large SELECT's.WildRAiDhttps://www.blogger.com/profile/08433269429884087726noreply@blogger.comtag:blogger.com,1999:blog-20038672.post-87322508924443808952011-06-06T19:22:44.404-04:002011-06-06T19:22:44.404-04:00Nice work! Curious what the improvement is on an 8...Nice work! Curious what the improvement is on an 8 way machine?Anonymousnoreply@blogger.com