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

From: mlw <pgsql(at)mohawksoft(dot)com>
To: Bruno Wolff III <bruno(at)wolff(dot)to>
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 22:19:13
Message-ID: 3E8CB361.4010207@mohawksoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-performance

Bruno Wolff III wrote:

>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.
>
>
>
I have a set of scripts, SQL table defs, a small C program, along with a
set of field with files that loads it into PGSQL using the "copy from
stdin" It works fairly well, but takes a good long time to load it all.

Should I put it in the download section of my website?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Hendrickson 2003-04-03 22:19:43 ERROR: heap_mark4update: (am)invalid tid in triggers
Previous Message Tom Lane 2003-04-03 22:17:20 Re: 'DROP INDEX' kills stored rpocedures

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruno Wolff III 2003-04-03 22:20:37 Re: [PERFORM] [HACKERS] OSS database needed for testing
Previous Message Tom Lane 2003-04-03 21:47:45 Stuff that doesn't work yet in IPv6 patch

Browse pgsql-performance by date

  From Date Subject
Next Message Bruno Wolff III 2003-04-03 22:20:37 Re: [PERFORM] [HACKERS] OSS database needed for testing
Previous Message Franco Bruno Borghesi 2003-04-03 22:15:15 Re: can i make this sql query more efficiant?