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

Поиск

Список

Период

Сортировка

От	David A
Тема	My DB has has 5TB, many operations are very slow (on Google Cloud Compute)
Дата	11 октября 2016 г. 19:28:37
Msg-id	CAEgrPswkQSdrObd6nGSABO52cgPKW5x4K2jPw-HmLgN0-PVpew@mail.gmail.com обсуждение исходный текст
Ответы	Re: My DB has has 5TB, many operations are very slow (on Google Cloud Compute) (Francisco Olarte <folarte@peoplecall.com>)
Список	pgsql-general

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 по дате отправления:

От: Rémi Cura
Дата: 11 октября 2016 г., 19:27:19
Сообщение: forcing a table (parent in inheritance) tor emain empty

От: "Natan Abolafya"
Дата: 11 октября 2016 г., 19:29:21
Сообщение: BDR: changing dsn on a running node