Can Postgres cache a table in memory?

Поиск
Список
Период
Сортировка
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 по дате отправления:

Предыдущее
От: "Matthew Geddert"
Дата:
Сообщение: please help with converting a view in oracle into postgresql readably code
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: [GENERAL] CURRENT_TIMESTAMP