X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id B158B9DCD59 for ; Wed, 7 Dec 2005 22:25:05 -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 67321-04 for ; Wed, 7 Dec 2005 22:25:09 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.199]) by postgresql.org (Postfix) with ESMTP id 452759DCB0A for ; Wed, 7 Dec 2005 22:25:03 -0400 (AST) Received: by zproxy.gmail.com with SMTP id 13so557529nzn for ; Wed, 07 Dec 2005 18:25:07 -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=HFSP+5ICTfeyr8/FltD0JsjU+lOuQbiY0ZPqARSc752yXO9+cfUHETX5SYklNrsLQertfw6s5V+FaMo79SUgydHYTtXIuf5n1Y3CMehq/Q+H3DwyXWCINOKWvEXPBGwYTS0qTOn7PS09UgI0A1gpjKaZavAo9mLmbLGiHzggjoE= Received: by 10.65.181.10 with SMTP id i10mr2447823qbp; Wed, 07 Dec 2005 18:25:07 -0800 (PST) Received: by 10.64.213.18 with HTTP; Wed, 7 Dec 2005 18:25:07 -0800 (PST) Message-ID: Date: Thu, 8 Dec 2005 10:25:07 +0800 From: Kathy Lo To: pgsql general , Scott Marlowe Subject: Re: Memory Leakage Problem In-Reply-To: <1133991204.11803.43.camel@state.g2switchworks.com> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: base64 Content-Disposition: inline References: <1133891282.11803.7.camel@state.g2switchworks.com> <1133991204.11803.43.camel@state.g2switchworks.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200512/415 X-Sequence-Number: 87978 T24gMTIvOC8wNSwgU2NvdHQgTWFybG93ZSA8c21hcmxvd2VAZzJzd2l0Y2h3b3Jrcy5jb20+IHdy b3RlOgo+IFBsZWFzZSBrZWVwIHJlcGxpZXMgb24gbGlzdCwgdGhpcyBtYXkgaGVscCBvdGhlcnMg aW4gdGhlIGZ1dHVyZSwgYW5kCj4gYWxzbywgZG9uJ3QgdG9wIHBvc3QgKGkuZS4gcHV0IHlvdXIg cmVzcG9uc2VzIGFmdGVyIG15IHJlc3BvbnNlcy4uLgo+IFRoYW5rcykKPgo+IE9uIFR1ZSwgMjAw NS0xMi0wNiBhdCAyMDoxNiwgS2F0aHkgTG8gd3JvdGU6Cj4gPiBGb3IgYSBiYWNrLWVuZCBkYXRh YmFzZSBzZXJ2ZXIgcnVubmluZyBQb3N0Z3Jlc3FsIDguMC4zLCBpdCdzIE9LLiBCdXQsCj4gPiB0 aGlzIHByb2JsZW0gc2VyaW91c2x5IGFmZmVjdHMgdGhlIHBlcmZvcm1hbmNlIG9mIG15IGFwcGxp Y2F0aW9uCj4gPiBzZXJ2ZXIuCj4gPgo+ID4gSSB1cGdyYWRlZCBteSBhcHBsaWNhdGlvbiBzZXJ2 ZXIgZnJvbQo+ID4KPiA+ICAgICBSZWRoYXQgNy4zCj4gPiAgICAgdW5peE9EQkMgMi4yLjQKPiA+ ICAgICBQb3N0Z3Jlc3FsIDcuMi4xIHdpdGggT0RCQyBkcml2ZXIKPiA+Cj4gPiB0bwo+ID4KPiA+ ICAgICBSZWRoYXQgOS4wCj4gPiAgICAgdW5peE9EQkMgMi4yLjExCj4gPiAgICAgUG9zdGdyZXNx bCA4LjAuMwo+ID4gICAgIHBzcWxvZGJjLTA4LjAxLjAxMDEKPiA+ICAgICBwZ19hdXRvdmFjdXVt IHJ1bnMgYXMgYmFja2dyb3VuZCBqb2IKPiA+Cj4gPiBCZWZvcmUgdXBncmFkaW5nLCB0aGUgYXBw bGljYXRpb24gc2VydmVyIHJ1bnMgcGVyZmVjdGx5LiBBZnRlcgo+ID4gdXBncmFkZSwgdGhpcyBw cm9ibGVtIGFwcGVhcnMuCj4gPgo+ID4gV2hlbiB0aGUgYXBwbGljYXRpb24gc2VydmVyIHJlY2Vp dmVzIHRoZSByZXF1ZXN0IGZyb20gYSBjbGllbnQsIGl0Cj4gPiB3aWxsIGFjY2VzcyB0aGUgYmFj ay1lbmQgZGF0YWJhc2Ugc2VydmVyIHVzaW5nIGJvdGggc2ltcGxlIGFuZCBjb21wbGV4Cj4gPiBx dWVyeS4gVGhlbiwgaXQgd2lsbCBjcmVhdGUgYSBkYXRhYmFzZSBsb2NhbGx5IHRvIHN0b3JlIHRo ZSBtYXRjaGVkCj4gPiByb3dzIGZvciBkYXRhIHByb2Nlc3NpbmcuIEFmdGVyIHNvbWUgZGF0YSBw cm9jZXNzaW5nLCBpdCB3aWxsIHJldHVybgo+ID4gdGhlIHJlc3VsdCB0byB0aGUgcmVxdWVzdGVk IGNsaWVudC4gSWYgdGhlIGNsaWVudCBmaW5pc2hlcyBicm93c2luZwo+ID4gdGhlIHJlc3VsdCwg aXQgd2lsbCBkcm9wIHRoZSBsb2NhbCBkYXRhYmFzZS4KPgo+IE9LLCB0aGVyZSBjb3VsZCBiZSBh IGxvdCBvZiBwcm9ibGVtcyBoZXJlLiAgQXJlIHlvdSBhY3R1YWxseSBkb2luZwo+ICJjcmVhdGUg ZGF0YWJhc2UgLi4uIiBmb3IgZWFjaCBvZiB0aGVzZSB0aGluZ3M/ICBJJ20gbm90IHN1cmUgdGhh dCdzIGEKPiByZWFsIGdvb2QgaWRlYS4gIEV2ZW4gY3JlYXRlIHNjaGVtYSwgd2hpY2ggd291bGQg YmUgYmV0dGVyLCBzdHJpa2VzIG1lCj4gYXMgbm90IHRoZSBiZXN0IHdheSB0byBoYW5kbGUgdGhp cy4KPgpBY3R1YWxseSwgbXkgcHJvZ3JhbSBpcyB3cml0dGVuIHVzaW5nIEMrKyBzbyBJIHVzZSAi Y3JlYXRlIGRhdGFiYXNlIgpTUUwgdG8gY3JlYXRlIGRhdGFiYXNlLiBJZiBub3QgdGhlIGJlc3Qg d2F5LCBwbGVhc2UgdGVsbCBtZSBhbm90aGVyCm1ldGhvZCB0byBjcmVhdGUgZGF0YWJhc2UgaW4g QysrIHByb2dyYW0uCgo+ID4gQXQgdGhlIHNhbWUgdGltZSwgdGhpcyBhcHBsaWNhdGlvbiBzZXJ2 ZXIgY2FuIHNlcnZlIG1hbnkgbWFueSBjbGllbnRzCj4gPiBzbyB0aGUgYXBwbGljYXRpb24gc2Vy dmVyIGhhcyBtYW55IG1hbnkgbG9jYWwgZGF0YWJhc2VzIGF0IHRoZSBzYW1lCj4gPiB0aW1lLgo+ Cj4gQXJlIHlvdSBzdXJlIHRoYXQgeW91J3JlIGJldHRlciBvZmYgd2l0aCBkYXRhYmFzZXMgb24g eW91ciBhcHBsaWNhdGlvbgo+IHNlcnZlcj8gIFlvdSBtaWdodCBiZSBiZXR0ZXIgb2ZmIHdpdGgg ZWl0aGVyIHJ1bm5pbmcgdGhlc2UgdGVtcCBkYnMgb24KPiB0aGUgYmFja2VuZCBzZXJ2ZXIgaW4g dGhlIHNhbWUgY2x1c3Rlciwgb3IgY3JlYXRpbmcgYSBjbHVzdGVyIGp1c3QgZm9yCj4gdGhlc2Ug am9icyB0aGF0IGlzIHNvbWV3aGF0IG1vcmUgY29uc2VydmF0aXZlIGluIGl0cyBtZW1vcnkgdXNh Z2UuICBJCj4gd291bGQgbGVhbiB0b3dhcmRzIGRvaW5nIHRoaXMgYWxsIG9uIHRoZSBiYWNrZW5k IHNlcnZlciBpbiBvbmUgZGF0YWJhc2UKPiB1c2luZyBtdWx0aXBsZSBzY2hlbWFzLgo+CkJlY2F1 c2UgdGhlIGRhdGEgYXJlIGRpc3RyaWJ1dGVkIGluIG1hbnkgYmFjay1lbmQgZGF0YWJhc2Ugc2Vy dmVycwoocGh5c2ljYWxseSwgaW4gZGlmZmVyZW50IGhhcmR3YXJlIG1hY2hpbmVzKSwgSSBuZWVk IHRvIHVzZQpBcHBsaWNhdGlvbiBzZXJ2ZXIgdG8gdGVtcG9yYXJpbHkgc3RvcmUgdGhlIGRhdGEg cmV0cmlldmVkIGZyb20KZGlmZmVyZW50IG1hY2hpbmVzIGFuZCB0aGVuIGRvIHRoZSBkYXRhIHBy b2Nlc3NpbmcuIEFuZCwgZm9yIHNlY3VyaXR5CnJlYXNvbiwgYWxsIHRoZSB1c2VycyBjYW5ub3Qg ZGlyZWN0bHkgYWNjZXNzIHRoZSBiYWNrLWVuZCBkYXRhYmFzZQpzZXJ2ZXJzLiBTbywgSSB1c2Ug dGhlIGRhdGFiYXNlIGluIGFwcGxpY2F0aW9uIHNlcnZlciB0byBrZWVwIHRoZQpyZXN1bHQgb2Yg ZGF0YSBwcm9jZXNzaW5nLgoKPiA+IEFmdGVyIHJ1bm5pbmcgdGhlIGFwcGxpY2F0aW9uIHNlcnZl ciBmb3IgYSBmZXcgZGF5cywgdGhlIG1lbW9yeSBvZiB0aGUKPiA+IGFwcGxpY2F0aW9uIHNlcnZl ciBuZWFybHkgdXNlZCB1cCBhbmQgc3RhcnQgdG8gdXNlIHRoZSBzd2FwIG1lbW9yeQo+ID4gYW5k LCBhcyBhIHJlc3VsdCwgdGhlIGFwcGxpY2F0aW9uIHNlcnZlciBydW5zIHZlcnkgdmVyeSBzbG93 IGFuZCB0aGUKPiA+IHVzZXJzIGNvbXBsYWluLgo+Cj4gQ291bGQgeW91IHByb3ZpZGUgdXMgd2l0 aCB5b3VyIGV2aWRlbmNlIHRoYXQgdGhlIG1lbW9yeSBpcyAidXNlZCB1cD8iCj4gV2hhdCBpcyB0 aGUgcHJvYmxlbSwgYW5kIHdoYXQgeW91IHBlcmNlaXZlIGFzIHRoZSBwcm9ibGVtLCBtYXkgbm90 IGJlCj4gdGhlIHNhbWUgdGhpbmcuICBJcyBpdCB0aGUgb3V0cHV0IG9mIHRvcCAvIGZyZWUsIGFu ZCBpZiBzbywgY291bGQgd2Ugc2VlCj4gaXQsIG9yIHdoYXRldmVyIG91dHB1dCBpcyBjb252aW5j aW5nIHlvdSB5b3UncmUgcnVubmluZyBvdXQgb2YgbWVtb3J5Pwo+CldoZW4gdGhlIHVzZXIgY29t cGxhaW5zIHRoZSBzeXN0ZW0gYmVjb21lcyB2ZXJ5IHNsb3csIEkgdXNlIHRvcCB0bwp2aWV3IHRo ZSBtZW1vcnkgc3RhdGlzdGljcy4KSW4gdG9wLCBJIGNhbm5vdCBmaW5kIGFueSBwcm9jZXNzZXMg dGhhdCB1c2Ugc28gbWFueSBtZW1vcnkuIEkganVzdApmb3VuZCB0aGF0IGFsbCB0aGUgbWVtb3J5 IHdhcyB1c2VkIHVwIGFuZCB0aGUgU3dhcCBtZW1vcnkgbmVhcmx5IHVzZWQKdXAuCgpJIHNhaWQg aXQgaXMgdGhlIHByb2JsZW0gYmVjYXVzZSwgYmVmb3JlIHVwZ3JhZGluZyB0aGUgYXBwbGljYXRp b24Kc2VydmVyLCBubyBtZW1vcnkgcHJvYmxlbSBldmVuIHJ1bm5pbmcgdGhlIGFwcGxpY2F0aW9u IHNlcnZlciBmb3IgMQptb250aC4gQWZ0ZXIgdXBncmFkaW5nIHRoZSBhcHBsaWNhdGlvbiBzZXJ2 ZXIsIHRoaXMgcHJvYmxlbSBhcHBlYXJzCmp1c3QgYWZ0ZXIgcnVubmluZyB0aGUgYXBwbGljYXRp b24gc2VydmVyIGZvciAxIHdlZWsuIFdoeSBoYXZpbmcgdGhpcwpCSUcgZGlmZmVyZW5jZSBiZXR3 ZWVuIHBvc3RncmVzcWwgNy4yLjEgb24gUmVkaGF0IDcuMyBhbmQgcG9zdGdyZXNxbAo4LjAuMyBv biBSZWRoYXQgOS4wPyBJIG9ubHkgdXBncmFkZSB0aGUgT1MsIHBvc3RncmVzcWwsIHVuaXhPREJD IGFuZApwb3N0Z3Jlc3FsIE9EQkMgZHJpdmVyLiBUaGUgcHJvZ3JhbSBJIHdyaXR0ZW4gSVMgVEhF IFNBTUUuCgo+ID4gSSB0ZXN0ZWQgdGhlIGFwcGxpY2F0aW9uIHNlcnZlciB3aXRob3V0IGFjY2Vz c2luZyB0aGUgbG9jYWwgZGF0YWJhc2UKPiA+IChub3Qgc3RvcmUgbWF0Y2hlZCByb3dzKS4gVGhl IHRlc3RpbmcgcHJvZ3JhbSBydW5uaW5nIGluIHRoZQo+ID4gYXBwbGljYXRpb24gc2VydmVyIGp1 c3QgcmV0cmlldmVkIHJvd3MgZnJvbSB0aGUgYmFjay1lbmQgZGF0YWJhc2UKPiA+IHNlcnZlciBh bmQgdGhlbiByZXR1cm5lZCB0byB0aGUgcmVxdWVzdGVkIGNsaWVudCBkaXJlY3RseS4gVGhlIG1l bW9yeQo+ID4gdXNhZ2Ugb2YgdGhlIGFwcGxpY2F0aW9uIHNlcnZlciBiZWNvbWVzIG5vcm1hbGx5 IGFuZCBpdCBjYW4gcnVuIGZvciBhCj4gPiBsb25nIHRpbWUuCj4KPiBBZ2Fpbiwgd2hhdCB5b3Ug dGhpbmsgaXMgbm9ybWFsLCBhbmQgd2hhdCBub3JtYWwgcmVhbGx5IGFyZSBtYXkgbm90IGJlCj4g dGhlIHNhbWUgdGhpbmcuICBFdmlkZW5jZS4gIFBsZWFzZSBzaG93IHVzIHRoZSBvdXRwdXQgb2Yg dG9wIC8gZnJlZSBvcgo+IHdoYXRldmVyIHRoYXQgaXMgc2hvd2luZyB0aGlzLgo+CkFmdGVyIEkg cmVjZWl2ZWQgdGhlIHVzZXIncyBjb21wbGFpbiwgSSBqdXN0IHVzZSB0b3AgdG8gdmlldyB0aGUK bWVtb3J5IHN0YXRpc3RpYy4gSSBmb3Jnb3QgdG8gc2F2ZSB0aGUgb3V0cHV0LiBCdXQsIEkgYW0g cnVubmluZyBhCnRlc3QgdG8gZ2V0IGJhY2sgdGhlIHByb2JsZW0uIFNvLCBhZnRlciBydW5uaW5n IHRoZSB0ZXN0LCBJIHdpbGwgZ2l2ZQp5b3UgdGhlIG91dHB1dCBvZiB0aGUgdG9wL2ZyZWUuCgo+ ID4gSSBmb3VuZCB0aGlzIHByb2JsZW0gYWZ0ZXIgSSB1cGdyYWRpbmcgdGhlIGFwcGxpY2F0aW9u IHNlcnZlci4KPiA+Cj4gPiBPbiAxMi83LzA1LCBTY290dCBNYXJsb3dlIDxzbWFybG93ZUBnMnN3 aXRjaHdvcmtzLmNvbT4gd3JvdGU6Cj4gPiA+IE9uIFR1ZSwgMjAwNS0xMi0wNiBhdCAwMzoyMiwg S2F0aHkgTG8gd3JvdGU6Cj4gPiA+ID4gSGksCj4gPiA+Cj4gPiA+ID4KPiA+ID4gPiBJbiB0aGlz IHByb2dyYW0sIGl0IHdpbGwgYWNjZXNzIHRoaXMgZGF0YWJhc2Ugc2VydmVyIHVzaW5nIHNpbXBs ZSBhbmQKPiA+ID4gPiBjb21wbGV4IChqb2luaW5nIHRhYmxlcykgU1FMIFNlbGVjdCBzdGF0ZW1l bnQgYW5kIHJldHJpZXZlIHRoZSBtYXRjaGVkCj4gPiA+ID4gcm93cy4gRm9yIGVhY2ggYWNjZXNz LCBpdCB3aWxsIGNvbm5lY3QgdGhlIGRhdGFiYXNlIGFuZCBkaXNjb25uZWN0IGl0Lgo+ID4gPiA+ Cj4gPiA+ID4gSSBmb3VuZCB0aGF0IHRoZSBtZW1vcnkgb2YgdGhlIGRhdGFiYXNlciBzZXJ2ZXIg bmVhcmx5IHVzZWQgdXAgKHRvdGFsCj4gMkcKPiA+ID4gUkFNKS4KPiA+ID4gPgo+ID4gPiA+IEFm dGVyIEkgc3RvcCB0aGUgcHJvZ3JhbSwgdGhlIHVzZWQgbWVtb3J5IGRpZCBub3QgZnJlZS4KPiA+ ID4KPiA+ID4gVW1tbW0uICBXaGF0IGV4YWN0bHkgZG8geW91IG1lYW4/ICBDYW4gd2Ugc2VlIHRo ZSBvdXRwdXQgb2YgdG9wIGFuZCAvIG9yCj4gPiA+IGZyZWU/ICBJJ20gZ3Vlc3NpbmcgdGhhdCB3 aGF0IFRvbSBzYWlkIGlzIHJpZ2h0LCB5b3UncmUganVzdCBzZWVpbmcgYQo+ID4gPiBub3JtYWwg c3RhdGUgb2YgaG93IHVuaXggZG9lcyB0aGluZ3MuCj4gPiA+Cj4gPiA+IElmIHlvdXIgb3V0cHV0 IG9mIGZyZWUgbG9va3MgbGlrZSB0aGlzOgo+ID4gPgo+ID4gPiAtYmFzaC0yLjA1YiQgZnJlZQo+ ID4gPiAgICAgICB0b3RhbCAgICAgICB1c2VkICAgICAgIGZyZWUgICAgIHNoYXJlZCAgICBidWZm ZXJzICAgICBjYWNoZWQKPiA+ID4gTWVtOjYwOTY5MTIgICAgNjA2OTU4OCAgICAgIDI3MzI0ICAg ICAgICAgIDAgICAgIDI2MDcyOCAgICA1NTQ3MjY0Cj4gPiA+IC0vKyBidWZmZXJzL2NhY2hlOiAg ICAgMjYxNTk2ICAgIDU4MzUzMTYKPiA+ID4gU3dhcDogICAgICA0MTkyODgwICAgICAgMTYzMjAg ICAgNDE3NjU2MAo+ID4gPgo+ID4gPiBUaGVuIHRoYXQncyBub3JtYWwuCj4gPiA+Cj4gPiA+IFRo YXQncyB0aGUgb3V0cHV0IG9mIGZyZWUgb24gYSBtYWNoaW5lIHdpdGggNiBnaWdzIHRoYXQgcnVu cyBhIHJlcG9ydGluZwo+ID4gPiBkYXRhYmFzZS4gIE5vdGUgdGhhdCB3aGlsZSBpdCBzaG93cyBh bG1vc3QgQUxMIHRoZSBtZW1vcnkgYXMgdXNlZCwgaXQgaXMKPiA+ID4gYmVpbmcgdXNlZCBieSB0 aGUga2VybmVsLCB3aGljaCBpcyBhIGdvb2QgdGhpbmcuICBOb3RlIHRoYXQgNTU0NzI2NCBvcgo+ ID4gPiBhYm91dCA5MCUgb2YgbWVtb3J5IGlzIGJlaW5nIHVzZWQgYXMga2VybmVsIGNhY2hlLiAg VGhhdCdzIGEgZ29vZCB0aGluZy4KPiA+ID4KPiA+ID4gTm90ZSB5b3UgY2FuIGFsc28gZ2V0IHlv dXJzZWxmIGluIHRyb3VibGUgd2l0aCB0b3AuICBJdCdzIG5vdCB1bmNvbW1vbgo+ID4gPiBmb3Ig c29tZW9uZSB0byBzZWUgYSBidW5jaCBvZiBwb3N0Z3JlcyBwcm9jZXNzZXMgZWFjaCBlYXRpbmcg dXAgNTAgb3IKPiA+ID4gbW9yZSBtZWdzIG9mIHJhbSwgYW5kIHBhbmljIGFuZCB0aGluayB0aGF0 IHRoZXkncmUgcnVubmluZyBvdXQgb2YKPiA+ID4gbWVtb3J5LCB3aGVuLCBpbiBmYWN0LCA0NCBt ZWcgZm9yIGVhY2ggb2YgdGhvc2UgcHJvY2Vzc2VzIGlzIHNoYXJlZCwgYW5kCj4gPiA+IHRoZSBy ZWFsIHVzYWdlIHBlciBiYWNrZW5kIGlzIDYgbWVncyBvciBsZXNzLgo+ID4gPgo+ID4gPiBEZWZp bml0ZWx5IGdyYWIgeW91cnNlbGYgYSBnb29kIHVuaXggLyBsaW51eCBzeXNhZG1pbiBndWlkZS4g IFRoZSAiaW4gYQo+ID4gPiBudXRzaGVsbCIgYm9va3MgZnJvbSBPJ1JlaWxsZXkgKHNwPykgYXJl IGEgZ29vZCBzdGFydGluZyBwb2ludC4KPiA+ID4KPiA+Cj4gPgo+ID4gLS0KPiA+IEthdGh5IExv Cj4KCgotLQpLYXRoeSBMbwo=