Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 3876E632F98 for ; Thu, 12 Mar 2009 15:08:56 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 94116-03 for ; Thu, 12 Mar 2009 15:08:47 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from EXHUB018-3.exch018.msoutlookonline.net (exhub018-3.exch018.msoutlookonline.net [64.78.17.18]) by mail.postgresql.org (Postfix) with ESMTP id D64F3632662 for ; Thu, 12 Mar 2009 15:08:48 -0300 (ADT) Received: from EXVMBX018-1.exch018.msoutlookonline.net ([64.78.17.47]) by EXHUB018-3.exch018.msoutlookonline.net ([64.78.17.18]) with mapi; Thu, 12 Mar 2009 11:08:47 -0700 From: Scott Carey To: Gregory Stark , =?utf-8?B?R3J6ZWdvcnogSmHFm2tpZXdpY3o=?= CC: Kevin Grittner , "pgsql-performance@postgresql.org" , "Jignesh K. Shah" Date: Thu, 12 Mar 2009 11:08:44 -0700 Subject: Re: Proposal of tunable fix for scalability of 8.4 Thread-Topic: Proposal of tunable fix for scalability of 8.4 Thread-Index: AcmjNXZlG3gSsnfeTl63UlI/pM4TGAACB5Qz Message-ID: In-Reply-To: <87k56u652a.fsf@oxford.xeocode.com> Accept-Language: en-US Content-Language: en X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: en-US Content-Type: multipart/alternative; boundary="_000_C5DE9DBC3387scottrichrelevancecom_" MIME-Version: 1.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=AWL=-0.000, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200903/133 X-Sequence-Number: 33055 --_000_C5DE9DBC3387scottrichrelevancecom_ Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 T24gMy8xMi8wOSAxMDowOSBBTSwgIkdyZWdvcnkgU3RhcmsiIDxzdGFya0BlbnRlcnByaXNlZGIu Y29tPiB3cm90ZToNCg0KDQpSYW0tcmVzaWRlbnQgdXNlIGNhc2VzIGFyZSBlbnRpcmVseSB2YWxp ZCBhbmQgd29ydGggdGVzdGluZywgYnV0IGluIHRob3NlIHVzZQ0KY2FzZXMgeW91IHdvdWxkIHdh bnQgdG8gaGF2ZSBhYm91dCBhcyBtYW55IHByb2Nlc3NlcyBhcyB5b3UgaGF2ZSBwcm9jZXNzZXMu DQoNCldpdGhpbiBhIGZhY3RvciBvZiB0d28gb3Igc28sIHllcy4gIEhvd2V2ZXIsIHdoZXJlIGlu IGhpcyByZXN1bHRzIGRvZXMgaXQgc2hvdyB0aGF0IHRoZXJlIGFyZSAxMDAwIGFjdGl2ZSBwb3N0 Z3JlcyBjb25uZWN0aW9ucz8gIFdoYXQgaWYgdGhlIHRlc3Qgc2NyaXB0IGlzIHRoZSBtb3N0IHZh bGlkIHR5cGU6ICBlbXVsYXRpbmcgYXBwbGljYXRpb24gY29tcHV0ZSBhbmQgc2xlZXAgdGltZSBi ZXR3ZWVuIHJlcXVlc3RzPw0KDQpXaGF0IGl0IGlzIHNob3dpbmcgaXMg4oCcVXNlcnPigJ0uICBX ZSBkb27igJl0IGtub3cgdGhlIHJlbGF0aW9uc2hpcCBiZXR3ZWVuIHRob3NlIGFuZCBhY3RpdmUg cG9zdGdyZXMgY29ubmVjdGlvbnMuICBZb3VyIGNvbnRlbnRpb24gaXMgT05MWSB2YWxpZCBmb3Ig YWN0aXZlIHBvc3RncmVzIHByb2Nlc3Nlcy4NCg0KWWVzLCB0aGUgdGVzdCBjb3VsZCBiZSBpbnZh bGlkIGlmIGl0IGlzIGFydGlmaWNpYWxseSBtYWtpbmcgYWxsIHVzZXJzIGJhbmcgdXAgb24gdGhl IHNhbWUgbG9ja3MgYnkgZm9yIGV4YW1wbGUsIGhhdmluZyB0aGVtIGFsbCBhY2Nlc3MgdGhlIHNh bWUgcm93cy4gIEhvd2V2ZXIsIGlmIHRoaXMgd2FzIHdoYXQgZXhwbGFpbnMgdGhlIHJlc3VsdHMg YXJvdW5kIHRoZSB1c2VyIGNvdW50IGJlaW5nIGFib3V0IGVxdWFsIHRvIENQVSB0aHJlYWRzLCB0 aGVuIHRoZSB0aHJvdWdocHV0IHdvdWxkIGhhdmUgc3RvcHBlZCBncm93aW5nIGFyb3VuZCB3aGVy ZSB0aGUgdXNlciBjb3VudCBnb3QgbmVhciB0aGUgQ1BVIHRocmVhZHMsIG5vdCBhZnRlciBhIGNv dXBsZSB0aG91c2FuZC4NCg0KVGhlIOKAmGZpbmdlcnByaW504oCZIG9mIHRoaXMgbG9hZCB0ZXN0 IOKAlCBsaW5lYXIgc2NhbGluZyB1cCB0byBhIHBvaW50LCB0aGVuIGEgcGVhayBhbmQgZHJvcG9m ZiDigJQgaXMgb25lIG9mIGEgdGVzdCB3aXRoIHBhY2VkIHVzZXJzIG5vdCBvbmUgd2l0aCBhcnRp ZmljaWFsIGxvY2tpbmcgYWZmZWN0aW5nIHJlc3VsdHMgYXQgbG93IHVzZXIgY291bnRzLiAgTW9y ZSBkYXRhIHdvdWxkIGhlbHAsIGJ1dCBhcnRpZmljaWFsIGxvY2sgY29udGVudGlvbiB3aXRoIGxv dyB1c2VyIGNvdW50IHdvdWxkIGhhdmUgc2hvd24gdXAgYXQgbG93IHVzZXIgY291bnQsIG5vdCBh ZnRlciAxMDAwIHVzZXJzLiAgVGhlcmUgYXJlIHNvbWUgZGlmZmljdWx0IHRvIG1hbmlwdWxhdGUg d2F5cyB0byBmYWtlIHRoaXMgb3V0ICh3aGljaCBpcyB3aHkgQ1BVJSBhbmQgY29udGV4dCBzd2l0 Y2ggcmF0ZSBkYXRhIHdvdWxkIGhlbHApLiAgVGhpcyBpcyBtb3N0IGxpa2VseSBhIOKAmHBhY2Vk IHVzZXLigJkgcHJvZmlsZS4NCg0KVGhlIHVzZSBjYXNlIHdoZXJlIGhhdmluZyBsYXJnZXIgbnVt YmVyIG9mIGNvbm5lY3Rpb25zIHRoYW4gcHJvY2Vzc29ycyBtYWtlcw0Kc2Vuc2UgaXMgd2hlbiB0 aGV5J3JlIGJsb2NrZWQgb24gZGlzayBpL28gKG9yIG5ldHdvcmsgaS9vIG9yIHdoYXRldmVyIGVs c2UNCm90aGVyIHRoYW4gY3B1KS4NCg0KVW0sIG9yIGFyZSBpZGxlIGluIGEgY29ubmVjdGlvbiBw b29sIGZvciAxMDBtcy4gIFRoZXJlIGlzIG5vIHN1Y2ggdGhpbmcgYXMgYSBwZXJmZWN0bHkgc2l6 ZWQgY29ubmVjdGlvbiBwb29sLiAgQW5kIHRoZXJlIGlzIG5vdGhpbmcgd3Jvbmcgd2l0aCBzb21l IGlkbGUgY29ubmVjdGlvbnMuDQoNCg0KQW5kIGFzIGFsd2F5cyB0aGUgcXVlc3Rpb24gd291bGQg YmUgd2hldGhlciB0aGUgY29kZSBkZXNpZ25lZCBmb3IgdGhpcw0KbWlzY29uZmlndXJlZCBzZXR1 cCBpcyB3b3J0aCB0aGUgbWFpbnRlbmFuY2UgZWZmb3J0IGlmIGl0J3Mgbm90IGhlbHBpbmcNCnBy b3Blcmx5IGNvbmZpZ3VyZWQgc2V0dXBzLg0KDQpOb3cgeW91IGFyZSBqdXN0IGFzc3VtaW5nIGl0 cyBtaXNjb25maWd1cmVkLiAgSeKAmWQgd2FnZXIgcXVpdGUgYSBiaXQgaXQgaGVscHMgcHJvcGVy bHkgY29uZmlndXJlZCBzZXR1cHMgdG9vIHNvIGxvbmcgYXMgdGhleSBoYXZlIGxvdHMgb2YgaGFy ZHdhcmUgdGhyZWFkcy4NCg0KDQoNCg== --_000_C5DE9DBC3387scottrichrelevancecom_ Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: base64 PEhUTUw+DQo8SEVBRD4NCjxUSVRMRT5SZTogUHJvcG9zYWwgb2YgdHVuYWJsZSBmaXggZm9yIHNj YWxhYmlsaXR5IG9mIDguNDwvVElUTEU+DQo8L0hFQUQ+DQo8Qk9EWT4NCjxGT05UIEZBQ0U9IkNh bGlicmksIFZlcmRhbmEsIEhlbHZldGljYSwgQXJpYWwiPjxTUEFOIFNUWUxFPSdmb250LXNpemU6 MTFwdCc+T24gMy8xMi8wOSAxMDowOSBBTSwgJnF1b3Q7R3JlZ29yeSBTdGFyayZxdW90OyAmbHQ7 PGEgaHJlZj0ic3RhcmtAZW50ZXJwcmlzZWRiLmNvbSI+c3RhcmtAZW50ZXJwcmlzZWRiLmNvbTwv YT4mZ3Q7IHdyb3RlOjxCUj4NCjxCUj4NCjwvU1BBTj48L0ZPTlQ+PEJMT0NLUVVPVEU+PEZPTlQg RkFDRT0iQ2FsaWJyaSwgVmVyZGFuYSwgSGVsdmV0aWNhLCBBcmlhbCI+PFNQQU4gU1RZTEU9J2Zv bnQtc2l6ZToxMXB0Jz48QlI+DQpSYW0tcmVzaWRlbnQgdXNlIGNhc2VzIGFyZSBlbnRpcmVseSB2 YWxpZCBhbmQgd29ydGggdGVzdGluZywgYnV0IGluIHRob3NlIHVzZTxCUj4NCmNhc2VzIHlvdSB3 b3VsZCB3YW50IHRvIGhhdmUgYWJvdXQgYXMgbWFueSBwcm9jZXNzZXMgYXMgeW91IGhhdmUgcHJv Y2Vzc2VzLjxCUj4NCjxCUj4NCjwvU1BBTj48L0ZPTlQ+PC9CTE9DS1FVT1RFPjxGT05UIEZBQ0U9 IkNhbGlicmksIFZlcmRhbmEsIEhlbHZldGljYSwgQXJpYWwiPjxTUEFOIFNUWUxFPSdmb250LXNp emU6MTFwdCc+V2l0aGluIGEgZmFjdG9yIG9mIHR3byBvciBzbywgeWVzLiAmbmJzcDtIb3dldmVy LCB3aGVyZSBpbiBoaXMgcmVzdWx0cyBkb2VzIGl0IHNob3cgdGhhdCB0aGVyZSBhcmUgMTAwMCBh Y3RpdmUgcG9zdGdyZXMgY29ubmVjdGlvbnM/ICZuYnNwO1doYXQgaWYgdGhlIHRlc3Qgc2NyaXB0 IGlzIHRoZSBtb3N0IHZhbGlkIHR5cGU6ICZuYnNwO2VtdWxhdGluZyBhcHBsaWNhdGlvbiBjb21w dXRlIGFuZCBzbGVlcCB0aW1lIGJldHdlZW4gcmVxdWVzdHM/ICZuYnNwOzxCUj4NCjxCUj4NCldo YXQgaXQgaXMgc2hvd2luZyBpcyAmIzgyMjA7VXNlcnMmIzgyMjE7LiAmbmJzcDtXZSBkb24mIzgy MTc7dCBrbm93IHRoZSByZWxhdGlvbnNoaXAgYmV0d2VlbiB0aG9zZSBhbmQgYWN0aXZlIHBvc3Rn cmVzIGNvbm5lY3Rpb25zLiAmbmJzcDtZb3VyIGNvbnRlbnRpb24gaXMgT05MWSB2YWxpZCBmb3Ig YWN0aXZlIHBvc3RncmVzIHByb2Nlc3Nlcy48QlI+DQo8QlI+DQpZZXMsIHRoZSB0ZXN0IGNvdWxk IGJlIGludmFsaWQgaWYgaXQgaXMgYXJ0aWZpY2lhbGx5IG1ha2luZyBhbGwgdXNlcnMgYmFuZyB1 cCBvbiB0aGUgc2FtZSBsb2NrcyBieSBmb3IgZXhhbXBsZSwgaGF2aW5nIHRoZW0gYWxsIGFjY2Vz cyB0aGUgc2FtZSByb3dzLiAmbmJzcDtIb3dldmVyLCBpZiB0aGlzIHdhcyB3aGF0IGV4cGxhaW5z IHRoZSByZXN1bHRzIGFyb3VuZCB0aGUgdXNlciBjb3VudCBiZWluZyBhYm91dCBlcXVhbCB0byBD UFUgdGhyZWFkcywgdGhlbiB0aGUgdGhyb3VnaHB1dCB3b3VsZCBoYXZlIHN0b3BwZWQgZ3Jvd2lu ZyBhcm91bmQgd2hlcmUgdGhlIHVzZXIgY291bnQgZ290IG5lYXIgdGhlIENQVSB0aHJlYWRzLCBu b3QgYWZ0ZXIgYSBjb3VwbGUgdGhvdXNhbmQuPEJSPg0KPEJSPg0KVGhlICYjODIxNjtmaW5nZXJw cmludCYjODIxNzsgb2YgdGhpcyBsb2FkIHRlc3QgJiM4MjEyOyBsaW5lYXIgc2NhbGluZyB1cCB0 byBhIHBvaW50LCB0aGVuIGEgcGVhayBhbmQgZHJvcG9mZiAmIzgyMTI7IGlzIG9uZSBvZiBhIHRl c3Qgd2l0aCBwYWNlZCB1c2VycyBub3Qgb25lIHdpdGggYXJ0aWZpY2lhbCBsb2NraW5nIGFmZmVj dGluZyByZXN1bHRzIGF0IGxvdyB1c2VyIGNvdW50cy4gJm5ic3A7TW9yZSBkYXRhIHdvdWxkIGhl bHAsIGJ1dCBhcnRpZmljaWFsIGxvY2sgY29udGVudGlvbiB3aXRoIGxvdyB1c2VyIGNvdW50IHdv dWxkIGhhdmUgc2hvd24gdXAgYXQgbG93IHVzZXIgY291bnQsIG5vdCBhZnRlciAxMDAwIHVzZXJz LiAmbmJzcDtUaGVyZSBhcmUgc29tZSBkaWZmaWN1bHQgdG8gbWFuaXB1bGF0ZSB3YXlzIHRvIGZh a2UgdGhpcyBvdXQgKHdoaWNoIGlzIHdoeSBDUFUlIGFuZCBjb250ZXh0IHN3aXRjaCByYXRlIGRh dGEgd291bGQgaGVscCkuICZuYnNwO1RoaXMgaXMgbW9zdCBsaWtlbHkgYSAmIzgyMTY7cGFjZWQg dXNlciYjODIxNzsgcHJvZmlsZS48QlI+DQo8L1NQQU4+PC9GT05UPjxCTE9DS1FVT1RFPjxGT05U IEZBQ0U9IkNhbGlicmksIFZlcmRhbmEsIEhlbHZldGljYSwgQXJpYWwiPjxTUEFOIFNUWUxFPSdm b250LXNpemU6MTFwdCc+PEJSPg0KVGhlIHVzZSBjYXNlIHdoZXJlIGhhdmluZyBsYXJnZXIgbnVt YmVyIG9mIGNvbm5lY3Rpb25zIHRoYW4gcHJvY2Vzc29ycyBtYWtlczxCUj4NCnNlbnNlIGlzIHdo ZW4gdGhleSdyZSBibG9ja2VkIG9uIGRpc2sgaS9vIChvciBuZXR3b3JrIGkvbyBvciB3aGF0ZXZl ciBlbHNlPEJSPg0Kb3RoZXIgdGhhbiBjcHUpLjxCUj4NCjxCUj4NCjwvU1BBTj48L0ZPTlQ+PC9C TE9DS1FVT1RFPjxGT05UIEZBQ0U9IkNhbGlicmksIFZlcmRhbmEsIEhlbHZldGljYSwgQXJpYWwi PjxTUEFOIFNUWUxFPSdmb250LXNpemU6MTFwdCc+VW0sIG9yIGFyZSBpZGxlIGluIGEgY29ubmVj dGlvbiBwb29sIGZvciAxMDBtcy4gJm5ic3A7VGhlcmUgaXMgbm8gc3VjaCB0aGluZyBhcyBhIHBl cmZlY3RseSBzaXplZCBjb25uZWN0aW9uIHBvb2wuICZuYnNwO0FuZCB0aGVyZSBpcyBub3RoaW5n IHdyb25nIHdpdGggc29tZSBpZGxlIGNvbm5lY3Rpb25zLjxCUj4NCjwvU1BBTj48L0ZPTlQ+PEJM T0NLUVVPVEU+PEZPTlQgRkFDRT0iQ2FsaWJyaSwgVmVyZGFuYSwgSGVsdmV0aWNhLCBBcmlhbCI+ PFNQQU4gU1RZTEU9J2ZvbnQtc2l6ZToxMXB0Jz48QlI+DQo8QlI+DQpBbmQgYXMgYWx3YXlzIHRo ZSBxdWVzdGlvbiB3b3VsZCBiZSB3aGV0aGVyIHRoZSBjb2RlIGRlc2lnbmVkIGZvciB0aGlzPEJS Pg0KbWlzY29uZmlndXJlZCBzZXR1cCBpcyB3b3J0aCB0aGUgbWFpbnRlbmFuY2UgZWZmb3J0IGlm IGl0J3Mgbm90IGhlbHBpbmc8QlI+DQpwcm9wZXJseSBjb25maWd1cmVkIHNldHVwcy4gPEJSPg0K PEJSPg0KPC9TUEFOPjwvRk9OVD48L0JMT0NLUVVPVEU+PEZPTlQgRkFDRT0iQ2FsaWJyaSwgVmVy ZGFuYSwgSGVsdmV0aWNhLCBBcmlhbCI+PFNQQU4gU1RZTEU9J2ZvbnQtc2l6ZToxMXB0Jz5Ob3cg eW91IGFyZSBqdXN0IGFzc3VtaW5nIGl0cyBtaXNjb25maWd1cmVkLiAmbmJzcDtJJiM4MjE3O2Qg d2FnZXIgcXVpdGUgYSBiaXQgaXQgaGVscHMgcHJvcGVybHkgY29uZmlndXJlZCBzZXR1cHMgdG9v IHNvIGxvbmcgYXMgdGhleSBoYXZlIGxvdHMgb2YgaGFyZHdhcmUgdGhyZWFkcy48QlI+DQo8L1NQ QU4+PC9GT05UPjxCTE9DS1FVT1RFPjxGT05UIEZBQ0U9IkNhbGlicmksIFZlcmRhbmEsIEhlbHZl dGljYSwgQXJpYWwiPjxTUEFOIFNUWUxFPSdmb250LXNpemU6MTFwdCc+PEJSPg0KPEJSPg0KPEJS Pg0KPC9TUEFOPjwvRk9OVD48L0JMT0NLUVVPVEU+DQo8L0JPRFk+DQo8L0hUTUw+DQoNCg== --_000_C5DE9DBC3387scottrichrelevancecom_--