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:
...