Re: splitting data into multiple tables

From: Craig James <craig_james(at)emolecules(dot)com>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: nair rajiv <nair331(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: splitting data into multiple tables
Date: 2010-01-25 19:31:38
Message-ID: 4B5DF19A.9050308@emolecules.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Kevin Grittner wrote:
> nair rajiv <nair331(at)gmail(dot)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't know what they mean. Thousand, million, billion and so forth are the English words that everyone knows.

Craig

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tory M Blue 2010-01-25 22:17:14 Re: Data Set Growth causing 26+hour runtime, on what we believe to be very simple SQL
Previous Message Kevin Grittner 2010-01-25 17:47:22 Re: splitting data into multiple tables