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 1jWBkn-0006zK-1A for pgsql-admin@arkaria.postgresql.org; Wed, 06 May 2020 04:33:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jWBkk-0004SN-Tw for pgsql-admin@arkaria.postgresql.org; Wed, 06 May 2020 04:33:50 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jWBkk-0004Qs-L5 for pgsql-admin@lists.postgresql.org; Wed, 06 May 2020 04:33:50 +0000 Received: from sonic316-13.consmr.mail.bf2.yahoo.com ([74.6.130.123]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jWBkc-0007Yb-Ud for pgsql-admin@lists.postgresql.org; Wed, 06 May 2020 04:33:50 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1588739620; bh=kSSEjZ+NWh5UlI4j0rmsDqQYx1Ms38DyrO9SPT+xbxI=; h=Date:From:To:Subject:References:From:Subject; b=dpkzDM0zdeDxGhCQMc6liVAL9pi1MXo5Oj+did28kKIydCf+IGqUm4FaiCUTbR35mYX9WNtfxgCBbTNu8zX+NuArG/L5gYOVdfqWQs+4VZyaTUbV+eNxo2nid8og+/PIyUOOvtPlPPsCsN5lcoAGkEeC0ENLgoGr3R54/EvVCTo+6UgFr/HzakqM5OytZJ93aqJaTfGYtXc9qc/iYBoKnbyGGA7g2wXASa4pwXHliCAK+FSGFihAgaqLMIDhFBO+H+4gmmn4bKblNEGkQsbwxtQt31tnczq6FJmWKTP8pmbM3obU7vFdTcnWiZq0aRgABf8Gzjk+3oK+oFKzjNzxFA== X-YMail-OSG: NdKfS80VM1kO2r7IZzt303H7ZUOWMphEdi3oNuemr9uGZMPL2010x23kVxm6Atn kWBZ1q7e3pe5jgBP3H6vi1hivDFJ52DZ8ZsfaWx4mamO4V4emGB6K7i9JHO1myq17FOfRKaBiSGF DpOdapirXPJbEqFiizR5DnXomYvxozE3Htx.Np07lcbr.Nfhm3Y1FNoUdwlAeG6W15FhtV5slHIM IPmcbpeWR0pgs84WhQ0bGMqa4DA.s4zAhgSVRphrMQvQ2nCdlusWo66W0tfodwUT4.J3c2jsGO9K gNqdCtftUdqYTGOk1LOeTQJ2LQ3pFcBZvFulXuZ2J8_kDZK52BVwPTRgbJS_xj_RrotLrrYDmw2p jO8CoDE6ifbom6Y1lk8_dAxaQ3fX9q8WUW8m5etWsJO3H1lLOFc413W6Y1lrW7bPOpkrqxFWjixs va6IlauYexcF0rBRfQluq9_QV__8xbXgwg2kTgO1wirillJIpK9PzSrgIcNizDmX0HXzw7rb.6Nq Ae0Ri4412enOyQsYSmwAFGIUX54n7uArWc0oZ2DlIf8pAsST8M6Nl1.bh7N0CQDR_cw1TB8wFOsN eIqMu8zQi62mfT0sptM8C0D46QgwWW5mDss2UyvjthgIP7ccb53A2hpJ3CITEUZPVDwQa1uXBvhm 5E7HHOpUQiuj0kaUSYvTiiyXTHwDzeBayK.s8oVQCLOVB8ELo7bnrBLJ3Wj_uxdgZhfGxxzc7_0c .G4yz1ON4rL5CL8FHUSTMpKmCviqRWXgOdtfeNffBEJAzyKJPvURLFJ2hXZ0jolLr22IfyrgdfaU lqJ9mJGovqKDQAuD6Xoc_mZlNlcqWEGFgI8wOxXmKmX4VbtjVoG117jjx__EO3Zd2btpH7AhBY.V uwLy_jw.8jUXuaugr_XIw.k2dgiAgjlzS0cDaZ65c9pr8nj.8n5gcpPvaO.rmsJCPW4_GjBqXHBX wrSgNVSDe2NbjlSFMPIFVv12B9YFPQag5Uz4O7vnL7KLZtDNViVVpaDY5qnD5teqg2XsVvvtvhc9 vMZJW8yXLV47XRJJS82lhS9CNR8aTIBgO8bJ3XPGLr0SbmYKkhpYp0bpN2hkEbTyhSNNlrZ5kdG3 Y2616wU7yBlVwenSzWPl_wgjWD2qxBhdg2XH.BBcSBESKm1zJ7FICXaK5jryEqBUxOoGoJ1QVBHC AHGUnLOFoSFDCWDWcZbhvXbjEFe2uO1UU9fa8fCV3ZS3Thw6jQF39oYXhlTq7N3fDWKlJ9_8k3gx 3V0MXTYvKOOC2J2faBeooWykT5uWiieim6zJ1X0Tcc8aHeQI1sKFrhF9yL9OPuN4L4Z5cpSbvzt1 Iz3rxMESyw5qgP_JSndu7 Received: from sonic.gate.mail.ne1.yahoo.com by sonic316.consmr.mail.bf2.yahoo.com with HTTP; Wed, 6 May 2020 04:33:40 +0000 Date: Wed, 6 May 2020 04:33:36 +0000 (UTC) From: sugnathi hai To: "pgsql-admin@lists.postgresql.org" Message-ID: <970991440.1353803.1588739616945@mail.yahoo.com> Subject: RAM and Disk Space calculation MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1353802_454286617.1588739616944" References: <970991440.1353803.1588739616945.ref@mail.yahoo.com> X-Mailer: WebService/1.1.15756 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: 2210 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_1353802_454286617.1588739616944 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi Team, I want to recommend Memory size and disk space while data will grow, how to calculate these memory and disk space. example :=C2=A0 =C2=A0i have 700 GB data current configuration is as follow Per day 250000 row will be inserted in main table. it will be 3 times and 20 time increase in some other table can you please suggest 32 GB Ram1 Tb Disk space. ------=_Part_1353802_454286617.1588739616944 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi Team,

I want to recom= mend Memory size and disk space while data will grow,

how= to calculate these memory and disk space.

example : = ;

 i have 700 GB data current configuration is as fo= llow

Per day 250000 row will be inserted in main table.

it will be 3 times and 20 time increase in some other tabl= e

can you please suggest

32 GB Ram
1 Tb Disk space.

=

------=_Part_1353802_454286617.1588739616944--