Date: Sun, 11 Mar 2018 14:49:01 +0100 (CET)
From: Andreas Joseph Krogh <andreas@visena.com>
To: pgsql-performance@lists.postgresql.org
Message-ID: <VisenaEmail.69.78950c12514e55a1.162154fab3d@tc7-visena>
In-Reply-To: <1520772521740-0.post@n3.nabble.com>
Subject: Sv: Memory size
MIME-Version: 1.0
Content-Type: multipart/mixed;
	boundary="----=_Part_405_1539715755.1520776141357"
Precedence: bulk

------=_Part_405_1539715755.1520776141357
Content-Type: multipart/related;
	boundary="----=_Part_406_313670979.1520776141357"

------=_Part_406_313670979.1520776141357
Content-Type: multipart/alternative;
	boundary="----=_Part_407_595220160.1520776141369"

------=_Part_407_595220160.1520776141369
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

P=C3=A5 s=C3=B8ndag 11. mars 2018 kl. 13:48:41, skrev dangal <danielito.gal=
lo@gmail.com=20
<mailto:danielito.gallo@gmail.com>>:

 Dear some consultation, I have a base of about 750 GB in size and we are
 having problem of slowness in certain views of the application, so I have
 been seeing it is apparently a memory problem because if I run again the
 view runs fast, the base is in a virtual server with 24 GB of RAM and 8 GB
 of shared buffer, with this information how much would you recommend to pu=
t
 a memory in the server
 thank you very much
=C2=A0
What is=C2=A0effective_cache_size ?
=C2=A0

https://www.postgresql.org/docs/10/static/runtime-config-query.html#GUC-EFF=
ECTIVE-CACHE-SIZE
=C2=A0
-- Andreas Joseph Krogh
=C2=A0


------=_Part_407_595220160.1520776141369
Content-Type: text/html;charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div>P=C3=A5 s=C3=B8ndag 11. mars 2018 kl. 13:48:41, skrev dangal &lt;<a hr=
ef=3D"mailto:danielito.gallo@gmail.com">danielito.gallo@gmail.com</a>&gt;:<=
/div>

<blockquote style=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0pt=
 0pt 0pt 0.8ex; padding-left: 1ex;">
<div style=3D"display:inline; font-family: monospace; font-size: 12px;"><br=
>
Dear some consultation, I have a base of about 750 GB in size and we are<br=
>
having problem of slowness in certain views of the application, so I have<b=
r>
been seeing it is apparently a memory problem because if I run again the<br=
>
view runs fast, the base is in a virtual server with 24 GB of RAM and 8 GB<=
br>
of shared buffer, with this information how much would you recommend to put=
<br>
a memory in the server<br>
thank you very much</div>
</blockquote>

<div>=C2=A0</div>

<div>What is=C2=A0effective_cache_size ?</div>

<div>=C2=A0</div>

<div>https://www.postgresql.org/docs/10/static/runtime-config-query.html#GU=
C-EFFECTIVE-CACHE-SIZE</div>

<div>=C2=A0</div>

<div class=3D"origo-email-signature">
<div>--
<div><span style=3D"font-family:arial,helvetica,sans-serif;"><strong>Andrea=
s Joseph Krogh</strong></span></div>

<div>=C2=A0</div>
</div>
</div>
------=_Part_407_595220160.1520776141369--

------=_Part_406_313670979.1520776141357--

------=_Part_405_1539715755.1520776141357--