X-Original-To: pgsql-general@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 2C9D1476036; Thu, 3 Apr 2003 17:07:55 -0500 (EST) Received: from snoopy.mohawksoft.com (h0030f1382639.ne.client2.attbi.com [24.60.194.163]) by postgresql.org (Postfix) with ESMTP id 4ABDD475CE5; Thu, 3 Apr 2003 17:07:54 -0500 (EST) Received: from mohawksoft.com (snoopy.mohawksoft.com [127.0.0.1]) by snoopy.mohawksoft.com (8.11.6/8.11.6) with ESMTP id h33MJDZ23701; Thu, 3 Apr 2003 17:19:13 -0500 Message-ID: <3E8CB361.4010207@mohawksoft.com> Date: Thu, 03 Apr 2003 17:19:13 -0500 From: mlw User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.1) Gecko/20020823 Netscape/7.0 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Bruno Wolff III Cc: josh@agliodbs.com, pgsql-general@postgresql.org, pgsql-performance@postgresql.org, pgsql-hackers@postgresql.org Subject: Re: [PERFORM] [HACKERS] OSS database needed for testing References: <200304030955.16543.josh@agliodbs.com> <2598.141.154.39.187.1049394361.squirrel@mail.mohawksoft.com> <20030403210147.GB30860@wolff.to> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Spam-Status: No, hits=-25.9 required=5.0 tests=BAYES_01,EMAIL_ATTRIBUTION,REFERENCES,USER_AGENT_MOZILLA_UA autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/431 X-Sequence-Number: 40496 Bruno Wolff III wrote: >On Thu, Apr 03, 2003 at 13:26:01 -0500, > pgsql@mohawksoft.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?