Re: 64-bit size pgbench

Greg Smith <greg(at)2ndquadrant(dot)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