X-Original-To: pgsql-performance@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 4C0B84762A2 for ; Fri, 4 Apr 2003 11:35:07 -0500 (EST) Received: from localhost.localdomain (208-41-234-242.client.dsl.net [208.41.234.242]) by postgresql.org (Postfix) with ESMTP id AFDC5476036 for ; Fri, 4 Apr 2003 11:35:05 -0500 (EST) Received: from endeavour (endeavour.pointhere.net [192.168.2.11]) by localhost.localdomain (8.11.6/8.11.6) with SMTP id h34GOm932538; Fri, 4 Apr 2003 11:24:48 -0500 Message-ID: <0c8101c2fac9$316ad290$0b02a8c0@pointhere.net> Reply-To: "Jeffrey D. Brower" From: "Jeffrey D. Brower" To: , "Josh Berkus" Cc: References: <200304030955.16543.josh@agliodbs.com> <200304032029.12450.josh@agliodbs.com> <0c2201c2faa8$136c9c90$0b02a8c0@pointhere.net> <200304040809.22065.josh@agliodbs.com> Subject: Re: OSS database needed for testing Date: Fri, 4 Apr 2003 11:42:33 -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=-17.5 required=5.0 tests=BAYES_20,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/58 X-Sequence-Number: 1564 I think you got me there. I have to agree with both points. (Besides, you are the one coding this thing and I think you understand it better than I do.) Let me know if I can help. Jeff ----- Original Message ----- From: "Josh Berkus" To: "Jeffrey D. Brower" ; Cc: ; Sent: Friday, April 04, 2003 11:09 AM Subject: Re: [PERFORM] [HACKERS] OSS database needed for testing > Jeff, Mlw, > > > Absolutely. We could just use one large state or several small ones and > > let folks download the whole thing if they wanted. Using that technique > > you could control the size of the test quite closely and still make > > something potentially quite valuable as a contribution beyond the bench. > > Hold on a second. The FCC database is still a better choice because it is > more complex with a carefully defined schema. The Tiger database would be > good for doing tests of type 1 and 3, but not for tests of types 2 and 4. > > It would certainly be interesting to use the Tiger database as the basis for > an additional type of test: > > 6) Very Large Data Set: querying, then updating, 300+ selected rows from a > 2,000,000 + row table. > > ... but I still see the FCC database as our best candidate for the battery of > tests 1-5. > > -- > Josh Berkus > Aglio Database Solutions > San Francisco > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster