Re: [PERFORM] OSS database needed for testing - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: [PERFORM] OSS database needed for testing
Date
Msg-id 200304040809.22065.josh@agliodbs.com
Whole thread Raw
In response to OSS database needed for testing  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: more contrib: log rotator
Next
From: "scott.marlowe"
Date:
Subject: Re: more contrib: log rotator