From: | Josh Berkus <josh(at)agliodbs(dot)com> |
---|---|
To: | "Jeffrey D(dot) Brower" <jeff(at)Green-Visor(dot)US>, <pgsql(at)mohawksoft(dot)com> |
Cc: | <pgsql-performance(at)postgresql(dot)org>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [PERFORM] OSS database needed for testing |
Date: | 2003-04-04 16:09:22 |
Message-ID: | 200304040809.22065.josh@agliodbs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers pgsql-performance |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2003-04-04 16:12:43 | Re: Meaning of <sequence>.log_cnt? |
Previous Message | Tom Lane | 2003-04-04 15:58:51 | Re: feature request - adding columns with default value |
From | Date | Subject | |
---|---|---|---|
Next Message | scott.marlowe | 2003-04-04 16:16:39 | Re: more contrib: log rotator |
Previous Message | Peter Eisentraut | 2003-04-04 15:13:13 | Re: more contrib: log rotator |
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2003-04-04 16:16:01 | Re: can i make this sql query more efficiant? |
Previous Message | Stephan Szabo | 2003-04-04 15:29:43 | Re: [BUGS] Rapid deteriation of performance (might be |