X-Original-To: pgsql-performance@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 41861474E42 for ; Fri, 4 Apr 2003 07:11:04 -0500 (EST) Received: from snoopy.mohawksoft.com (h0030f1382639.ne.client2.attbi.com [24.60.194.163]) by postgresql.org (Postfix) with ESMTP id EA3D7474E42 for ; Fri, 4 Apr 2003 07:10:32 -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 h34CLoZ30121; Fri, 4 Apr 2003 07:21:54 -0500 Message-ID: <3E8D78DD.1060202@mohawksoft.com> Date: Fri, 04 Apr 2003 07:21:49 -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: Josh Berkus Cc: "Jeffrey D. Brower" , pgsql-performance@postgresql.org Subject: Re: [HACKERS] OSS database needed for testing References: <200304030955.16543.josh@agliodbs.com> <2598.141.154.39.187.1049394361.squirrel@mail.mohawksoft.com> <0c0f01c2fa53$f8eb8790$0b02a8c0@pointhere.net> <200304032029.12450.josh@agliodbs.com> 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/52 X-Sequence-Number: 1558 Josh Berkus wrote: >Jeff, > > > >>Let me vote on the Tiger data. I used to use this database. It is public, >>updated by the government, VERY useful in own right, it works well with the >>earthdistance contribution, a real world database a lot of us use and I >>think you can put together some killer scripts on it. >> >> > >We'd have to use a subset of it. 30G is a little larger than anything we >want people to download as a test package. > > > Actually, come to think of it, the TigerUA DB is in chunks. You can use as much or as little as you want. I'll put the loader scripts on my download page tonight. Here is the home page for the data: http://www.census.gov/geo/www/tiger/tigerua/ua_tgr2k.html