Postgres Pro
Downloads
Home   >   mailing lists

My DB has has 5TB, many operations are very slow (on Google Cloud Compute) - Mailing list pgsql-general

From David A
Subject My DB has has 5TB, many operations are very slow (on Google Cloud Compute)
Date
Msg-id CAEgrPswkQSdrObd6nGSABO52cgPKW5x4K2jPw-HmLgN0-PVpew@mail.gmail.com
Whole thread Raw
Responses Re: My DB has has 5TB, many operations are very slow (on Google Cloud Compute)  (Francisco Olarte <folarte@peoplecall.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Rémi Cura
Date:
Subject: forcing a table (parent in inheritance) tor emain empty
Next
From: "Natan Abolafya"
Date:
Subject: BDR: changing dsn on a running node