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

From Jasen Betts
Subject Re: 110,000,000 rows
Date
Msg-id hu0468$3cv$1@reversiblemaps.ath.cx
Whole thread Raw
In response to 110,000,000 rows  (John Gage <jsmgage@numericable.fr>)
Responses Re: 110,000,000 rows  (Steve Crawford <scrawford@pinpointresearch.com>)
List pgsql-general
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.

you're probably going to want to partition it somehow.


pgsql-general by date:

Previous
From: Giles Lean
Date:
Subject: Re: Libpq Asynchronous Command Processing
Next
From: Craig Ringer
Date:
Subject: Re: Libpq Asynchronous Command Processing