From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: (majordomo@vger.kernel.org) by vger.kernel.org via listexpand id S1757193Ab2KVTgE (ORCPT ); Thu, 22 Nov 2012 14:36:04 -0500 Received: from mail-oa0-f46.google.com ([209.85.219.46]:34357 "EHLO mail-oa0-f46.google.com" rhost-flags-OK-OK-OK-OK) by vger.kernel.org with ESMTP id S1757148Ab2KVTfy (ORCPT ); Thu, 22 Nov 2012 14:35:54 -0500 Message-ID: <50AD7647.7050200@gmail.com> Date: Thu, 22 Nov 2012 08:48:07 +0800 From: Jaegeuk Hanse User-Agent: Mozilla/5.0 (X11; Linux i686; rv:16.0) Gecko/20121028 Thunderbird/16.0.2 MIME-Version: 1.0 To: Johannes Weiner CC: Jan Kara , metin d , "linux-kernel@vger.kernel.org" , linux-mm@kvack.org Subject: Re: Problem in Page Cache Replacement References: <1353433362.85184.YahooMailNeo@web141101.mail.bf1.yahoo.com> <20121120182500.GH1408@quack.suse.cz> <20121121213417.GC24381@cmpxchg.org> In-Reply-To: <20121121213417.GC24381@cmpxchg.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Sender: linux-kernel-owner@vger.kernel.org List-ID: X-Mailing-List: linux-kernel@vger.kernel.org On 11/22/2012 05:34 AM, Johannes Weiner wrote: > Hi, > > On Tue, Nov 20, 2012 at 07:25:00PM +0100, Jan Kara wrote: >> On Tue 20-11-12 09:42:42, metin d wrote: >>> I have two PostgreSQL databases named data-1 and data-2 that sit on the >>> same machine. Both databases keep 40 GB of data, and the total memory >>> available on the machine is 68GB. >>> >>> I started data-1 and data-2, and ran several queries to go over all their >>> data. Then, I shut down data-1 and kept issuing queries against data-2. >>> For some reason, the OS still holds on to large parts of data-1's pages >>> in its page cache, and reserves about 35 GB of RAM to data-2's files. As >>> a result, my queries on data-2 keep hitting disk. >>> >>> I'm checking page cache usage with fincore. When I run a table scan query >>> against data-2, I see that data-2's pages get evicted and put back into >>> the cache in a round-robin manner. Nothing happens to data-1's pages, >>> although they haven't been touched for days. >>> >>> Does anybody know why data-1's pages aren't evicted from the page cache? >>> I'm open to all kind of suggestions you think it might relate to problem. > This might be because we do not deactive pages as long as there is > cache on the inactive list. I'm guessing that the inter-reference > distance of data-2 is bigger than half of memory, so it's never > getting activated and data-1 is never challenged. Hi Johannes, What's the meaning of "inter-reference distance" and why compare it with half of memoy, what's the trick? Regards, Jaegeuk > > I have a series of patches that detects a thrashing inactive list and > handles working set changes up to the size of memory. Would you be > willing to test them? They are currently based on 3.4, let me know > what version works best for you. > > -- > To unsubscribe, send a message with 'unsubscribe linux-mm' in > the body to majordomo@kvack.org. For more info on Linux MM, > see: http://www.linux-mm.org/ . > Don't email: email@kvack.org