Postgres Pro
Downloads
Home   >   mailing lists

Re: 600 million rows of data. Bad hardware or need partitioning? - Mailing list pgsql-performance

From Arya F
Subject Re: 600 million rows of data. Bad hardware or need partitioning?
Date
Msg-id CAFoK1azRs4pWL+5nQUC2r6E3G3jhrgNq08h9ve1xaECYMy==YA@mail.gmail.com
Whole thread Raw
In response to Re: 600 million rows of data. Bad hardware or need partitioning?  (Michael Lewis <mlewis@entrata.com>)
Responses 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>)
List pgsql-performance
Tree view 
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 by date:

Previous
From: Michael Lewis
Date:
Subject: Re: 600 million rows of data. Bad hardware or need partitioning?
Next
From: David Rowley
Date:
Subject: Re: 600 million rows of data. Bad hardware or need partitioning?