Greg Smith <g...@2ndquadrant.com> wrote: > Attached is a patch that fixes a long standing bug in pgbench: it won't > handle scale factors above ~4000 (around 60GB) because it uses 32-bit > integers for its computations related to the number of accounts, and it > just crashes badly when you exceed that. This month I've run into two > systems where that was barely enough to exceed physical RAM, so I'd > expect this to be a significant limiting factor during 9.0's lifetime. > A few people have complained about it already in 8.4.
+1 for the fix. Do we also need to adjust "tuples done" messages during dataload? It would be too verbose for large scale factor. I think a message every 1% is reasonable. if (j % 10000 == 0) fprintf(stderr, INT64_FORMAT " tuples done.\n", j); Regards, --- Takahiro Itagaki NTT Open Source Software Center -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers