On 15/04/11 16:35, Mark Kirkwood wrote:
Here's a simplified example using synthetic data (see attached to
generate if desired):
For anyone else who might be want to play with this:
Patch with correction to make the directory reassignment work correctly,
plus an additional comment in the README mentioning the need to set this
in the generator and loading scripts.
Thanks
Mark
diff -c starjoin.orig/gendata.pl starjoin/gendata.pl
*** starjoin.orig/gendata.pl 2011-04-17 10:55:28.252595067 +1200
--- starjoin/gendata.pl 2011-04-17 10:55:48.684595066 +1200
***************
*** 14,20 ****
my %prevcatids;
print "generate cat\n";
! open(FH, "> /data0/dump/cat.dat") || die ("cannot open cat.dat: $!");
for ($i = 0; $i < $catrows; $i++) {
$catid = $i;
--- 14,20 ----
my %prevcatids;
print "generate cat\n";
! open(FH, "> $dir/cat.dat") || die ("cannot open cat.dat: $!");
for ($i = 0; $i < $catrows; $i++) {
$catid = $i;
diff -c starjoin.orig/README starjoin/README
*** starjoin.orig/README 2011-04-17 10:55:28.252595067 +1200
--- starjoin/README 2011-04-17 10:56:29.292595065 +1200
***************
*** 1,5 ****
--- 1,6 ----
Setup for (hopefully) excessive join memory use.
+ $ vi gendata.pl load.sql # set dump/load directory
$ ./gendata.pl
$ psql test < schema.sql
$ psql test < load.sql
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
