I was aware that there are, in fact, many applications such as census
data or cell phone calls that would easily surpass this number.
However these applications exist in very large companies/organizations
that can throw essentially unlimited resources at the problem. One
thinks of the NSA's computers, for example.
What I was surprised to learn is the extremely common occurence of
table sizes like this even in databases run by single individuals for
individual needs.
Putting aside the cognitive challenge posed by data like this, what
made me glad to have asked the question were the solutions provided in
the responses.
John
On Jun 1, 2010, at 10:27 PM, Steve Crawford wrote:
>> 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
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general