Re: 64-bit size pgbench

Greg Smith <greg@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