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

Поиск
Список
Период
Сортировка
От Rakesh Kumar
Тема Re: My DB has has 5TB, many operations are very slow (on Google Cloud Compute)
Дата
Msg-id DM2PR05MB622B2D21E9AEFF4219913B68CDA0@DM2PR05MB622.namprd05.prod.outlook.com
обсуждение исходный текст
Ответ на Re: My DB has has 5TB, many operations are very slow (on Google Cloud Compute)  (Melvin Davidson <melvin6925@gmail.com>)
Ответы 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>)
Список 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.



В списке pgsql-general по дате отправления:

Предыдущее
От: Melvin Davidson
Дата:
Сообщение: Re: My DB has has 5TB, many operations are very slow (on Google Cloud Compute)
Следующее
От: Lucas Possamai
Дата:
Сообщение: Re: My DB has has 5TB, many operations are very slow (on Google Cloud Compute)