Re: pgbench with large scale factor

From: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
To: Tatsuo Ishii <ishii(at)postgresql(dot)org>
Cc: PostgreSQL Developers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pgbench with large scale factor
Date: 2013-12-12 07:02:41
Message-ID: alpine.DEB.2.10.1312120801280.11842@sto
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Hello Tatsuo,

>> BTW, I saw this with 9.3.2's pgbench:
>>
>> 239300000 of 3800000000 tuples (-48%) done (elapsed 226.86 s, remaining -696.10 s).
>>
>> -48% does not seem to be quite correct to me...
>
> Included is a proposed fix for this (also fixing weired "remaining"
> part). If there's no objection, I will commit it.

Looks ok, but I would consider switching to "double" instead of "int64".

--
Fabien.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dev Kumkar 2013-12-12 07:04:39 Re: Case sensitivity
Previous Message Haribabu kommi 2013-12-12 06:54:51 Re: Heavily modified big table bloat even in auto vacuum is running