Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 3B8DE2E007B for ; Fri, 15 Feb 2008 14:41:18 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 07601-02 for ; Fri, 15 Feb 2008 14:41:11 -0400 (AST) Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by postgresql.org (Postfix) with ESMTP id 8D7BB2E0030 for ; Fri, 15 Feb 2008 14:41:13 -0400 (AST) Received: from localhost (or-69-34-217-90.sta.embarqhsd.net [69.34.217.90]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id m1FIfC4f029336 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Fri, 15 Feb 2008 10:41:16 -0800 Date: Fri, 15 Feb 2008 10:42:32 -0800 From: "Joshua D. Drake" To: Erik Jones Cc: Josh Berkus , pgsql-performance@postgresql.org, Greg Smith , Peter Schuller Subject: Re: shared_buffers in 8.3 w/ lots of RAM on dedicated PG machine Message-ID: <20080215104232.54c4a397@commandprompt.com> In-Reply-To: <72BE31DF-ABAF-459B-99A3-4E575EC3E08A@myemma.com> References: <20080215123528.GA16532@hyperion.scode.org> <20080215135846.GA17327@hyperion.scode.org> <200802151006.11858.josh@agliodbs.com> <72BE31DF-ABAF-459B-99A3-4E575EC3E08A@myemma.com> Organization: Command Prompt, Inc. X-Mailer: Claws Mail 3.0.2 (GTK+ 2.12.0; x86_64-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: base64 X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Fri, 15 Feb 2008 10:41:20 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/184 X-Sequence-Number: 28726 LS0tLS1CRUdJTiBQR1AgU0lHTkVEIE1FU1NBR0UtLS0tLQ0KSGFzaDogU0hBMQ0KDQpPbiBGcmks IDE1IEZlYiAyMDA4IDEyOjM3OjEwIC0wNjAwDQpFcmlrIEpvbmVzIDxlcmlrQG15ZW1tYS5jb20+ IHdyb3RlOg0KPih3ZWxsbCwgZm9yY2VkICANCj4gdG8pIG1pZ3JhdGUgdG8gYSBuZXcgc3lzdGVt IHdpdGggYSBzYW5lIGRyaXZlIGNvbmZpZ3VyYXRpb24uICBUaGUNCj4gb2xkIHNldCB1cCB3YXMg ZG9uZSBob3JyaWJseSBieSBhIHN5c2FkbWluIHdobydzIG5vIGxvbmdlciB3aXRoIHVzDQo+IHdo byBzZXQgdXMgdXAgd2l0aCBhIFJBSUQ1IGFycmF5IHdpdGggYm90aCB0aGUgZGF0YSBhbmQgeGxv Z3MgYm90aCAgDQo+IG1pcnJvcmVkIGFjcm9zcyBhbGwgb2YgdGhlIGRpc2tzIHdpdGggbm8gc3Bh cmVzLiAgDQoNCklzIHRoZSBhZG1pbiBzdGlsbCB3aXRoIHVzPyBPciBpcyBoZSBmZXJ0aWxpemVy PyBJIGhhdmUgc29tZSBrbm93IHNvbWUNCmdyZWF0IGdhcmRlbmVycyBmcm9tIEplcnNleS4uLg0K DQpTaW5jZXJlbHksDQoNCkpvc2h1YSBELiBEcmFrZQ0KDQoNCj4gDQo+IEVyaWsgSm9uZXMNCj4g DQo+IERCQSB8IEVtbWHCrg0KPiBlcmlrQG15ZW1tYS5jb20NCj4gODAwLjU5NS40NDAxIG9yIDYx NS4yOTIuNTg4OA0KPiA2MTUuMjkyLjA3NzcgKGZheCkNCj4gDQo+IEVtbWEgaGVscHMgb3JnYW5p emF0aW9ucyBldmVyeXdoZXJlIGNvbW11bmljYXRlICYgbWFya2V0IGluIHN0eWxlLg0KPiBWaXNp dCB1cyBvbmxpbmUgYXQgaHR0cDovL3d3dy5teWVtbWEuY29tDQo+IA0KPiANCj4gDQo+IA0KPiAt LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0oZW5kIG9mDQo+IGJyb2FkY2FzdCktLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0gVElQIDM6IEhhdmUgeW91IGNoZWNrZWQgb3VyDQo+IGV4dGVuc2l2 ZSBGQVE/DQo+IA0KPiAgICAgICAgICAgICAgICBodHRwOi8vd3d3LnBvc3RncmVzcWwub3JnL2Rv Y3MvZmFxDQo+IA0KDQoNCi0gLS0gDQpUaGUgUG9zdGdyZVNRTCBDb21wYW55IHNpbmNlIDE5OTc6 IGh0dHA6Ly93d3cuY29tbWFuZHByb21wdC5jb20vIA0KUG9zdGdyZVNRTCBDb21tdW5pdHkgQ29u ZmVyZW5jZTogaHR0cDovL3d3dy5wb3N0Z3Jlc3FsY29uZmVyZW5jZS5vcmcvDQpEb25hdGUgdG8g dGhlIFBvc3RncmVTUUwgUHJvamVjdDogaHR0cDovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9hYm91dC9k b25hdGUNClBvc3RncmVTUUwgU1BJIExpYWlzb24gfCBTUEkgRGlyZWN0b3IgfCAgUG9zdGdyZVNR TCBwb2xpdGljYWwgcHVuZGl0DQoNCi0tLS0tQkVHSU4gUEdQIFNJR05BVFVSRS0tLS0tDQpWZXJz aW9uOiBHbnVQRyB2MS40LjYgKEdOVS9MaW51eCkNCg0KaUQ4REJRRkh0ZDBZQVRiL3pxZlpVVVFS QXV3UEFKMFkyVmpZTWtIaENzUTA3U2Fkai9rVDBZejN3UUNnbXVDUA0KZU9tbmRveXZZZStEaEgr QU93Y3ltczQ9DQo9cUdaRQ0KLS0tLS1FTkQgUEdQIFNJR05BVFVSRS0tLS0tDQo=