Re: Can Postgres cache a table in memory?

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: "Kevin Traub" <ktraub(at)verizon(dot)net>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Can Postgres cache a table in memory?
Date: 2002-10-04 15:34:44
Message-ID: web-1771454@davinci.ethosmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Kevin,

> 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?

Please join the PGSQL-PERFORMANCE mailing list and post this question
there:

pgsql-performance-request(at)postgresql(dot)org
message: "subscribe"

-Josh Berkus

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Joe Conway 2002-10-04 15:51:42 Re: rows in order
Previous Message Bruno Wolff III 2002-10-04 15:31:08 Re: How slow is distinct - 2nd