Re: [HACKERS] Proposed Patch to Improve Performance ofMulti-BatchHash Join for Skewed Data Sets

2009-02-26 Thread Lawrence, Ramon
> That seems VERY useful - can you post the other ones (Z1, etc.) so I > can download them all? The Z1 data set is posted at: http://people.ok.ubc.ca/rlawrenc/tpch1g1z.zip I have not generated Z2, Z3, Z4 for 1G, but I can generate the Z2 and Z3 data sets, and in a hour or two they will be at: h

Re: [HACKERS] Proposed Patch to Improve Performance ofMulti-BatchHash Join for Skewed Data Sets

2009-02-26 Thread Robert Haas
> I have posted a pg_dump of the TPCH 1G Z0 data set at: > > http://people.ok.ubc.ca/rlawrenc/tpch1g0z.zip That seems VERY useful - can you post the other ones (Z1, etc.) so I can download them all? Thanks, ...Robert -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make

Re: [HACKERS] Proposed Patch to Improve Performance ofMulti-BatchHash Join for Skewed Data Sets

2009-02-26 Thread Lawrence, Ramon
> 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 > somepl