Postgres Pro
Downloads
Home   >   mailing lists

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

From Rakesh Kumar
Subject Re: My DB has has 5TB, many operations are very slow (on Google Cloud Compute)
Date
Msg-id DM2PR05MB622B2D21E9AEFF4219913B68CDA0@DM2PR05MB622.namprd05.prod.outlook.com
Whole thread Raw
In response to Re: My DB has has 5TB, many operations are very slow (on Google Cloud Compute)  (Melvin Davidson <melvin6925@gmail.com>)
Responses Re: My DB has has 5TB, many operations are very slow (on Google Cloud Compute)  (Lucas Possamai <drum.lucas@gmail.com>)
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 
>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.

pgsql-general by date:

Previous
From: Melvin Davidson
Date:
Subject: Re: My DB has has 5TB, many operations are very slow (on Google Cloud Compute)
Next
From: Lucas Possamai
Date:
Subject: Re: My DB has has 5TB, many operations are very slow (on Google Cloud Compute)