Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jfjGF-0003HM-Gz for pgsql-performance@arkaria.postgresql.org; Mon, 01 Jun 2020 12:09:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jfjGE-0004Cp-4m for pgsql-performance@arkaria.postgresql.org; Mon, 01 Jun 2020 12:09:46 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jfjGD-0004Ch-Nl for pgsql-performance@lists.postgresql.org; Mon, 01 Jun 2020 12:09:45 +0000 Received: from sonic307-1.consmr.mail.bf2.yahoo.com ([74.6.134.40]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jfjG7-00036Y-6e for pgsql-performance@postgresql.org; Mon, 01 Jun 2020 12:09:44 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1591013377; bh=+iAgMg1lkrWo0jSdXsvF5bHrcnxJZAt8uVVIVybjAhQ=; h=Date:From:To:Subject:References:From:Subject; b=JSoxt+IqMK2ZheumnyllvHYSXk4HfzeJ/M33zDCh2c5MYe+EdlE5nQQcioa4oF1yjwKYSW0wdISA6ESAyu6AckIKpBGPl977+u/sSdtAmx/OeDFVCfztlVyMTcXlBf1vJH0trz/Bp2y2CZwlm6gR8quMuJq2AxKl7RrAn9xJIveVTkhWOFJLs0Ol/dJ8lYlMZeLWKV2nIW4gzqe8qtGFbbRNvZv9ncGO4V+iM0I59UJjHVPP3+82wuF3pm9bG5V0axZ+5PWfms8a64kNJePnbTOc3kvywqOsctFVQNfd47UV14OcyCKdRMluCIFegylmo/QKwmrU6HRonet4WjYcGA== X-YMail-OSG: xHtZknAVM1m1xlbmH6_x4mdWGP9sodQ5NJ1ps4dJC3y4BW3xsjhwQgjHofDSY7o 2u48PdWiYBb27k1ZmSOniBW1AT7h88Wzv95jO6JJCx2CoAGFjPkMvdq6ABj2ePm9ascbM26AKjqs 264t7JCFubROWb5ScqyuhQ9nPxZPNhzKvVOT8XgPwATIe_qoush7SR.ovxP3maSkE_NRyUQ9kUm7 Z3PajJP2EIzDIXZjLtjYCBRDS7WYclsLfP2o.mx2sE_YstbnzS_eAYPMlaY1IzCz4tDutd3yeYjk tvy9_6_RGr6JtjUhXRzlzDIOpVxbwTBvuiMnS.xZd.VjGgTN2Xn5IHYipXg_Bu6UifQzMVCg6nd0 SG1ZRIB3AVRh5mxzjZuc_MfIGnzt3C3L10Vs3t1TMX7q0kx4HHMvh7Yh7qg2aE_M7mbszLvN7gBk 6QW01lvlfrXBwIUbFdYSx1.ej8s10cnhqlJprFtYgvRFs68vrpKUwh8ZPI59c4ioVWX.dAKSk3u2 6KXIMf_38RxM0bewI9ETbz7w_NQ0CxvNTJKzyUFBOazgusaB8YBJwJ8BDZhnHa7AiMnPaGY02mLr aFLEhg1.kk1nXgR4PdufEFSBq7Di9dXAjeeM_zG7zSsf0Vzmo96Uoo6sUY8DCndVIaze36U6ZuS6 fY.GbktYJ3fNfJeud6CBi3SEPTBBrTiewXM2owAvEgr9fatS0hczzWGloRR4tn3xY0ZedhYDbjCc 55Elm7cD11PXaLfi0FSnrO3iFQnhsz6Lg8Z.uHGcVnszQhCOlpvX05FuEuH_BUkHytFJsBNVQ8MI 1UBm7GY4Kju4ePGG0annrDiF2tunOpK5BvAqDJTIY3wfGqw24sFIv8s8gMDR9CDJYW42RfwJ9Sh6 bNgr4wDNRxOUeThRHjZF.o9b5hWuRv1cxuoYsoYdQ26oOLXOcatS8kEOBT7AyHOXID5UgH3LyTs9 _ybNBBVC9UwymJx5eHqC9AdwYOfM7hWWTQTSmaCXid6NevC4l7TYmBPbw8J6Y4uXcXyZyca0dRSg 5ehG1glLkhBpHYebWBw5xoY_WDm3IDvS_95bTzUgc5yGl5Eul_lFMjarymoa1yfAJIYZIHk_NpMN zBcwPRT2XvgfsiUjcA9CjtchRgk3iftkAjnJQvC.H6IsIXaqaTQRAdDGLjwjpnEQbNy8KYC.9sIG zM2VPTOAuJ.LS60ikUnLdhVYuQgkt.oKC7OBOK7JAxrZc__Tu0cVPa5rahXvXi88oo5rLzkeCrMn c2yAL.mp91Xu7ZT_ZB3LIQlHxuhxU8xxCF3Ca4s2hICfzeOTkemK3wd9NBn1no7qLYB3gL9pKaTx XJSeFg7WbpQCh Received: from sonic.gate.mail.ne1.yahoo.com by sonic307.consmr.mail.bf2.yahoo.com with HTTP; Mon, 1 Jun 2020 12:09:37 +0000 Date: Mon, 1 Jun 2020 12:09:33 +0000 (UTC) From: sugnathi hai To: PostgreSQL Mailing Lists Message-ID: <251761904.519816.1591013373351@mail.yahoo.com> Subject: Configuration MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_519815_581205328.1591013373349" References: <251761904.519816.1591013373351.ref@mail.yahoo.com> X-Mailer: WebService/1.1.16037 YMailNorrin Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.162 Safari/537.36 Content-Length: 2010 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_519815_581205328.1591013373349 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Hi , In PGtune I can able to get configuration changes based on RAM and Disk and No of Connection. but if we want to recommend RAM, DISK, and No of connection based on DB size. any calculation is there For Example, 1 TB Database how much RAM and DISK Space required for better performance the DB size will increase per day 20 GBFrequent delete and insert will happen Thanks in Advance ------=_Part_519815_581205328.1591013373349 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi ,

In PGtune I can able = to get configuration changes based on RAM and Disk and No of Connection.

but if we want to recommend RAM, DISK, and No of connection= based on DB size. any calculation is there


For Example, 1 TB Database how much RAM= and DISK Space required for better performance

the DB si= ze will increase per day 20 GB
= Frequent delete and insert will happen


Thanks in Advance


------=_Part_519815_581205328.1591013373349--