Postgres Pro
Downloads
Home   >   mailing lists

Can Postgres cache a table in memory? - Mailing list pgsql-sql

From Kevin Traub
Subject Can Postgres cache a table in memory?
Date
Msg-id anhio7$2ac4$1@news.hub.org
Whole thread Raw
Responses Re: Can Postgres cache a table in memory?
Re: Can Postgres cache a table in memory?
Re: Can Postgres cache a table in memory?
Re: Can Postgres cache a table in memory?
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: "Matthew Geddert"
Date:
Subject: please help with converting a view in oracle into postgresql readably code
Next
From: Martijn van Oosterhout
Date:
Subject: Re: [GENERAL] CURRENT_TIMESTAMP