Re: Can Postgres cache a table in memory?

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: Can Postgres cache a table in memory?
Дата
Msg-id 200210041435.52552.dev@archonet.com
обсуждение исходный текст
Ответ на Can Postgres cache a table in memory?  ("Kevin Traub" <ktraub@verizon.net>)
Список pgsql-sql
On Thursday 03 Oct 2002 3:03 pm, Kevin Traub wrote:
> 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?

You're probably just as well off if you let your OS deal with caching the
underlying file. What figures are you getting (use the "free" command if in
linux). It might be that you've given Postgresql *too* much memory, and
that's interfering with your OS.

Could you provide brief hardware specs, the size of the table concerned, time
taken?

--  Richard Huxton


В списке pgsql-sql по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: please help with converting a view in oracle into postgresql readably code
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: rows in order