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

From: David A <david(at)scalaacademy(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: My DB has has 5TB, many operations are very slow (on Google Cloud Compute)
Date: 2016-10-05 22:36:55
Message-ID: CAEgrPswkQSdrObd6nGSABO52cgPKW5x4K2jPw-HmLgN0-PVpew@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message PHANIKUMAR G 2016-10-06 06:37:02 Re: postgres failed to start from services manager on windows 2008 r2
Previous Message Darren Lafreniere 2016-10-05 20:44:50 Re: BRIN indexes and ORDER BY