Thomas Lockhart wrote:
> > > > 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...
> The speed difference is still there; you can't do a divide with one pass
> through a barrel shifter, which is how the multiply operations were sped
> up. I vaguely recall something like a 40:1 ratio on a 604 PowerPC but
> that may not be accurate, or may be for integers which have similar
Wow, 40:1 is a major difference.
> > And you would have to do a heck of a lot of them to see a difference.
> ?? Some applications *do* do a heck of a lot of them ;)
Yep, I am sure. The question is whether there is ever a reason to use
such a flag on the database code. My guess is no.
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
pgsql-bugs by date
|Next:||From: Bruce Momjian||Date: 2002-09-18 04:07:33|
|Subject: Re: Schemas not available for pl/pgsql %TYPE....|
|Previous:||From: Bruce Momjian||Date: 2002-09-17 22:42:19|
|Subject: Re: [NOVICE] Postgres storing time in strange manner|