From: Euler Taveira de Oliveira <euler@timbira.com>
To: Greg Smith <greg@2ndquadrant.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: pgbench to the MAXINT
Date: Mon, 10 Jan 2011 02:17:14 -0300
Message-ID: <4D2A965A.3000603@timbira.com> (raw)
In-Reply-To: <4D27C4E5.5000609@2ndquadrant.com>
References: <4D27C4E5.5000609@2ndquadrant.com>
Em 07-01-2011 22:59, Greg Smith escreveu:
> setrandom: invalid maximum number -2147467296
>
It is failing at atoi() circa pgbench.c:1036. But it just the first one. There
are some variables and constants that need to be converted to int64 and some
functions that must speak 64-bit such as getrand(). Are you working on a patch?
> It doesn't throw any error during the initialization step, neither via
> client or database logs, even though it doesn't do anything whatsoever.
> It just turns into the quickest pgbench init ever. That's the exact
> threshold, because this works:
>
AFAICS that is because atoi() is so fragile.
> So where we're at now is that the maximum database pgbench can create is
> a scale of 21474.
>
That's because 21475 * 100,000 > INT_MAX. We must provide an alternative to
atoi() that deals with 64-bit integers.
--
Euler Taveira de Oliveira
http://www.timbira.com/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: euler@timbira.com, greg@2ndquadrant.com
Subject: Re: pgbench to the MAXINT
In-Reply-To: <4D2A965A.3000603@timbira.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox