Re: US Census database (Tiger 2004FE)

From: "Mark Woodward" <pgsql(at)mohawksoft(dot)com>
To: "Stephen Frost" <sfrost(at)snowman(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: US Census database (Tiger 2004FE)
Date: 2005-08-04 12:40:18
Message-ID: 22897.24.91.171.78.1123159218.squirrel@mail.mohawksoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> * Mark Woodward (pgsql(at)mohawksoft(dot)com) wrote:
>> I just finished converting and loading the US census data into
>> PostgreSQL
>> would anyone be interested in it for testing purposes?
>>
>> It's a *LOT* of data (about 40+ Gig in PostgreSQL)
>
> How big dumped & compressed? I may be able to host it depending on how
> big it ends up being...

It's been running for about an hour now, and it is up to 3.3G.

pg_dump tiger | gzip > tiger.pgz

I'll let you know. Hopefully, it will fit on DVD.

You know, ... maybe pg_dump needs a progress bar? (How would it do that, I
wonder?)

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Stephen Frost 2005-08-04 12:42:34 Re: US Census database (Tiger 2004FE)
Previous Message Palle Girgensohn 2005-08-04 12:17:09 problem building 7.3 on FreeBSD 6