My DB has has 5TB, many operations are very slow (on Google Cloud Compute)

[David A <david@xxxxxxxxxxxxxxxx>]

Hi,

My DB has has 5TB, it's on Google Cloud Compute, mostly on SSDs, part on Standard Persistent Disks.

Querying is ok, but deleting, moving between tablespaces, dropping tables, etc, etc is hugely slow

(note: I do have a number of indexes)

Instance RAM: 60GB
Instance CPU: 16Cores

I'm just wondering - anyone has any thoughts or suggestions about performance?

Any would be much appreciated

(I'm wandering if I just need faster instances/disks or if I'm doing something wrong)

Any one has similar DB sizes? what CPU/RAM/Disks do you have?

Thanks,

David

Scala Academy