Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dpbbc-0001Up-Iq for pgsql-performance@arkaria.postgresql.org; Wed, 06 Sep 2017 14:47:04 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dpbbb-0005uI-SK for pgsql-performance@arkaria.postgresql.org; Wed, 06 Sep 2017 14:47:03 +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.84_2) (envelope-from ) id 1dpbZo-0008Pn-HG for pgsql-performance@postgresql.org; Wed, 06 Sep 2017 14:45:12 +0000 Received: from evolu-s.it ([94.23.66.144] helo=smtp.evolu-s.it) by magus.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dpbZh-00021j-6k for pgsql-performance@postgresql.org; Wed, 06 Sep 2017 14:45:12 +0000 Received: from [192.168.1.65] ([79.6.30.247]) by smtp.evolu-s.it ; Wed, 6 Sep 2017 16:45:04 +0200 Subject: Re: [SPAM] OS cache management To: pgsql-performance@postgresql.org References: From: Moreno Andreo Message-ID: Date: Wed, 6 Sep 2017 16:45:09 +0200 User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:52.0) Gecko/20100101 Thunderbird/52.3.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Content-Language: it List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org Il 06/09/2017 10:12, Soni M ha scritto: > > > Let's say I have 10 year data, and commonly used data only the last 1 > year. This data is quite big, so each table and index file is divided > into several file in PGDATA/base > May not be relevant to what you asked, but if you want to keep last yeat data in a "small and fast" dataset separated (physically separated!) by old data (that's still available, but response times may vary), IMHO you should consider partitioning... https://www.postgresql.org/docs/current/static/ddl-partitioning.html HTH, Moreno.- -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance