Re: review: pgbench - aggregation of info written into log - Mailing list pgsql-hackers

From Tomas Vondra
Subject Re: review: pgbench - aggregation of info written into log
Date
Msg-id e85fdaf3bddf47d29ad114646bc3734d@fuzzy.cz
Whole thread Raw
In response to Re: review: pgbench - aggregation of info written into log  (Magnus Hagander <magnus@hagander.net>)
Responses Re: review: pgbench - aggregation of info written into log
List pgsql-hackers
Dne 17.01.2013 11:16, Magnus Hagander napsal:
> On Thu, Jan 17, 2013 at 11:09 AM, Dave Page <dpage@pgadmin.org> 
> wrote:
>> On Thu, Jan 17, 2013 at 9:36 AM, Magnus Hagander 
>> <magnus@hagander.net> wrote:
>>> We have committed platform-specific features before, but generally
>>> only when it's not *possible* to do them for all platforms. For
>>> example the posix_fadvise stuff isn't available on Windows at all, 
>>> so
>>> there isn't much we can do there.
>>
>> Right - having platform specific features for other reasons like 
>> lack
>> of time is a slippery slope in my opinion. We should not get into 
>> such
>> a habit or Windows will quickly become a second class platform as 
>> far
>> as PostgreSQL features are concerned.
>
> Especially since there is no lack of time - the functionality is
> there, it just looks (significantly) different.

Really? Any link to relevant docs or something?

When doing some research in this field, the only option I was able to 
come up
with was combining gettimeofday() with the timing functionality, and do 
something
like this:
  1) call gettimeofday() at thread start, giving a common unix 
timestamp  2) measure the time from the thread start using the conters (for each 
transaction)  3) combine those values

This might of course give up to a second difference compared to the 
actual time
(because of the gettimeofday precision), but IMHO that's fine.

An even simpler option would omit the (1), so the timestamps would 
start at 0.

Or is there a better way?

Tomas



pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: review: pgbench - aggregation of info written into log
Next
From: Robert Haas
Date:
Subject: Re: Materialized views WIP patch