Re: 110,000,000 rows - Mailing list pgsql-general

From Steve Crawford
Subject Re: 110,000,000 rows
Date
Msg-id 4C056D2B.70701@pinpointresearch.com
Whole thread Raw
In response to Re: 110,000,000 rows  (Jasen Betts <jasen@xnet.co.nz>)
Responses Re: 110,000,000 rows  (John Gage <jsmgage@numericable.fr>)
List pgsql-general
On 05/31/2010 03:48 AM, Jasen Betts wrote:
> On 2010-05-26, John Gage<jsmgage@numericable.fr>  wrote:
>
>> Please forgive this intrusion, and please ignore it, but how many
>> applications out there have 110,000,000 row tables?  I recently
>> multiplied 85,000 by 1,400 and said now way Jose.
>>
> census data would be one.
> USA phone whitepages.
> transaction records at a medium sized bank bank
Text messages, phone-bills, tweets, etc. I have single tables of
market-research-related data that exceed 80-million rows.

But a question to the OP: Setting aside for the moment that
85000*1400=119,000,000, not 110,000,000; what is the significance to you
of these numbers?

Cheers,
Steve



pgsql-general by date:

Previous
From: Bill Moran
Date:
Subject: Re: What Linux edition we should chose?
Next
From: John Gage
Date:
Subject: Re: 110,000,000 rows