På søndag 11. mars 2018 kl. 13:48:41, skrev dangal <danielito.ga...@gmail.com <mailto:danielito.ga...@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
