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?
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 |
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 |
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? |