X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 0CB5ED1DA34 for ; Tue, 3 Feb 2004 13:21:23 +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 15032-03 for ; Tue, 3 Feb 2004 09:21:21 -0400 (AST) Received: from frodo.hserus.net (frodo.hserus.net [204.74.68.40]) by svr1.postgresql.org (Postfix) with ESMTP id 9E7B3D1D9F2 for ; Tue, 3 Feb 2004 09:21:19 -0400 (AST) Received: from concord.pspl.co.in ([202.54.11.72]:62622 helo=frodo.hserus.net) by frodo.hserus.net with asmtp (Cipher TLSv1:DHE-RSA-AES256-SHA:256) (Exim 4.30 #0) id 1Ao0UR-000NGw-8g by authid with plain; Tue, 03 Feb 2004 18:51:19 +0530 Message-ID: <401FA16E.4040202@frodo.hserus.net> Date: Tue, 03 Feb 2004 18:56:06 +0530 From: Shridhar Daithankar User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.6b) Gecko/20031205 Thunderbird/0.4 X-Accept-Language: en-us, en MIME-Version: 1.0 To: David Teran Cc: PgSQL Performance ML Subject: Re: cache whole data in RAM References: <13E980A8-5648-11D8-BC99-000A95A6F0DC@cluster9.com> In-Reply-To: <13E980A8-5648-11D8-BC99-000A95A6F0DC@cluster9.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/34 X-Sequence-Number: 5558 David Teran wrote: > we are trying to speed up a database which has about 3 GB of data. The > server has 8 GB RAM and we wonder how we can ensure that the whole DB is > read into RAM. We hope that this will speed up some queries. Neither the DBa or postgresql has to do anything about it. Usually OS caches the data in it's buffer cache. That is certainly true for linux and freeBSD does that. Most of the unices certainly do. To my knowledge linux is most aggresive one at that..(Rather over aggressive..) Make sure that you size effective cache size correctly. It helps postgresql planner at times.. HTH Shridhar