Re: pgbench duration option - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pgbench duration option
Date
Msg-id 8861.1219105120@sss.pgh.pa.us
Whole thread Raw
In response to Re: pgbench duration option  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: pgbench duration option  (ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
List pgsql-hackers
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Greg Smith wrote:
>> Last time I tried to quantify the overhead of logging with timestamps on 
>> I couldn't even measure its impact, it was lower than the usual pgbench  
>> noise.

> There's a hardware deficiency on certain machines -- I think it's old
> ones.  I don't know if machines that would currently be used in
> production would contain such a problem.

My understanding is that it's basically "cheap PC hardware" (with clock
interfaces based on old ISA bus specs) that has the issue in a
significant way.  I wouldn't expect you to see it on a serious database
server.  But lots of people still do development on cheap PC hardware,
which is why I think this is worth worrying about.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Extending varlena
Next
From: Tom Lane
Date:
Subject: Re: Patch: plan invalidation vs stored procedures