Quick Links

Can Postgres cache a table in memory?

From:	"Kevin Traub" <ktraub(at)verizon(dot)net>
To:	pgsql-sql(at)postgresql(dot)org
Subject:	Can Postgres cache a table in memory?
Date:	2002-10-03 14:03:56
Message-ID:	anhio7$2ac4$1@news.hub.org
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-sql

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.

Thanks;
-Kevin Traub

Responses

Re: Can Postgres cache a table in memory? at 2002-10-04 13:14:03 from Achilleus Mantzios
Re: Can Postgres cache a table in memory? at 2002-10-04 13:35:52 from Richard Huxton
Re: Can Postgres cache a table in memory? at 2002-10-04 14:14:06 from Tom Lane
Re: Can Postgres cache a table in memory? at 2002-10-04 15:34:44 from Josh Berkus

Browse pgsql-sql by date

	From	Date	Subject
Next Message	Charles H. Woloszynski	2002-10-03 14:26:59	Re: Large databases, performance
Previous Message	Shridhar Daithankar	2002-10-03 14:03:30	Re: Large databases, performance