Re: review: pgbench - aggregation of info written into log

Поиск
Список
Период
Сортировка
От Tomas Vondra
Тема Re: review: pgbench - aggregation of info written into log
Дата
Msg-id e85fdaf3bddf47d29ad114646bc3734d@fuzzy.cz
обсуждение исходный текст
Ответ на Re: review: pgbench - aggregation of info written into log  (Magnus Hagander <magnus@hagander.net>)
Ответы Re: review: pgbench - aggregation of info written into log  (Andrew Dunstan <andrew@dunslane.net>)
Список 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 по дате отправления:

Предыдущее
От: Tomas Vondra
Дата:
Сообщение: Re: review: pgbench - aggregation of info written into log
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Materialized views WIP patch