Re: How does PG know if data is in memory?

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: How does PG know if data is in memory?
Дата
Msg-id 4CA324CD0200002500036117@gw.wicourts.gov
обсуждение исходный текст
Ответ на How does PG know if data is in memory?  (Fabrício dos Anjos Silva<fabricio.silva@linkcom.com.br>)
Список pgsql-performance
Fabrício dos Anjos Silva<fabricio.silva@linkcom.com.br> wrote:

> After reading lots of documentation, I still don't understand
> fully how PG knows if some needed data is in memory or in second
> storage.

> Does PG consider this?

No.

> When setting seq_page_cost and random_page_cost, do I have to
> consider the probability that data will be in memory?

Yes.

-Kevin

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

Предыдущее
От: Fabrício dos Anjos Silva
Дата:
Сообщение: How does PG know if data is in memory?
Следующее
От: Fabrício dos Anjos Silva
Дата:
Сообщение: Wrong index choice