Re: [NOVICE] Postgres storing time in strange manner

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [NOVICE] Postgres storing time in strange manner
Дата
Msg-id 12219.1032302262@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [NOVICE] Postgres storing time in strange manner  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: [NOVICE] Postgres storing time in strange manner  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-bugs
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Tom Lane wrote:
>> with -ffast-math gcc will "improve" it to
>>
>> int hour = time * 0.000277777777777778;

> Hard to imagine why anyone would want such an optimization.  How much
> faster could it possibly be?

Back in ye bad olde days, there was probably an order-of-magnitude
difference between the speed of a float multiply and that of a float
divide; so this used to be a pretty standard sort of optimization.
I can remember doing the equivalent thing by hand in source code.

On modern hardware I doubt it makes much difference...

            regards, tom lane

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [NOVICE] Postgres storing time in strange manner
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [NOVICE] Postgres storing time in strange manner