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: (view raw, whole thread or download thread mbox)
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.


In response to


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-2017 The PostgreSQL Global Development Group