Re: Best partition type for billions of addresses

2020-05-02 Thread Stephen Frost
Greetings, * Arya F (arya6...@gmail.com) wrote: > > * Arya F (arya6...@gmail.com) wrote: > > > I need to store about 600 million rows of property addresses across > > > multiple counties. I need to have partitioning setup on the table as > > > there will be updates and inserts performed to the tab

Re: Best partition type for billions of addresses

2020-05-02 Thread Arya F
> * Arya F (arya6...@gmail.com) wrote: > > I need to store about 600 million rows of property addresses across > > multiple counties. I need to have partitioning setup on the table as > > there will be updates and inserts performed to the table frequently > > and I want the queries to have good per

Re: Best partition type for billions of addresses

2020-05-02 Thread Stephen Frost
Greetings, * Arya F (arya6...@gmail.com) wrote: > I need to store about 600 million rows of property addresses across > multiple counties. I need to have partitioning setup on the table as > there will be updates and inserts performed to the table frequently > and I want the queries to have good p

Re: Best partition type for billions of addresses

2020-05-02 Thread Justin Pryzby
On Sat, May 02, 2020 at 09:20:06AM -0400, Arya F wrote: > I need to store about 600 million rows of property addresses across > multiple counties. I need to have partitioning setup on the table as > there will be updates and inserts performed to the table frequently > and I want the queries to have

Best partition type for billions of addresses

2020-05-02 Thread Arya F
I need to store about 600 million rows of property addresses across multiple counties. I need to have partitioning setup on the table as there will be updates and inserts performed to the table frequently and I want the queries to have good performance. >From what I understand hash partitioning wo