X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 5D504D1B241 for ; Wed, 26 May 2004 14:59:57 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 84086-06 for ; Wed, 26 May 2004 14:59:37 -0300 (ADT) Received: from fep11.012.net.il (fep11.012.net.il [212.117.129.244]) by svr1.postgresql.org (Postfix) with ESMTP id E6AB7D1B503 for ; Wed, 26 May 2004 14:59:33 -0300 (ADT) Received: from [127.0.0.1] ([80.178.88.219]) by fep11.012.net.il with ESMTP id <20040526175731.IPPO29697.fep11@[80.178.88.219]>; Wed, 26 May 2004 20:57:31 +0300 Received: from [127.0.0.1] ([127.0.0.1]) by [127.0.0.1] with ESMTP (SpamPal v1.50) sender ; 26 May 2004 21:00:35 +0300 Date: Wed, 26 May 2004 21:00:34 +0300 From: Vitaly Belman Reply-To: Vitaly Belman X-Priority: 3 (Normal) Message-ID: <3115838500.20040526210034@012.net.il> To: Josh Berkus Cc: pgsql-performance@postgresql.org Subject: Re: PostgreSQL caching In-Reply-To: <200405260917.35537.josh@agliodbs.com> References: <20792805375.20040521203337@012.net.il> <40B3C792.3020106@outputservices.com> <1673440625.20040526173356@012.net.il> <200405260917.35537.josh@agliodbs.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: base64 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=3.0 tagged_above=0.0 required=5.0 tests=MIME_BASE64_LATIN, MIME_BASE64_TEXT, PRIORITY_NO_NAME X-Spam-Level: *** X-Archive-Number: 200405/217 X-Sequence-Number: 7048 SGVsbG8gSm9zaCwNCg0KSkI+IE5vdCB0aGF0IHlvdSBjYW4ndCBpbXByb3Zl IHRoZSBxdWVyeSwganVzdCB0aGF0IGl0IG1pZ2h0IG5vdCBmaXgNCkpCPiB0 aGUgcHJvYmxlbS4NCg0KWWVzLCBJJ20gYXdhcmUgaXQgbWlnaHQgYmUgc2xv d2VyIHRoYW4gdGhlIExpbnV4IHZlcnNpb24sIGJ1dCB0aGVuLCBhcw0KeW91 IHNhaWQsIEkgc3RpbGwgY2FuIGltcHJvdmUgdGhlIHF1ZXJ5IChhcyBJIGRp ZCB3aXRoIHlvdXIgaGVscCBub3cpLg0KDQpCdXQgdHJ1ZSwgaWYgdGhlcmUn cyBzb21ldGhpbmcgYXdmdWxseSB3cm9uZyB3aXRoIFdpbjMyIHBvcnQNCnBl cmZvcm1hbmNlLCBJIG1pZ2h0IGJlIGRvaW5nIHNvbWUgb3ZlcndvcmsuLi4N Cg0KSkI+IFRoZXJlZm9yZSAuLi4geW91ciBkZXRhaWxlZCBmZWVkYmFjayBp cyBhcHByZWNpYXRlZCwgZXNwZWNpYWxseSBpZiB5b3UgY2FuDQpKQj4gY29t cGFyZSBzdHVmZiB0byB0aGUgc2FtZSBkYXRhYmFzZSBydW5uaW5nIG9uIGEg TGludXgsIFVuaXgsIG9yIEJTRCBtYWNoaW5lLg0KDQpJIGNhbid0IGVhc2ls eSBpbnN0YWxsIExpbnV4IHJpZ2h0IG5vdy4uIEJ1dCBJIGFtIGNvbnNpZGVy aW5nIHVzaW5nIGl0DQp0aHJvdWdoIFZNV2FyZS4gRG8geW91IHRoaW5rIGl0 IHdvdWxkIHN1ZmZpY2UgYXMgYSBjb21wcmFzaW9uPw0KDQpGcm9tIHdoYXQg SSBzYXcgKGUuZw0KaHR0cDovL3VzdWFyaW9zLmx5Y29zLmVzL2hlcm5hbmRw L2FydGljbGVzL3ZwY3ZzLmh0bWwpIHRoZSBwZXJmb3JtYW5jZQ0KYXJlIGJh ZCBvbmx5IHdoZW4gaXQncyBjb21pbmcgdG8gZ3JhcGhpY3MsIG90aGVyd2lz ZSBpdCBsb29rcyBwcmV0dHkNCmdvb2QuDQoNClJlZ2FyZHMsDQogVml0YWx5 IEJlbG1hbg0KIA0KIElDUTogMTkxMjQ1Mw0KIEFJTTogVml0YWx5QjE5ODQN CiBNU046IHRtZGFnZW50QGhvdG1haWwuY29tDQogWWFob28hOiBWaXRhbHlC ZQ0KDQpXZWRuZXNkYXksIE1heSAyNiwgMjAwNCwgNzoxNzozNSBQTSwgeW91 IHdyb3RlOg0KDQpKQj4gVml0YWx5LA0KDQo+PiBJIGFtIHVzaW5nIHRoZSBu ZXdlciA3LjVkZXYgbmF0aXZlIFdpbmRvd3MgcG9ydC4gRm9yIHRoaXMgcmVh c29uIEkNCj4+IGRvbid0IHRoaW5rIHRoYXQgSU4gd2lsbCBjYXVzZSBhbnkg dHJvdWJsZSAoSSByZWFkIHRoYXQgdGhpcyBpc3N1ZSB3YXMNCj4+IHJlc29s dmVkIGluIDcuNCkuDQoNCkpCPiBXZWxsLCBmb3IgcGVyZm9ybWFuY2UsIGFs bCBiZXRzIGFyZSBvZmYgZm9yIHRoZSBkZXYgV2luZG93cyBwb3J0LiAgIExh c3QgSQ0KSkI+IGNoZWNrZWQsIHRoZSBXaW4zMiB0ZWFtIHdhcyBzdGlsbCB3 b3JraW5nIG9uICpzdGFiaWxpdHkqIGFuZCBoYWRuJ3QgeWV0IGV2ZW4NCkpC PiBsb29rZWQgYXQgcGVyZm9ybWFuY2UuICBOb3QgdGhhdCB5b3UgY2FuJ3Qg aW1wcm92ZSB0aGUgcXVlcnksIGp1c3QgdGhhdCBpdA0KSkI+IG1pZ2h0IG5v dCBmaXggdGhlIHByb2JsZW0uDQoNCkpCPiBUaGVyZWZvcmUgLi4uIHlvdXIg ZGV0YWlsZWQgZmVlZGJhY2sgaXMgYXBwcmVjaWF0ZWQsIGVzcGVjaWFsbHkg aWYgeW91IGNhbg0KSkI+IGNvbXBhcmUgc3R1ZmYgdG8gdGhlIHNhbWUgZGF0 YWJhc2UgcnVubmluZyBvbiBhIExpbnV4LCBVbml4LCBvciBCU0QgbWFjaGlu ZS4NCg0K