Re: To keep indexes in memory, is large enough effective_cache_sizeenough?

Поиск
Список
Период
Сортировка
От Sam R.
Тема Re: To keep indexes in memory, is large enough effective_cache_sizeenough?
Дата
Msg-id 1303501281.5352660.1537355213227@mail.yahoo.com
обсуждение исходный текст
Ответ на Re: To keep indexes in memory, is large enough effective_cache_sizeenough?  ("Sam R." <samruohola@yahoo.com>)
Список pgsql-performance
Дерево обсуждения
Size of the index of one huge table has been e.g. 16-20 GB (after REINDEX).

Size of such an index is quite big.
 
BR Samuli

On Wednesday, September 19, 2018 2:01 PM, Sam R. <samruohola@yahoo.com> wrote:


Hi!

Thanks for all of the comments!

David wrote:
> if you mention
> how muchRAM the server has and how big the data is now

Let's say for example:
RAM: 64 GB
Data: 500 GB - 1.5 TB, for example.

( RAM: Less would of course be better, e.g. 32 GB, but we could maybe go for an even little bit bigger value than 64 GB, if needed to. )

BR Sam

On Wednesday, September 19, 2018 1:11 PM, David Rowley <david.rowley@2ndquadrant.com> wrote:

...






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

Предыдущее
От: "Sam R."
Дата:
Сообщение: Re: To keep indexes in memory, is large enough effective_cache_sizeenough?
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: To keep indexes in memory, is large enough effective_cache_size enough?