X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 8DD469DC847 for ; Fri, 30 Dec 2005 04:38:11 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 12843-03 for ; Fri, 30 Dec 2005 04:38:11 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nproxy.gmail.com (nproxy.gmail.com [64.233.182.206]) by postgresql.org (Postfix) with ESMTP id BC1E29DC804 for ; Fri, 30 Dec 2005 04:38:08 -0400 (AST) Received: by nproxy.gmail.com with SMTP id p48so666167nfa for ; Fri, 30 Dec 2005 00:38:09 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=lmXQW5JCrSoI7A08w7kyuI+9bIvxXGgB0IN9lBGBstyhsnCGqYZbEGvlRIKMjFB+cxKRlFIiEGY73acF7sEflPl0eXW52PVnRbnf64W4nlsvHbU7LSNuJt7SzYHiUTwhh8bYaJp/x/d2ezH69P2sORlODgRUxyP3e0SnqLwJNeI= Received: by 10.48.215.17 with SMTP id n17mr417876nfg; Fri, 30 Dec 2005 00:38:09 -0800 (PST) Received: by 10.48.164.6 with HTTP; Fri, 30 Dec 2005 00:38:09 -0800 (PST) Message-ID: <45b42ce40512300038k7426786etfe6c3a6d0efffb39@mail.gmail.com> Date: Fri, 30 Dec 2005 08:38:09 +0000 From: Harry Jackson To: pgsql-performance@postgresql.org Subject: Re: CPU and RAM In-Reply-To: <87y82a5xgq.fsf@stark.xeocode.com> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: base64 Content-Disposition: inline References: <45b42ce40512211720t164ea389wa5bfd0cbae6c80e2@mail.gmail.com> <878xuc8o6h.fsf@stark.xeocode.com> <45b42ce40512240226u6918d965xbab48eaf72babbc2@mail.gmail.com> <87y82a5xgq.fsf@stark.xeocode.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.088 required=5 tests=[AWL=0.088] X-Spam-Score: 0.088 X-Spam-Level: X-Archive-Number: 200512/657 X-Sequence-Number: 16478 T24gMjQgRGVjIDIwMDUgMTA6MjU6MDkgLTA1MDAsIEdyZWcgU3RhcmsgPGdzc3RhcmtAbWl0LmVk dT4gd3JvdGU6Cj4KPiBIYXJyeSBKYWNrc29uIDxoYXJyeWphY2tzb25AZ21haWwuY29tPiB3cml0 ZXM6Cj4KPiA+IEkgYWx3YXlzIGxvb2sgYXQgdGhlIGV4cGxhaW4gcGxhbnMuCj4gPgo+ID4gPSMg ZXhwbGFpbiBzZWxlY3QgaXRlbV9pZCwgdGVybV9mcmVxdWVuY3kgZnJvbSByZXZlcnNlX2luZGV4 IHdoZXJlCj4gPiB0ZXJtX2lkID0gMjI3ODE7Cj4gPiAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICBRVUVSWSBQTEFOCj4gPiAtLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLQo+ID4gIEJpdG1hcCBIZWFwIFNjYW4gb24gcmV2ZXJzZV9pbmRleCAgKGNv c3Q9ODg0LjU3Li44NDQ0My4zNSByb3dzPTE1MDQ0OCB3aWR0aD04KQo+ID4gICAgUmVjaGVjayBD b25kOiAodGVybV9pZCA9IDIyNzgxKQo+ID4gICAgLT4gIEJpdG1hcCBJbmRleCBTY2FuIG9uIHJl dmVyc2VfaW5kZXhfdGVybV9pZF9pZHgKPiA+IChjb3N0PTAuMDAuLjg4NC41NyByb3dzPTE1MDQ0 OCB3aWR0aD0wKQo+ID4gICAgICAgICAgSW5kZXggQ29uZDogKHRlcm1faWQgPSAyMjc4MSkKPiA+ ICg0IHJvd3MpCj4KPiBDYW4geW91IHNlbmQgRVhQTEFJTiBBTkFMWVpFIGZvciB0aGlzIHF1ZXJ5 IGZvciBhIHByb2JsZW1hdGljIHRlcm1faWQ/IEFyZSB5b3UKPiByZWFsbHkgcmV0cmlldmluZyAx NTBrIHJlY29yZHMgbGlrZSBpdCBleHBlY3RzPyBJbiBhbiBPTFRQIGVudmlyb25tZW50IHRoYXQn cwo+IGFuIGF3ZnVsIGxvdCBvZiByZWNvcmRzIHRvIGJlIHJldHJpZXZpbmcgYW5kIG1pZ2h0IGV4 cGxhaW4geW91ciBoaWdoIENQVSB1c2FnZQo+IGFsbCBvbiBpdHMgb3duLgoKVGhlIGFib3ZlIGlz IHdpdGggdGhlIHByb2JsZW1hdGljIHRlcm1faWQgOykKClRoZSBhYm92ZSBjb21lcyBpbiBhdCBh cm91bmQgMS80IG9mIGEgc2Vjb25kIHdoaWNoIGlzIGZpbmUgZm9yIG5vdyBidXQKd2lsbCBjYXVz ZSBtZSBzZXZlcmUgcHJvYmxlbXMgaW4gYSBmZXcgbW9udGhzIHdoZW4gdGhlIHNpemUgb2YgdGVo CmRhdGFiYXNlIHN3ZWxscy4KCj4gMjUwbXMgbWlnaHQgYmUgYXMgZ29vZCBhcyB5b3UnbGwgZ2V0 IGZvciAxNTBrIHJlY29yZHMuIEknbSBub3Qgc3VyZSBwcmVjYWNoaW5nCj4gdGhhdCBtYW55IHJl Y29yZHMgd2lsbCBoZWxwIHlvdS4gWW91J3JlIHN0aWxsIGdvaW5nIHRvIGhhdmUgdG8gcmVhZCB0 aGVtIGZyb20KPiBzb21ld2hlcmUuCgpUaGlzIGlzIHdoYXQgSSBhbSB0aGlua2luZy4gSSBoYXZl IHRyaWVkIHZhcmlvdXMgbWV0aG9kcyB0byByZWR1Y2UgdGhlCnRpbWUuIEkgZXZlbiB0cmllZCB0 byB1c2UgIm9yZGVyIGJ5IiB0aGVuIHJlZHVjZSB0aGUgYW1vdW50IG9mIGRhdGEgdG8KNTBLIHJl Y29yZHMgdG8gc2VlIGlmIHRoaXMgd291bGQgd29yayBidXQgaXQgY2FtZSBpbiBhdCBhcm91bmQg dGhlCnNhbWUgYW1vdW50IG9mIHRpbWUuIEl0IGlzIGZhc3RlciBpZiBJIHVzZSB0aGUgZm9sbG93 aW5nIHRob3VnaCBidXQKbm90IGJ5IG11Y2guCgo9IyBleHBsYWluIHNlbGVjdCAqIGZyb20gcmV2 ZXJzZV9pbmRleCB3aGVyZSB0ZXJtX2lkID0gMjI3ODEgb3JkZXIgYnkKdGVybV9mcmVxdWVuY3kg REVTQyBsaW1pdCAzMDAwMDsKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICBRVUVSWSBQTEFOCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tCiBMaW1pdCAgKGNvc3Q9NjczMzcuODcuLjY3NDEy Ljg3IHJvd3M9MzAwMDAgd2lkdGg9MTIpCiAgIC0+ICBTb3J0ICAoY29zdD02NzMzNy44Ny4uNjc1 NjUuMjYgcm93cz05MDk1NiB3aWR0aD0xMikKICAgICAgICAgU29ydCBLZXk6IHRlcm1fZnJlcXVl bmN5CiAgICAgICAgIC0+ICBJbmRleCBTY2FuIHVzaW5nIHJldmVyc2VfaW5kZXhfdGVybV9pZF9p ZHggb24KcmV2ZXJzZV9pbmRleCAgKGNvc3Q9MC4wMC4uNTk4NDYuMzMgcm93cz05MDk1NiB3aWR0 aD0xMikKICAgICAgICAgICAgICAgSW5kZXggQ29uZDogKHRlcm1faWQgPSAyMjc4MSkKKDUgcm93 cykKCkkgd2FzIGFjdHVhbGx5IHN1cHJpc2VkIGJ5IHRoaXMgYW5kIGl0IHNob3dzIHRoYXQgd2hh dGV2ZXIgcm91dGluZXMKUG9zdGdyZXNxbCBpcyB1c2luZyB0byBzb3J0IHRoZSBkYXRhIGl0cyBw cmV0dHkgYmxvb2R5IGZhc3QuIFRoZSB0b3RhbApzb3J0IHRpbWUgZm9yIDExMEsgcmVjb3JkcyBp cyBhYm91dCAxOTNtcy4gVGhlIGl0cyByZXRyaWV2YWwgYWZ0ZXIKdGhhdC4gV2hhdCBhbHNvIHN1 cHJpc2VkIG1lIGlzIHRoYXQgd2l0aG91dCB0aGUgc29ydAoKc2VsZWN0ICogZnJvbSByZXZlcnNl X2luZGV4IHdoZXJlIHRlcm1faWQgPSAyMjc4MTsKCmlzIHNsb3dlciB0aGFuCgpzZWxlY3QgaXRl bV9pZCwgdGVybV9mcmVxdWVuY3kgZnJvbSByZXZlcnNlX2luZGV4IHdoZXJlIHRlcm1faWQgPSAy Mjc4MTsKCmJ1dCB3aXRoIHRoZSBzb3J0IGFuZCBsaW1pdCBhZGRlZAoKc2VsZWN0ICogZnJvbSBy ZXZlcnNlX2luZGV4IHdoZXJlIHRlcm1faWQgPSAyMjc4MSBvcmRlciBieQp0ZXJtX2ZyZXF1ZW5j eSBERVNDIGxpbWl0IDMwMDAwOwoKaXMgZmFzdGVyIHRoYW4KCnNlbGVjdCBpdGVtX2lkLCB0ZXJt X2ZyZXF1ZW5jeSBmcm9tIHJldmVyc2VfaW5kZXggd2hlcmUgdGVybV9pZCA9CjIyNzgxIG9yZGVy IGJ5IHRlcm1fZnJlcXVlbmN5IERFU0MgbGltaXQgMzAwMDA7Cgo+IEkgZ3Vlc3MgY2x1c3Rlcmlu ZyBvbiB0ZXJtX2lkIG1pZ2h0IHNwZWVkIHRoaXMgdXAgYnkgcHV0dGluZyBhbGwgdGhlIHJlY29y ZHMKPiBiZWluZyByZXRyaWV2ZWQgdG9nZXRoZXIuIEl0IG1pZ2h0IGFsc28gbGV0IHRoZSBwbGFu bmVyIHVzZSBhIHBsYWluIGluZGV4IHNjYW4KPiBpbnN0ZWFkIG9mIGEgYml0bWFwIHNjYW4gYW5k IGdldCB0aGUgc2FtZSBiZW5lZml0LgoKWWVwLiBJIGNsdXN0ZXJlZCBvbiB0aGUgdGVybV9pZCBp bmRleCBhZ2FpbiBiZWZvcmUgcnVubmluZyB0aGUgYWJvdmUKZXhwbGFpbiBhbmQgdGhpcyB0aW1l IHdlIGhhdmUgYSBwbGFpbiBpbmRleCBzY2FuLgoKPiA+IFRoZSBuZXh0IHF1ZXJ5IGFic29sdXRl bHkgZmxpZXMgYnV0IGl0IHdvdWxkIGhhdmUgYmVlbiB0aGUgb25lIEkgd291bGQKPiA+IGhhdmUg ZXhwZWN0ZWQgdG8gYmUgYSBsb3Qgc2xvd2VyLgo+ID4gLi4uCj4gPiBUaGlzIGNvbWVzIGluIHVu ZGVyIDEwLjZtcyB3aGljaCBpcyBhc3RvdW5kaW5nIGFuZCBJIGFtIG1vcmUgdGhhbgo+ID4gaGFw cHkgd2l0aCB0aGUgcGVyZm9ybWFuY2UgdG8gYmUgaGFkIGZyb20gaXQuCj4KPiBPdXQgb2YgY3Vy aW9zaXR5IGl0IHdvdWxkIGJlIGludGVyZXN0aW5nIHRvIHNlZSB0aGUgRVhQTEFJTiBBTkFMWVpF IGZyb20gdGhpcwo+IHRvby4KCgogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICBRVUVSWSBQTEFOCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0KIEJpdG1hcCBIZWFwIFNjYW4gb24gaXRlbSBpICAoY29z dD04LjAxLi4xNi4xOCByb3dzPTQgd2lkdGg9NDc4KQogICBSZWNoZWNrIENvbmQ6ICgoaXRlbV9p ZCA9IDIwMDA2MjkzKSBPUiAoaXRlbV9pZCA9IDIwMDk3MDY1KSBPUgooaXRlbV9pZCA9IDIwMTAx MDE0KSBPUiAoaXRlbV9pZCA9IDIwMTAxMDE1KSkKICAgLT4gIEJpdG1hcE9yICAoY29zdD04LjAx Li44LjAxIHJvd3M9NCB3aWR0aD0wKQogICAgICAgICAtPiAgQml0bWFwIEluZGV4IFNjYW4gb24g aXRlbV9pdGVtX2lkX3BrICAoY29zdD0wLjAwLi4yLjAwCnJvd3M9MSB3aWR0aD0wKQogICAgICAg ICAgICAgICBJbmRleCBDb25kOiAoaXRlbV9pZCA9IDIwMDA2MjkzKQogICAgICAgICAtPiAgQml0 bWFwIEluZGV4IFNjYW4gb24gaXRlbV9pdGVtX2lkX3BrICAoY29zdD0wLjAwLi4yLjAwCnJvd3M9 MSB3aWR0aD0wKQogICAgICAgICAgICAgICBJbmRleCBDb25kOiAoaXRlbV9pZCA9IDIwMDk3MDY1 KQoKPHNuaXAgbG90cyBvZiBzaW5nbGUgaXRlbV9pZCBiaXRtYXAgaW5kZXggc2NhbnM+CgogICAg ICAgICAtPiAgQml0bWFwIEluZGV4IFNjYW4gb24gaXRlbV9pdGVtX2lkX3BrICAoY29zdD0wLjAw Li4yLjAwCnJvd3M9MSB3aWR0aD0wKQogICAgICAgICAgICAgICBJbmRleCBDb25kOiAoaXRlbV9p ZCA9IDIwMTAxMDE0KQogICAgICAgICAtPiAgQml0bWFwIEluZGV4IFNjYW4gb24gaXRlbV9pdGVt X2lkX3BrICAoY29zdD0wLjAwLi4yLjAwCnJvd3M9MSB3aWR0aD0wKQogICAgICAgICAgICAgICBJ bmRleCBDb25kOiAoaXRlbV9pZCA9IDIwMTAxMDE1KQoKCkFub3RoZXIgaW50ZXJldGluZyB0aGlu ZyBJIG5vdGljZWQgd2FzIHRoZSBzaXplIG9mIHRoZSB0YWJsZXMgYW5kCmluZGV4ZXMgYWZ0ZXIg dGhlIGNsdXN0ZXIgb3BlcmF0aW9uCgpCRUZPUkU6CiAgICAgICAgICByZWxuYW1lICAgICAgICAg IHwgICBieXRlcyAgIHwga2J5dGVzIHwgcmVsa2luZCB8IG1iCi0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLSstLS0tLS0tLS0tLSstLS0tLS0tLSstLS0tLS0tLS0rLS0tLS0KIHJldmVyc2VfaW5k ZXggICAgICAgICAgICAgfCA4ODQyOTM2MzIgfCA4NjM1NjggfCByICAgICAgIHwgODQzCiByZXZl cnNlX2luZGV4X3BrICAgICAgICAgIHwgNTQ4MTI2NzIwIHwgNTM1MjgwIHwgaSAgICAgICB8IDUy MgogcmV2ZXJzZV9pbmRleF90ZXJtX2lkX2lkeCB8IDQxNTI2MDY3MiB8IDQwNTUyOCB8IGkgICAg ICAgfCAzOTYKCkFGVEVSOgogcmV2ZXJzZV9pbmRleCAgICAgICAgICAgICB8IDYzNTk0NDk2MCB8 IDYyMTA0MCB8IHIgICAgICAgfCA2MDYKIHJldmVyc2VfaW5kZXhfcGsgICAgICAgICAgfCAzMjI2 MDA5NjAgfCAzMTUwNDAgfCBpICAgICAgIHwgMzA3CiByZXZlcnNlX2luZGV4X3Rlcm1faWRfaWR4 IHwgMjU3NjIyMDE2IHwgMjUxNTg0IHwgaSAgICAgICB8IDI0NQoKVGhpcyBkYXRhYmFzZSBoYXMg YXV0b3ZhY3V1bSBydW5uaW5nIGJ1dCBpdCBsb29rcyBsaWtlIHRoZXJlIGlzIGEgbG90Cm9mIHNw YWNlIGluIHBhZ2VzIG9uIGRpc2sgdGhhdCBpcyBub3QgYmVpbmcgdXNlZC4gSXMgdGhpcyBhIHRy YWRlIG9mZgp3aGVuIHVzaW5nIE1WQ0M/CgotLQpIYXJyeQpodHRwOi8vd3d3LnVrbHVnLmNvLnVr Cmh0dHA6Ly93d3cuaGphY2tzb24ub3JnCg==