Search Postgresql Archives

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

Subject: Re: My DB has has 5TB, many operations are very slow (on Google Cloud Compute)
From: Lucas Possamai <drum.lucas@xxxxxxxxx>
Date: Wed, 12 Oct 2016 08:13:05 +1300
Cc: Melvin Davidson <melvin6925@xxxxxxxxx>, Francisco Olarte <folarte@xxxxxxxxxxxxxx>, David A <david@xxxxxxxxxxxxxxxx>, "pgsql-general@xxxxxxxxxxxxxx" <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <DM2PR05MB622B2D21E9AEFF4219913B68CDA0@DM2PR05MB622.namprd05.prod.outlook.com>
References: <CAEgrPswkQSdrObd6nGSABO52cgPKW5x4K2jPw-HmLgN0-PVpew@mail.gmail.com> <CA+bJJbw=cgQr-4fSCAqF35ctBswftKiXqmKMM4O1N603T5X42g@mail.gmail.com> <CANu8Fizp7-SoWLhdZ=hXBQdW6VqWxePq30NsvEh=zG3vTM40gg@mail.gmail.com> <DM2PR05MB622B2D21E9AEFF4219913B68CDA0@DM2PR05MB622.namprd05.prod.outlook.com>

Instance RAM: 60GB
Instance CPU: 16Cores

I got a 3TB Postgres Database running with a Dual Socket Octo Core Intel Xeon E5-2630v3 with 128GB of RAM and SATA disks.

I think yes, you could improve your server's RAM. However Melvin is right, there is no enough information.

Lucas

References:
- My DB has has 5TB, many operations are very slow (on Google Cloud Compute)
  - From: David A
- Re: My DB has has 5TB, many operations are very slow (on Google Cloud Compute)
  - From: Francisco Olarte
- Re: My DB has has 5TB, many operations are very slow (on Google Cloud Compute)
  - From: Melvin Davidson
- Re: My DB has has 5TB, many operations are very slow (on Google Cloud Compute)
  - From: Rakesh Kumar