Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id DE08F476F96 for ; Fri, 4 Oct 2002 09:04:33 -0400 (EDT) Received: from matrix.gatewaynet.com (unknown [217.19.69.50]) by postgresql.org (Postfix) with ESMTP id 59B7F476EA3 for ; Fri, 4 Oct 2002 09:02:54 -0400 (EDT) Received: from localhost (achill@localhost) by matrix.gatewaynet.com (8.11.6/8.11.6) with ESMTP id g94DE3Z24785; Fri, 4 Oct 2002 16:14:03 +0300 Date: Fri, 4 Oct 2002 16:14:03 +0300 (EEST) From: Achilleus Mantzios To: Kevin Traub Cc: pgsql-sql@postgresql.org Subject: Re: Can Postgres cache a table in memory? In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/57 X-Sequence-Number: 9775 On Thu, 3 Oct 2002, Kevin Traub wrote: > Hello all; > > I'm trying to speed up a query which returns the majority of a table so and > index isn't helpful. > I've got more than enough RAM to hold my table so, can anyone tell me if > there is there a way to force Postgres to cache a table in RAM? > > Any help would be appreciated. You need to tune first of all shared_buffers. Change the postgres.conf file usual in $PGDATA directory. Bare in mind that one buffer holds 8k of data. > > Thanks; > -Kevin Traub > > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > ================================================================== Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4, Glyfada Athens 16610 Greece tel: +30-10-8981112 fax: +30-10-8981877 email: achill@matrix.gatewaynet.com mantzios@softlab.ece.ntua.gr