Re: US Census database (Tiger 2004FE)

* Mark Woodward (pgsql@mohawksoft.com) wrote:
> > 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.

Not too bad.  I had 2003 (iirc) loaded into 7.4 at one point.

> pg_dump tiger | gzip > tiger.pgz

What db version are you using, how did you load it (ogr2ogr?), is it in
postgis form?  Fun questions, all of them. :)

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

I guess your upload pipe isn't very big?  snail-mail is slow... :)

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

Using the new functions in 8.1 which provide size-on-disk of things,
hopefully there's also a function to give a tuple-size or similar as
well.  It'd be a high estimate due to dead tuples but should be
sufficient for a progress bar.
Thanks,
    Stephen