X-Original-To: pgsql-performance@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id E26B0474E4F for ; Thu, 3 Apr 2003 12:04:42 -0500 (EST) Received: from localhost.localdomain (208-41-234-242.client.dsl.net [208.41.234.242]) by postgresql.org (Postfix) with ESMTP id 4B54F47636C for ; Thu, 3 Apr 2003 12:04:40 -0500 (EST) Received: from endeavour (endeavour.pointhere.net [192.168.2.11]) by localhost.localdomain (8.11.6/8.11.6) with SMTP id h33GsV910691; Thu, 3 Apr 2003 11:54:32 -0500 Message-ID: <0b7a01c2fa04$2d299bf0$0b02a8c0@pointhere.net> Reply-To: "Jeffrey D. Brower" From: "Jeffrey D. Brower" To: "Josh Berkus" , "Chris Hedemark" , References: <231C6A82-65C3-11D7-8D88-0003939CC61E@trilug.org> <200304030852.34194.josh@agliodbs.com> Subject: Re: ext3 filesystem / linux 7.3 Date: Thu, 3 Apr 2003 12:12:16 -0500 Organization: Green Visor, Inc. 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/34 X-Sequence-Number: 1540 Can't we generate data? Random data stored in random formats at random sizes would stress the file system wouldn't it? ----- Original Message ----- From: "Josh Berkus" To: "Chris Hedemark" ; Sent: Thursday, April 03, 2003 11:52 AM Subject: Re: [PERFORM] ext3 filesystem / linux 7.3 > Chris, > > > Being a mere sysadmin, it is creation of the test cases (perl script, > > maybe?) that I'll have to ask someone else with more of a development > > bent to help with. > > I'll write the test queries and perl scripts if someone else can supply the > database. Unfortunately, while I have a few databases that meet the > criteria, they are all NDA. > > Criteria again: > Must have at least 100,000 rows with 12+ columns in "main" table. > Must have at least 10-12 additional tables, some with FK relationships to the > main table and each other. > Must be OK to make contents public. > More is better up to 500MB. > > -- > Josh Berkus > Aglio Database Solutions > San Francisco > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster