pg.ddx.io pgsql-performance@postgresql.org mailing list archivehelp / color / mirror / Atom feed
From: Jeffrey D. Brower <jeff@pointhere.net>
To: pgsql@mohawksoft.com
To: Josh Berkus <josh@agliodbs.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: OSS database needed for testing
Date: Fri, 4 Apr 2003 11:42:33 -0500
Message-ID: <0c8101c2fac9$316ad290$0b02a8c0@pointhere.net> (raw)
References: <200304030955.16543.josh@agliodbs.com>
<200304032029.12450.josh@agliodbs.com>
<0c2201c2faa8$136c9c90$0b02a8c0@pointhere.net>
<200304040809.22065.josh@agliodbs.com>
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" <josh@agliodbs.com>
To: "Jeffrey D. Brower" <jeff@Green-Visor.US>; <pgsql@mohawksoft.com>
Cc: <pgsql-performance@postgresql.org>; <pgsql-hackers@postgresql.org>
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
view thread (19+ messages) latest in thread
Message-ID: <0c8101c2fac9$316ad290$0b02a8c0@pointhere.net> Permalink: ../0c8101c2fac9$316ad290$0b02a8c0@pointhere.net/ Also on: postgresql.org/message-id/0c8101c2fac9$316ad290$0b02a8c0@pointhere.net ·
reply
Reply instructions: You may reply publicly to this message via plain-text email using any one of the following methods: * Reply to all the recipients from your mail client; the link fills in the headers below: reply via email Some clients, webmail especially, drop In-Reply-To and References from a link, and the reply then starts a new thread: use the mbox below. To: pgsql-performance@postgresql.org Cc: jeff@pointhere.net, pgsql@mohawksoft.com, josh@agliodbs.com Subject: Re: OSS database needed for testing In-Reply-To: <0c8101c2fac9$316ad290$0b02a8c0@pointhere.net> References: <200304030955.16543.josh@agliodbs.com> <200304032029.12450.josh@agliodbs.com> <0c2201c2faa8$136c9c90$0b02a8c0@pointhere.net> <200304040809.22065.josh@agliodbs.com> <0c8101c2fac9$316ad290$0b02a8c0@pointhere.net> * Save the following mbox file, import it into your mail client, and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox