Re: Can Postgres cache a table in memory?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Kevin Traub" <ktraub(at)verizon(dot)net>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Can Postgres cache a table in memory?
Date: 2002-10-04 14:14:06
Message-ID: 20416.1033740846@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Kevin Traub" <ktraub(at)verizon(dot)net> writes:
> 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?

There is no need to do anything; if you're hitting the table a lot, it
should all migrate into kernel disk buffers.

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2002-10-04 14:17:34 Re: please help with converting a view in oracle into postgresql readably code
Previous Message bens_nospam 2002-10-04 14:05:11 Self Join?