Re: pgbench regression test failure

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
Cc: PostgreSQL Developers <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: pgbench regression test failure
Date: 2017-09-12 17:13:22
Message-ID: 4233.1505236402@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> writes:
>> Apparently, one of the threads ran 3 transactions where the test script
>> expects it to run at most 2. Is this a pgbench bug, or is the test
>> being overoptimistic about how exact the "-T 2" cutoff is?

> Probably both? It seems that cutting off on time is not a precise science,
> so I suggest to accept 1, 2 and 3 lines, see attached.

Before I'd deciphered the test output fully, I was actually guessing that
the problem was the opposite, namely too few lines. Isn't it possible
that some thread is slow enough to start up that it doesn't get to run
any transactions? IOW, do we need to allow 0 to 3 lines?

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2017-09-12 17:17:58 domain type smashing is expensive
Previous Message Konstantin Knizhnik 2017-09-12 17:11:27 Re: Cached plans and statement generalization