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

From: Rakesh Kumar <rakeshkumar464(at)outlook(dot)com>
To: Melvin Davidson <melvin6925(at)gmail(dot)com>, Francisco Olarte <folarte(at)peoplecall(dot)com>
Cc: David A <david(at)scalaacademy(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: My DB has has 5TB, many operations are very slow (on Google Cloud Compute)
Date: 2016-10-11 19:00:46
Message-ID: DM2PR05MB622B2D21E9AEFF4219913B68CDA0@DM2PR05MB622.namprd05.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>Cores do not help, postgres is single-threaded. RAM MAY help, but I

I hope this is no longer true from 9.6 for those queries where PG can use parallelism.

>suspect your operations are IO bound. Of course, with the sparseness
>of the details, one can not say too much.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lucas Possamai 2016-10-11 19:13:05 Re: My DB has has 5TB, many operations are very slow (on Google Cloud Compute)
Previous Message Melvin Davidson 2016-10-11 18:33:03 Re: My DB has has 5TB, many operations are very slow (on Google Cloud Compute)