X-Original-To: pgsql-general@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id E0789476237; Thu, 3 Apr 2003 13:15:37 -0500 (EST) Received: from outland.mohawksoft.com (unknown [64.46.156.80]) by postgresql.org (Postfix) with ESMTP id B6B8B475D3B; Thu, 3 Apr 2003 13:15:32 -0500 (EST) Received: from mohawksoft.com (outland.mohawksoft.com [127.0.0.1]) by outland.mohawksoft.com (8.11.6/8.9.3) with SMTP id h33IQ1f01853; Thu, 3 Apr 2003 13:26:01 -0500 From: pgsql@mohawksoft.com Received: from 141.154.39.187 (SquirrelMail authenticated user pgsql) by mail.mohawksoft.com with HTTP; Thu, 3 Apr 2003 13:26:01 -0500 (EST) Message-ID: <2598.141.154.39.187.1049394361.squirrel@mail.mohawksoft.com> Date: Thu, 3 Apr 2003 13:26:01 -0500 (EST) Subject: Re: [HACKERS] OSS database needed for testing To: josh@agliodbs.com In-Reply-To: <200304030955.16543.josh@agliodbs.com> References: <200304030955.16543.josh@agliodbs.com> Cc: pgsql-general@postgresql.org, pgsql-performance@postgresql.org, pgsql-hackers@postgresql.org X-Mailer: SquirrelMail (version 1.0.6) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Spam-Status: No, hits=-24.2 required=5.0 tests=BAYES_10,IN_REP_TO,NO_REAL_NAME,QUOTED_EMAIL_TEXT, REFERENCES,REPLY_WITH_QUOTES 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/430 X-Sequence-Number: 40495 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. Also, if that is too much, I have a similar setup to load the FreeDB music database, from www.freedb.org. It has roughly 670,000 entries in "cdtitles" and 8 million entries in "cdsongs." Either one of which, I would be willing to send you the actual DB on cd(s) if you pay for postage and media.=20 =20 > Folks, >=20 > Please pardon the cross-posting. >=20 > A small group of us on the Performance list were discussing the first > steps toward constructing a comprehensive Postgresql installation > benchmarking tool, mostly to compare different operating systems and > file systemsm but later to be used as a foundation for a tuning > wizard.=20=20=20 >=20 > To do this, we need one or more real (not randomly generated*) > medium-large database which is or can be BSD-licensed (data AND > schema). This database must have: >=20 > 1) At least one "main" table with 12+ columns and 100,000+ rows (each). > 2) At least 10-12 additional tables of assorted sizes, at least half of > which should have Foriegn Key relationships to the main table(s) or > each other. 3) At least one large text or varchar field among the > various tables. >=20 > In addition, the following items would be helpful, but are not > required: 4) Views, triggers, and functions built on the database > 5) A query log of database activity to give us sample queries to work > with. 6) Some complex data types, such as geometric, network, and/or > custom data types. >=20 > Thanks for any leads you can give me! >=20 > (* To forestall knee-jerk responses: Randomly generated data does not > look or perform the same as real data in my professional opinion, and > I'm the one writing the test scripts.) >=20 > --=20 > -Josh Berkus > Aglio Database Solutions > San Francisco >=20 >=20 > ---------------------------(end of > broadcast)--------------------------- TIP 1: subscribe and unsubscribe > commands go to majordomo@postgresql.org