Re: ext3 filesystem / linux 7.3

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" <josh(at)agliodbs(dot)com>
To: "Chris Hedemark" <chrish(at)trilug(dot)org>; <pgsql-performance(at)postgresql(dot)org>
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