I have strange issue with pgbench where it fails to execute step to create
primary keys when I specify scaling factor / transactions to some
reasonable high value - eg. 8k.
I am doing
$ pgbench -i -s 8000 sampledb
$ pgbench -c 10 -j 2 -t 8000 sampledb
when I fails I see
=====
vacuum...
starting vacuum...end.
====
and good case
vacuum...
set primary keys...
done.
starting vacuum...end.
Only see this with a bit reasonable values for transactions / scaling
factor ( eg. 4k,8k )
I suspected that there could be issue with memory/disk allocated to
machine, but for above case it will generate cca 150 GB of data and I have
disk with 350 GB of free space, and allocating 30GB of memory for
postgresql machine ( tried with even more resources )
I am using pgbench (PostgreSQL) 9.6.5 .
If you have any idea, please share , thank you
Elvir