Re: 600 million rows of data. Bad hardware or need partitioning?

Поиск
Список
Период
Сортировка
От Arya F
Тема Re: 600 million rows of data. Bad hardware or need partitioning?
Дата
Msg-id CAFoK1azRs4pWL+5nQUC2r6E3G3jhrgNq08h9ve1xaECYMy==YA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: 600 million rows of data. Bad hardware or need partitioning?  (Michael Lewis <mlewis@entrata.com>)
Ответы Re: 600 million rows of data. Bad hardware or need partitioning?  (David Rowley <dgrowleyml@gmail.com>)
Re: 600 million rows of data. Bad hardware or need partitioning?  (Justin Pryzby <pryzby@telsasoft.com>)
Список pgsql-performance
Дерево обсуждения 
On Sun, May 3, 2020 at 11:46 PM Michael Lewis <mlewis@entrata.com> wrote:
>
> What kinds of storage (ssd or old 5400 rpm)? What else is this machine running?

Not an SSD, but an old 1TB 7200 RPM HDD

> What configs have been customized such as work_mem or random_page_cost?

work_mem = 2403kB
random_page_cost = 1.1

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

Предыдущее
От: Michael Lewis
Дата:
Сообщение: Re: 600 million rows of data. Bad hardware or need partitioning?
Следующее
От: David Rowley
Дата:
Сообщение: Re: 600 million rows of data. Bad hardware or need partitioning?