From: Richard Huxton <dev@archonet.com>
To: Kevin Traub <ktraub@verizon.net>
To: pgsql-sql@postgresql.org
Subject: Re: Can Postgres cache a table in memory?
Date: Fri, 4 Oct 2002 14:35:52 +0100
Message-ID: <200210041435.52552.dev@archonet.com> (raw)
In-Reply-To: <anhio7$2ac4$1@news.hub.org>
References: <anhio7$2ac4$1@news.hub.org>
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 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?
You're probably just as well off if you let your OS deal with caching the
underlying file. What figures are you getting (use the "free" command if in
linux). It might be that you've given Postgresql *too* much memory, and
that's interfering with your OS.
Could you provide brief hardware specs, the size of the table concerned, time
taken?
--
Richard Huxton
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dev@archonet.com, ktraub@verizon.net
Subject: Re: Can Postgres cache a table in memory?
In-Reply-To: <200210041435.52552.dev@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox