Postgres Pro
Downloads
Home   >   mailing lists

Re: To keep indexes in memory, is large enough effective_cache_sizeenough? - Mailing list pgsql-performance

From Sam R.
Subject Re: To keep indexes in memory, is large enough effective_cache_sizeenough?
Date
Msg-id 1303501281.5352660.1537355213227@mail.yahoo.com
Whole thread Raw
In response to Re: To keep indexes in memory, is large enough effective_cache_sizeenough?  ("Sam R." <samruohola@yahoo.com>)
List pgsql-performance
Tree view
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 by date:

Previous
From: "Sam R."
Date:
Subject: Re: To keep indexes in memory, is large enough effective_cache_sizeenough?
Next
From: Jeff Janes
Date:
Subject: Re: To keep indexes in memory, is large enough effective_cache_size enough?