Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group