Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bjmhi-0007Uy-TV for pgsql-admin@arkaria.postgresql.org; Tue, 13 Sep 2016 12:20:48 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bjmhi-00042b-BA for pgsql-admin@arkaria.postgresql.org; Tue, 13 Sep 2016 12:20:46 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bjmg2-0001hj-2T for pgsql-admin@postgresql.org; Tue, 13 Sep 2016 12:19:02 +0000 Received: from nm5-vm4.bullet.mail.ir2.yahoo.com ([212.82.96.111]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bjmfy-0001Rh-SA for pgsql-admin@postgresql.org; Tue, 13 Sep 2016 12:19:00 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.es; s=s2048; t=1473769136; bh=hLRq699Up6vGrta7odKyJMFMcR6Vh9W3MIxbYacIi5o=; h=Date:From:To:Subject:In-Reply-To:References:From:Subject; b=S4kHf5e8o0UFB4piThYBUFmmmwES+ZQsz7OH9CMjMKgiIPyd9eDvlrW8mhrdJsHtksqTLFV8t3dUUf5goS7tYaEwBMxiIaajguye31/DdZ905foofyXdZUqCb56lVyrBMwBTXZ/0E2+NSOH+AUMRfdcQ5i2CSFIyw4kFzCe023lWz9yJFOVFGiukDF541L8ev136x5Fd+V5cx2mBDI0Znb0insV9KcPhB3C9S/YOBhSeJHXqxuBsBEkCkIkir1NxWOyL2na/LUaAaqcRLuptTmTAOfphnR0zZ09WH+DZViFM4C8rXeNcMsNCPveJ6MQFNDA7ZprkeVjxMaUCif3LiQ== Received: from [212.82.98.127] by nm5.bullet.mail.ir2.yahoo.com with NNFMP; 13 Sep 2016 12:18:56 -0000 Received: from [46.228.39.85] by tm20.bullet.mail.ir2.yahoo.com with NNFMP; 13 Sep 2016 12:18:56 -0000 Received: from [127.0.0.1] by smtp122.mail.ir2.yahoo.com with NNFMP; 13 Sep 2016 12:18:56 -0000 X-Yahoo-Newman-Id: 616782.57963.bm@smtp122.mail.ir2.yahoo.com X-Yahoo-Newman-Property: ymail-3 X-YMail-OSG: 0u_3GYMVM1ntpww0il2sjF9aE.54qwrv9QFMJ8ZTK5dyICI DZsG7NPLLBvjUmS7IsxoWEIOTgR8wZGLwpgQqWmS.hyIYK.UwfpT_lJYTo_H 9VfETOv9XffgCsake.QR7kayOEVVQKxkC8vBxl7P.zpy7mErWfsrn9oC37WA o3aSuHXpSzDU3WFUgw7ONzwVS1jWHNIQL2EtvwAZs0gjzseuMB8Yuur8Nldy UhM5rr834oX14vArb5DC9MdKeD61um0OIfFhgUHaHALXoThWa3Bo.YwdWP15 tNYvJxU_vjw2_e4ZBLqKgHKnF_Tzl8W8SNpMPSLvv22UPuw9ecN.3QFusWXR rq4kAVEFDRKTjXSiiwJM0yiy7gdfkWEq6DinqLl.qs4tGonWr36W1XouPwMN nAwgZm6vVP.6z087zGSWqDn8JeNtrsv1W7YxsU60RjZfXkikRK1iNsmT.yxk isl.vm6gthRyY_TvUFWZGqtKvd69TvnFPqglPdL3Z44w9e5e3u4hQf_xlLqB _RQoppWeqm_cIyS.ivx2LRJ.lGscc9ox0uho2R3aDvQx5YibCwCR_epVvZQq pHh0wyzxN_EHew3VagA-- X-Yahoo-SMTP: mX392iiswBAeJNdO_s.EW62LZDJR Date: Tue, 13 Sep 2016 14:18:54 +0200 From: Eduardo Morras To: pgsql-admin@postgresql.org Subject: Re: The sizing of HW resources of a physical PG server Message-Id: <20160913141854.51bdf5b492fdb262a963ee37@yahoo.es> In-Reply-To: References: X-Mailer: Sylpheed 3.5.1 Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -2.7 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org On Tue, 13 Sep 2016 13:25:21 +0200 Poul Kristensen wrote: > Hi ! > > How to size a physical PG server? > > What does a physical PG server like concerning HW resources? > number of cpu's(cache L1 expensive I think, L2 and L3), RAM? a) Amount of data b) Type of data (text (books), numeric (business data), real (scientific data), ...) c) Relationship between data d) Type of queries (OLTP/OLAP//Graph/... or Read vs Write or...) Too much to answer in a mail. Check docs and manual > Thanks > > Poul --- --- Eduardo Morras -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin