X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 3E4643A471B for ; Wed, 27 Oct 2004 21:01:27 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 78199-02 for ; Wed, 27 Oct 2004 20:01:14 +0000 (GMT) Received: from www.postgresql.com (www.postgresql.com [200.46.204.209]) by svr1.postgresql.org (Postfix) with ESMTP id 9C0D83A473A for ; Wed, 27 Oct 2004 21:01:13 +0100 (BST) Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by www.postgresql.com (Postfix) with SMTP id 719695A11A5 for ; Wed, 27 Oct 2004 17:57:46 +0100 (BST) Received: (qmail 5692 invoked by uid 65534); 27 Oct 2004 16:57:42 -0000 Received: from pD9E0D737.dip.t-dialin.net (EHLO [127.0.0.1]) (217.224.215.55) by mail.gmx.net (mp004) with SMTP; 27 Oct 2004 18:57:42 +0200 X-Authenticated: #11150195 Message-ID: <417FD383.3000502@gmx.ch> Date: Wed, 27 Oct 2004 16:57:39 +0000 From: Albrecht Berger User-Agent: Mozilla Thunderbird 0.8 (Windows/20040913) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: caching complete table for optimizing search ? Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.9 tagged_above=0.0 required=5.0 tests=FROM_ENDS_IN_NUMS X-Spam-Level: X-Archive-Number: 200410/353 X-Sequence-Number: 15346 Hello, I'm running a search query on a table with approximately 120.000 rows (3848 relpages, dbsize tablesize 30MB). Because of poor performance I would like to cache the complete table in memory, but I'm not sure which config param I have to use to accomplish that. The other tables in the db are rather small. What configuration values are best for this kind of database ? Postgres 8.0beta2 on a RedHat-Linux with Pentium Celeron 1500 256MB RAM Thx berger