X-Original-To: pgsql-general@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 91AF8475CEE for ; Thu, 3 Apr 2003 16:01:56 -0500 (EST) Received: from wolff.to (wolff.to [66.93.249.74]) by postgresql.org (Postfix) with SMTP id A9023475A45 for ; Thu, 3 Apr 2003 16:01:55 -0500 (EST) Received: (qmail 31207 invoked by uid 500); 3 Apr 2003 21:01:47 -0000 Date: Thu, 3 Apr 2003 15:01:47 -0600 From: Bruno Wolff III To: pgsql@mohawksoft.com 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 Message-ID: <20030403210147.GB30860@wolff.to> Mail-Followup-To: pgsql@mohawksoft.com, josh@agliodbs.com, pgsql-general@postgresql.org, pgsql-performance@postgresql.org, pgsql-hackers@postgresql.org References: <200304030955.16543.josh@agliodbs.com> <2598.141.154.39.187.1049394361.squirrel@mail.mohawksoft.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <2598.141.154.39.187.1049394361.squirrel@mail.mohawksoft.com> User-Agent: Mutt/1.5.4i X-Spam-Status: No, hits=-34.6 required=5.0 tests=BAYES_10,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, REFERENCES,REPLY_WITH_QUOTES,SUSPICIOUS_RECIPS, USER_AGENT_MUTT version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/271 X-Sequence-Number: 40336 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.