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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx> 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@xxxxxxxxxxxxxxx> wrote:

...







[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux