Re: [PERFORM] [HACKERS] OSS database needed for testing

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: pgsql(at)mohawksoft(dot)com
Cc: josh(at)agliodbs(dot)com, pgsql-general(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [PERFORM] [HACKERS] OSS database needed for testing
Date: 2003-04-03 21:01:47
Message-ID: 20030403210147.GB30860@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-performance

On Thu, Apr 03, 2003 at 13:26:01 -0500,
pgsql(at)mohawksoft(dot)com wrote:
> I don't know that it meets your criteria, but.....
>
> I have a set of scripts and a program that will load the US Census TigerUA
> database into PostgreSQL. The thing is absolutely freak'n huge. I forget
> which, but it is either 30g or 60g of data excluding indexes.

Are the data model or the loading scripts available publicly?
I have the tiger data and a program that uses it to convert addresses
to latitude and longitude, but I don't really like the program and
was thinking about trying to load the data into a database and do
queries against the database to find location.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Nigel J. Andrews 2003-04-03 21:01:57 Re: Single Byte values
Previous Message Tom Lane 2003-04-03 20:54:54 Re: pgsql password when FreeBSD boots -- what's usual?

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Sullivan 2003-04-03 21:12:14 Re: more contrib: log rotator
Previous Message Tom Lane 2003-04-03 19:39:17 Re: Detecting corrupted pages earlier

Browse pgsql-performance by date

  From Date Subject
Next Message Robert Treat 2003-04-03 21:02:04 can i make this sql query more efficiant?
Previous Message scott.marlowe 2003-04-03 20:19:10 Re: ext3 filesystem / linux 7.3