Content-Type: text/plain;
  charset="iso-8859-1"
From: Richard Huxton <dev@archonet.com>
Organization: Archonet Ltd
To: "Kevin Traub" <ktraub@verizon.net>, pgsql-sql@postgresql.org
Subject: Re: Can Postgres cache a table in memory?
Date: Fri, 4 Oct 2002 14:35:52 +0100
User-Agent: KMail/1.4.3
References: <anhio7$2ac4$1@news.hub.org>
In-Reply-To: <anhio7$2ac4$1@news.hub.org>
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Message-Id: <200210041435.52552.dev@archonet.com>

On Thursday 03 Oct 2002 3:03 pm, Kevin Traub wrote:
> Hello all;
>
> I'm trying to speed up a query which returns the majority of a table so a=
nd
> 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?

You're probably just as well off if you let your OS deal with caching the=
=20
underlying file. What figures are you getting (use the "free" command if in=
=20
linux). It might be that you've given Postgresql *too* much memory, and=20
that's interfering with your OS.

Could you provide brief hardware specs, the size of the table concerned, ti=
me=20
taken?

--=20
  Richard Huxton