"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