X-Original-To: pgsql-performance@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 7635A474E44 for ; Thu, 3 Apr 2003 21:36:03 -0500 (EST) Received: from localhost.localdomain (208-41-234-242.client.dsl.net [208.41.234.242]) by postgresql.org (Postfix) with ESMTP id BEE4B474E42 for ; Thu, 3 Apr 2003 21:36:01 -0500 (EST) Received: from endeavour (endeavour.pointhere.net [192.168.2.11]) by localhost.localdomain (8.11.6/8.11.6) with SMTP id h342Pg919254; Thu, 3 Apr 2003 21:25:42 -0500 Message-ID: <0c0f01c2fa53$f8eb8790$0b02a8c0@pointhere.net> Reply-To: "Jeffrey D. Brower" From: "Jeffrey D. Brower" To: , Cc: References: <200304030955.16543.josh@agliodbs.com> <2598.141.154.39.187.1049394361.squirrel@mail.mohawksoft.com> Subject: Re: [HACKERS] OSS database needed for testing Date: Thu, 3 Apr 2003 21:43:27 -0500 Organization: A Basic Marketing Company MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Spam-Status: No, hits=-20.2 required=5.0 tests=BAYES_10,ORIGINAL_MESSAGE,QUOTED_EMAIL_TEXT,RCVD_IN_NJABL, REFERENCES,X_NJABL_OPEN_PROXY 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/47 X-Sequence-Number: 1553 Hi Josh, 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. Can I vote twice? Jeff ----- Original Message ----- From: To: Cc: ; ; Sent: Thursday, April 03, 2003 1:26 PM Subject: Re: [PERFORM] [HACKERS] OSS database needed for testing > 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. > > > > Folks, > > > > Please pardon the cross-posting. > > > > 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. > > > > 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: > > > > 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. > > > > 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. > > > > Thanks for any leads you can give me! > > > > (* 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.) > > > > -- > > -Josh Berkus > > Aglio Database Solutions > > San Francisco > > > > > > ---------------------------(end of > > broadcast)--------------------------- TIP 1: subscribe and unsubscribe > > commands go to majordomo@postgresql.org > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)