X-Original-To: pgsql-general@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 0F124476323 for ; Thu, 3 Apr 2003 17:20:46 -0500 (EST) Received: from wolff.to (wolff.to [66.93.249.74]) by postgresql.org (Postfix) with SMTP id 2A2F6476036 for ; Thu, 3 Apr 2003 17:20:45 -0500 (EST) Received: (qmail 32153 invoked by uid 500); 3 Apr 2003 22:20:37 -0000 Date: Thu, 3 Apr 2003 16:20:37 -0600 From: Bruno Wolff III To: mlw 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: <20030403222037.GA32097@wolff.to> Mail-Followup-To: mlw , 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> <20030403210147.GB30860@wolff.to> <3E8CB361.4010207@mohawksoft.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <3E8CB361.4010207@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/281 X-Sequence-Number: 40346 On Thu, Apr 03, 2003 at 17:19:13 -0500, mlw wrote: > > 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? Yes. I would be interested in looking at it even if I don't use exactly the same way to do stuff. Taking a logn time to load the data into the database isn't a big deal for me. reading through the tiger (and FIPS) data documentation it seemed like there might be some gotchas in unusual cases and I am not sure the google contest program really handled things right so I would like to see another implementation. I am also interested in the data model as that will save me some time.