Re: Errors from pgbench - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: Errors from pgbench
Date
Msg-id 44EFA187.3030504@commandprompt.com
Whole thread Raw
In response to Errors from pgbench  (Jeff Davis <pgsql@j-davis.com>)
List pgsql-general
> number of transactions per client: 100000
> number of transactions actually processed: 384423/1000000
> tps = 239.586507 (including connections establishing)
> tps = 239.589618 (excluding connections establishing)
>
> The only way I see to generate that type of error is if it tried to
> insert or cast an integer too large for the data type.
>
> Is this a potential pgbench bug, or am I misusing pgbench?

Kind of both ;)... The version in HEAD does not suffer from this.

Sincerely,

Joshua D. Drake


>
> Regards,
>     Jeff Davis
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq
>


--

    === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
    Providing the most comprehensive  PostgreSQL solutions since 1997
              http://www.commandprompt.com/



pgsql-general by date:

Previous
From: Jeff Davis
Date:
Subject: Errors from pgbench
Next
From: snacktime
Date:
Subject: alternative to using a sequence