Re: splitting data into multiple tables - Mailing list pgsql-performance

From Craig James
Subject Re: splitting data into multiple tables
Date
Msg-id 4B5DF19A.9050308@emolecules.com
Whole thread Raw
In response to Re: splitting data into multiple tables  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: splitting data into multiple tables
List pgsql-performance
Kevin Grittner wrote:
> nair rajiv <nair331@gmail.com> wrote:
>
>> I found there is a table which will approximately have 5 crore
>> entries after data harvesting.
>> Is it advisable to keep so much data in one table ?
>
> That's 50,000,000 rows, right?

You should remember that words like lac and crore are not English words, and most English speakers around the world
don'tknow what they mean.  Thousand, million, billion and so forth are the English words that everyone knows. 

Craig

pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: splitting data into multiple tables
Next
From: Tory M Blue
Date:
Subject: Re: Data Set Growth causing 26+hour runtime, on what we believe to be very simple SQL