Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

zipfian parameter must be in range [1.001, 1000] (not 0.990000) #1

Open
patsevanton opened this issue Nov 14, 2019 · 1 comment
Open

Comments

@patsevanton
Copy link

patsevanton commented Nov 14, 2019

Hello

free -m
              total        used        free      shared  buff/cache   available
Mem:            992          93          86          38         812         673
Swap:             0           0           0

Install

yum install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
yum install postgresql12 postgresql12-server
/usr/pgsql-12/bin/postgresql-12-setup initdb
systemctl enable postgresql-12
systemctl start postgresql-12

test:

/usr/pgsql-12/bin/pgbench -i
/usr/pgsql-12/bin/pgbench postgres -f scripts/zipfian/read.sql@50 -f scripts/zipfian/update.sql@50 -T60 -c10
starting vacuum...end.
zipfian parameter must be in range [1.001, 1000] (not 0.990000)
client 0 aborted in command 0 (SET) of script 0; evaluation of meta-command failed
zipfian parameter must be in range [1.001, 1000] (not 0.990000)
client 1 aborted in command 0 (SET) of script 1; evaluation of meta-command failed
zipfian parameter must be in range [1.001, 1000] (not 0.990000)
client 2 aborted in command 0 (SET) of script 1; evaluation of meta-command failed
zipfian parameter must be in range [1.001, 1000] (not 0.990000)
client 3 aborted in command 0 (SET) of script 1; evaluation of meta-command failed
zipfian parameter must be in range [1.001, 1000] (not 0.990000)
client 4 aborted in command 0 (SET) of script 1; evaluation of meta-command failed
zipfian parameter must be in range [1.001, 1000] (not 0.990000)
client 5 aborted in command 0 (SET) of script 0; evaluation of meta-command failed
zipfian parameter must be in range [1.001, 1000] (not 0.990000)
client 6 aborted in command 0 (SET) of script 0; evaluation of meta-command failed
zipfian parameter must be in range [1.001, 1000] (not 0.990000)
client 7 aborted in command 0 (SET) of script 1; evaluation of meta-command failed
zipfian parameter must be in range [1.001, 1000] (not 0.990000)
client 8 aborted in command 0 (SET) of script 1; evaluation of meta-command failed
zipfian parameter must be in range [1.001, 1000] (not 0.990000)
client 9 aborted in command 0 (SET) of script 1; evaluation of meta-command failed
transaction type: multiple scripts
scaling factor: 1
query mode: simple
number of clients: 10
number of threads: 1
duration: 60 s
number of transactions actually processed: 0
Run was aborted; the above results are incomplete.
@patsevanton
Copy link
Author

Change

\SET id random_zipfian(1, 100000 * :scale, 0.99)

to

\SET id random_zipfian(1, 100000 * :scale, 2)

Test is work

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant