pg.ddx.io pgsql-performance@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Sv: Memory size 2+ messages / 2 participants [nested] [flat]
* Sv: Memory size @ 2018-03-11 13:49 Andreas Joseph Krogh <andreas@visena.com> 2018-03-11 13:57 ` Re: Sv: Memory size dangal <danielito.gallo@gmail.com> 0 siblings, 1 reply; 2+ messages in thread From: Andreas Joseph Krogh @ 2018-03-11 13:49 UTC (permalink / raw) To: pgsql-performance@lists.postgresql.org På søndag 11. mars 2018 kl. 13:48:41, skrev dangal <danielito.gallo@gmail.com <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 put a memory in the server thank you very much What is effective_cache_size ? https://www.postgresql.org/docs/10/static/runtime-config-query.html#GUC-EFFECTIVE-CACHE-SIZE -- Andreas Joseph Krogh ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Sv: Memory size 2018-03-11 13:49 Sv: Memory size Andreas Joseph Krogh <andreas@visena.com> @ 2018-03-11 13:57 ` dangal <danielito.gallo@gmail.com> 0 siblings, 0 replies; 2+ messages in thread From: dangal @ 2018-03-11 13:57 UTC (permalink / raw) To: pgsql-performance The rest of the memory Andreas, 16 gb -- Sent from: http://www.postgresql-archive.org/PostgreSQL-performance-f2050081.html ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2018-03-11 13:57 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2018-03-11 13:49 Sv: Memory size Andreas Joseph Krogh <andreas@visena.com> 2018-03-11 13:57 ` dangal <danielito.gallo@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox