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 143013A482F for ; Thu, 28 Oct 2004 06:58:43 +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 48016-03 for ; Thu, 28 Oct 2004 05:58:40 +0000 (GMT) Received: from web50010.mail.yahoo.com (web50010.mail.yahoo.com [206.190.38.25]) by svr1.postgresql.org (Postfix) with SMTP id 837113A480F for ; Thu, 28 Oct 2004 06:58:39 +0100 (BST) Message-ID: <20041028055839.18967.qmail@web50010.mail.yahoo.com> Received: from [200.93.192.137] by web50010.mail.yahoo.com via HTTP; Thu, 28 Oct 2004 00:58:39 CDT Date: Thu, 28 Oct 2004 00:58:39 -0500 (CDT) From: Jaime Casanova Subject: Re: caching complete table for optimizing search ? To: pgsql-admin@postgresql.org In-Reply-To: <2563CFA30A899A44BEFF5BC0CB030F7617FC10@NYPEXCH01.NYPOST> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/357 X-Sequence-Number: 15350 > 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. Maybe a redesign of the query is a better idea. What about creating indexes? If you provide info about the tables and the query maybe we can help you. Your table is very small (just 120.000 rows) but think about cache a table of millions of rows thats not optimus. > > What configuration values are best for this kind of > database ? > > Postgres 8.0beta2 on a > RedHat-Linux with > Pentium Celeron 1500 > 256MB RAM > There are some docs talking about modifiyng the postgresql.conf, but i said info about your database, your tables and data is needed. Maybe the PERFORMANCE list is more adecuate. > > Thx > berger > > you welcome. regards, Jaime Casanova _________________________________________________________ Do You Yahoo!? Información de Estados Unidos y América Latina, en Yahoo! Noticias. Visítanos en http://noticias.espanol.yahoo.com