Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1ev0PB-00017O-5S for pgsql-performance@arkaria.postgresql.org; Sun, 11 Mar 2018 12:48:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ev0P9-0003dB-CY for pgsql-performance@arkaria.postgresql.org; Sun, 11 Mar 2018 12:48:47 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1ev0P9-0003cy-58 for pgsql-performance@lists.postgresql.org; Sun, 11 Mar 2018 12:48:47 +0000 Received: from n3.nabble.com ([162.255.23.22]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ev0P6-0008Ja-1s for pgsql-performance@postgresql.org; Sun, 11 Mar 2018 12:48:46 +0000 Received: from n3.nabble.com (localhost [127.0.0.1]) by n3.nabble.com (Postfix) with ESMTP id B55EBBA3522D for ; Sun, 11 Mar 2018 05:48:41 -0700 (MST) Date: Sun, 11 Mar 2018 05:48:41 -0700 (MST) From: dangal To: pgsql-performance@postgresql.org Message-ID: <1520772521740-0.post@n3.nabble.com> Subject: Memory size MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 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 -- Sent from: http://www.postgresql-archive.org/PostgreSQL-performance-f2050081.html