> * Mark Woodward ([EMAIL PROTECTED]) 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?) ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match