Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id 0AE9E2E0053 for ; Thu, 3 Apr 2008 01:56:21 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 41613-03 for ; Thu, 3 Apr 2008 01:56:16 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.239]) by developer.postgresql.org (Postfix) with ESMTP id 733F42E002D for ; Thu, 3 Apr 2008 01:56:17 -0300 (ADT) Received: by wx-out-0506.google.com with SMTP id r21so2918768wxc.28 for ; Wed, 02 Apr 2008 21:56:16 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:date:from:to:references:subject:message-id:x-mailer:mime-version:content-type; bh=1ZwsUuTKS3XSD0gbcl8tIjXJS6K8k2BfQd+X7tkFeUk=; b=pRasp9Nsyn+0kckCKInHzVTGEXmg8muqUXNTzDFYR9QLIGdm6SEEUCANP1h1aTTPDmJCbjJSBzgBFOocwNIAkLwgSXDoNVibHpPj08oxczkm2aB84315ru4E0Zo/eKZ/30R2UcD+hQDpQVd5pukpecEJrnecwn6u21TkKt8Zz54= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=date:from:to:references:subject:message-id:x-mailer:mime-version:content-type; b=GbHICKGbYBJYx6BV7GtJdIy/Fo1HyxEqUCYcK5Qg/PCDkm5eEQ2UYncoAzLujs3xLYsmN4GCZFFClTV9nnTFuXvv6v0ASGRU56IDITlz3e9Lf976aXrZbdqfSsquQeFsWhO8KvH3HuAvU3pC+zh8kE7/wt2lhFAV5ezQsg+JUR0= Received: by 10.143.6.1 with SMTP id j1mr6727356wfi.45.1207198576276; Wed, 02 Apr 2008 21:56:16 -0700 (PDT) Received: from XIAOBITAO ( [221.123.69.37]) by mx.google.com with ESMTPS id 27sm5153400wfa.0.2008.04.02.21.56.12 (version=SSLv3 cipher=OTHER); Wed, 02 Apr 2008 21:56:15 -0700 (PDT) Date: Thu, 3 Apr 2008 12:56:17 +0800 From: "bitaoxiao" To: "pgsql-performance@postgresql.org" References: <47F324B4.6010404@mansionfamily.plus.com>, Subject: Max shared_buffers Message-ID: <200804031256103599734@gmail.com> X-mailer: Foxmail 6, 11, 101, 15 [cn] Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=====003_Dragon758547486247_=====" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.797 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001, MIME_BASE64_TEXT=2.796 X-Spam-Level: ** X-Archive-Number: 200804/27 X-Sequence-Number: 29520 This is a multi-part message in MIME format. --=====003_Dragon758547486247_===== Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 7bit What can be set as max of postgreSQL shared_buffers and work_mem 2008-04-03 bitaoxiao --=====003_Dragon758547486247_===== Content-Type: text/html; charset="gb2312" Content-Transfer-Encoding: base64 PCFET0NUWVBFIEhUTUwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDQuMCBUcmFuc2l0aW9uYWwv L0VOIj4NCjxIVE1MPjxIRUFEPg0KPE1FVEEgaHR0cC1lcXVpdj1Db250ZW50LVR5cGUgY29udGVu dD0idGV4dC9odG1sOyBjaGFyc2V0PUdCMjMxMiI+DQo8TUVUQSBjb250ZW50PSJNU0hUTUwgNi4w MC42MDAwLjE2NjA4IiBuYW1lPUdFTkVSQVRPUj4NCjxTVFlMRT5AZm9udC1mYWNlIHsNCglmb250 LWZhbWlseTogy87M5TsNCn0NCkBmb250LWZhY2Ugew0KCWZvbnQtZmFtaWx5OiBWZXJkYW5hOw0K fQ0KQGZvbnQtZmFjZSB7DQoJZm9udC1mYW1pbHk6IEDLzszlOw0KfQ0KQHBhZ2UgU2VjdGlvbjEg e3NpemU6IDU5NS4zcHQgODQxLjlwdDsgbWFyZ2luOiA3Mi4wcHQgOTAuMHB0IDcyLjBwdCA5MC4w cHQ7IGxheW91dC1ncmlkOiAxNS42cHQ7IH0NClAuTXNvTm9ybWFsIHsNCglURVhULUpVU1RJRlk6 IGludGVyLWlkZW9ncmFwaDsgRk9OVC1TSVpFOiAxMC41cHQ7IE1BUkdJTjogMGNtIDBjbSAwcHQ7 IEZPTlQtRkFNSUxZOiAiVGltZXMgTmV3IFJvbWFuIjsgVEVYVC1BTElHTjoganVzdGlmeQ0KfQ0K TEkuTXNvTm9ybWFsIHsNCglURVhULUpVU1RJRlk6IGludGVyLWlkZW9ncmFwaDsgRk9OVC1TSVpF OiAxMC41cHQ7IE1BUkdJTjogMGNtIDBjbSAwcHQ7IEZPTlQtRkFNSUxZOiAiVGltZXMgTmV3IFJv bWFuIjsgVEVYVC1BTElHTjoganVzdGlmeQ0KfQ0KRElWLk1zb05vcm1hbCB7DQoJVEVYVC1KVVNU SUZZOiBpbnRlci1pZGVvZ3JhcGg7IEZPTlQtU0laRTogMTAuNXB0OyBNQVJHSU46IDBjbSAwY20g MHB0OyBGT05ULUZBTUlMWTogIlRpbWVzIE5ldyBSb21hbiI7IFRFWFQtQUxJR046IGp1c3RpZnkN Cn0NCkE6bGluayB7DQoJQ09MT1I6IGJsdWU7IFRFWFQtREVDT1JBVElPTjogdW5kZXJsaW5lDQp9 DQpTUEFOLk1zb0h5cGVybGluayB7DQoJQ09MT1I6IGJsdWU7IFRFWFQtREVDT1JBVElPTjogdW5k ZXJsaW5lDQp9DQpBOnZpc2l0ZWQgew0KCUNPTE9SOiBwdXJwbGU7IFRFWFQtREVDT1JBVElPTjog dW5kZXJsaW5lDQp9DQpTUEFOLk1zb0h5cGVybGlua0ZvbGxvd2VkIHsNCglDT0xPUjogcHVycGxl OyBURVhULURFQ09SQVRJT046IHVuZGVybGluZQ0KfQ0KU1BBTi5FbWFpbFN0eWxlMTcgew0KCUZP TlQtV0VJR0hUOiBub3JtYWw7IENPTE9SOiB3aW5kb3d0ZXh0OyBGT05ULVNUWUxFOiBub3JtYWw7 IEZPTlQtRkFNSUxZOiBWZXJkYW5hOyBURVhULURFQ09SQVRJT046IG5vbmU7IG1zby1zdHlsZS10 eXBlOiBwZXJzb25hbC1jb21wb3NlDQp9DQpESVYuU2VjdGlvbjEgew0KCXBhZ2U6IFNlY3Rpb24x DQp9DQpVTktOT1dOIHsNCglGT05ULVNJWkU6IDEwcHQNCn0NCkJMT0NLUVVPVEUgew0KCU1BUkdJ Ti1UT1A6IDBweDsgTUFSR0lOLUJPVFRPTTogMHB4OyBNQVJHSU4tTEVGVDogMmVtDQp9DQpPTCB7 DQoJTUFSR0lOLVRPUDogMHB4OyBNQVJHSU4tQk9UVE9NOiAwcHgNCn0NClVMIHsNCglNQVJHSU4t VE9QOiAwcHg7IE1BUkdJTi1CT1RUT006IDBweA0KfQ0KPC9TVFlMRT4NCjwvSEVBRD4NCjxCT0RZ IHN0eWxlPSJGT05ULVNJWkU6IDEwcHQ7IE1BUkdJTjogMTBweDsgRk9OVC1GQU1JTFk6IHZlcmRh bmEiPg0KPERJVj48Rk9OVCBmYWNlPVZlcmRhbmEgY29sb3I9IzAwMDA4MCBzaXplPTI+PC9GT05U PiZuYnNwOzwvRElWPg0KPERJVj48Rk9OVCBmYWNlPVZlcmRhbmEgY29sb3I9IzAwMDA4MCBzaXpl PTI+V2hhdCBjYW4gYmUgc2V0IGFzIG1heCANCm9mJm5ic3A7cG9zdGdyZVNRTCBzaGFyZWRfYnVm ZmVycyBhbmQgd29ya19tZW08L0ZPTlQ+PC9ESVY+DQo8RElWPjxGT05UIGZhY2U9VmVyZGFuYSBj b2xvcj0jMDAwMDgwIHNpemU9Mj48L0ZPTlQ+Jm5ic3A7PC9ESVY+DQo8RElWPjxGT05UIGZhY2U9 VmVyZGFuYSBjb2xvcj0jYzBjMGMwIHNpemU9Mj4yMDA4LTA0LTAzIDwvRk9OVD48L0RJVj48Rk9O VCANCmZhY2U9VmVyZGFuYSBjb2xvcj0jMDAwMDgwIHNpemU9Mj4NCjxIUiBzdHlsZT0iV0lEVEg6 IDEwMHB4IiBhbGlnbj1sZWZ0IGNvbG9yPSNiNWM0ZGYgU0laRT0xPg0KPC9GT05UPg0KPERJVj48 Rk9OVCBmYWNlPVZlcmRhbmEgY29sb3I9I2MwYzBjMCBzaXplPTI+PFNQQU4+Yml0YW94aWFvPC9T UEFOPiANCjwvRk9OVD48L0RJVj4NCjxESVY+PEZPTlQgZmFjZT1WZXJkYW5hIHNpemU9Mj4NCjxE SVY+Jm5ic3A7PC9ESVY+PC9GT05UPjwvRElWPjwvQk9EWT48L0hUTUw+DQo= --=====003_Dragon758547486247_=====--