Re: Problem in
От | Jean-David Beyer |
---|---|
Тема | Re: Problem in |
Дата | |
Msg-id | 705abf29-df59-a583-1c5f-0894f2e15021@verizon.net обсуждение исходный текст |
Ответ на | Re: Problem in (Max Lipsky <maxlipsky@gmail.com>) |
Список | pgsql-sql |
On 4/27/19 3:32 AM, Max Lipsky wrote: > Error comes from FSIN/FCOS instruction, but as Tom said — it’s OK (within acceptable limits). > It was just a little unexpected for me :) Back in my programming days, a friend was having trouble with a large (in memory) table of floating point numbers on an IBM/360. She was trying to do a statistical analysis of those numbers and getting strange results. I had her add up all the numbers and print the sum. I then had her sort the same numbers, add them up, and print the sum. The numbers were originally in "random" order, but they were summed from large to small after the sort. The sorted numbers summed to less than the random ones. She finally decided that the computer hardware was bad. In a sense, it was, though it worked within specifications. The system/360 was a hexadecimal machine; i.e., the floating point fraction could have up to 3 leading zeros in the fraction part of a floating point number. And the 32-bit word size was even worse than the3 36-bit word size of the IBM/7094 binary machines she was used to. So if you add up a bunch of large floating point numbers with small ones following, the small ones pretty much do not count (round-off). Had she shorted them small to large, she would have gotten the biggest answer. The same problems were affecting her statistical analysis. Basically, the System/360 machines were disasters as far as mathematical calculations were concerned. Shorter word size, and inferior floating point representation. This at a time when Burroughs machines were 48 bits and Control Data machines had 60-bit word size. -- .~. Jean-David Beyer /V\ PGP-Key:166D840A 0C610C8B /( )\ Shrewsbury, New Jersey ^^-^^ 11:55:01 up 1 day, 14:06, 2 users, load average: 4.92, 4.66, 4.69
В списке pgsql-sql по дате отправления: