X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 32D1AD1BA6E for ; Fri, 19 Dec 2003 18:05:46 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 46488-05 for ; Fri, 19 Dec 2003 14:04:57 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 3F6D8D1B8EA for ; Fri, 19 Dec 2003 14:00:45 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id hBJI0cU6001986 for ; Fri, 19 Dec 2003 18:00:38 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id hBJHiDIq063765 for pgsql-performance@postgresql.org; Fri, 19 Dec 2003 17:44:13 GMT From: William Yu X-Newsgroups: comp.databases.postgresql.performance Subject: Re: why do optimizer parameters have to be set manually? Date: Fri, 19 Dec 2003 09:44:17 -0800 Organization: Hub.Org Networking Services Lines: 10 Message-ID: References: <3FE1F5A1.6080908@geizhals.at> <22686.1071777380@sss.pgh.pa.us> <3FE302D2.7080901@geizhals.at> <9382.1071846435@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.5) Gecko/20031007 X-Accept-Language: en-us, en In-Reply-To: <9382.1071846435@sss.pgh.pa.us> To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/278 X-Sequence-Number: 5138 Tom Lane wrote: > easy or cheap to get a measurement that isn't skewed by kernel caching > behavior. (You need a test file significantly larger than RAM, and > even then you'd better repeat the measurement quite a few times to see > how much noise there is in it.) I found a really fast way in Linux to flush the kernel cache and that is to unmount the drive and then remount. Beats having to read though a file > RAM everytime.