On Wed, Feb 25, 2009 at 10:24:21PM -0500, Robert Haas wrote:
> I don't think we're really doing this the right way. EXPLAIN ANALYZE
> has a measurable effect on the results, and we probably ought to stop
> the database and drop the VM caches after each query. Are the Z1-Z7
> datasets on line someplace? I might be able to rig up a script here.
They're automatically generated by the dbgen utility, a link to which
was originally published somewhere in this thread. That tool creates a
few text files suitable (with some tweaking) for a COPY command. I've
got the original files... the .tbz I just made is 1.8 GB :) Anyone have
someplace they'd like me to drop it?
In response to
pgsql-hackers by date
|Next:||From: Robert Haas||Date: 2009-02-26 14:54:18|
|Subject: Re: 8.4 release planning (was Re: [COMMITTERS] pgsql: Automatic view update rules)|
|Previous:||From: Andrew Dunstan||Date: 2009-02-26 13:54:29|
|Subject: Re: xpath processing brain dead|