Re: PATCH: pgbench - merging transaction logs - Mailing list pgsql-hackers

From Robert Haas
Subject Re: PATCH: pgbench - merging transaction logs
Date
Msg-id CA+TgmoZ8eFnFeg14bhWYstRdODLHa+f+zDtPjAweOgmPkLcUww@mail.gmail.com
Whole thread Raw
In response to Re: PATCH: pgbench - merging transaction logs  (Fabien COELHO <coelho@cri.ensmp.fr>)
Responses Re: PATCH: pgbench - merging transaction logs  (Fabien COELHO <coelho@cri.ensmp.fr>)
Re: PATCH: pgbench - merging transaction logs  (Andres Freund <andres@2ndquadrant.com>)
List pgsql-hackers
On Tue, Mar 17, 2015 at 11:27 AM, Fabien COELHO <coelho@cri.ensmp.fr> wrote:
> The fprintf we are talking about occurs at most once per pgbench
> transaction, possibly much less when aggregation is activated, and this
> transaction involves networks exchanges and possibly disk writes on the
> server.

random() was occurring four times per transaction rather than once,
but OTOH I think fprintf() is probably a much heavier-weight
operation.  The way to know if there's a real problem here is to test
it, but I'd be pretty surprised if there isn't.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Custom/Foreign-Join-APIs (Re: [v9.5] Custom Plan API)
Next
From: Robert Haas
Date:
Subject: Re: [PATCH] Add transforms feature