Re: Reduce NUMERIC size by 2 bytes, reduce max length to 508 digits

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Reduce NUMERIC size by 2 bytes, reduce max length to 508 digits
Дата
Msg-id 10154.1133570269@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Reduce NUMERIC size by 2 bytes, reduce max length to 508 digits  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Reduce NUMERIC size by 2 bytes, reduce max length to 508 digits
Список pgsql-general
I wrote:
> The actual effective limit on NUMERIC is presently 10^128K, which is
> probably enough to count the femtoseconds remaining until the heat death
> of the universe, and then multiply that by the number of elementary
> particles therein ;-).

Should have done my research first.  A little googling says that

* The total number of particles in the universe has been
  variously estimated at numbers from 10^72 up to 10^87.

* The time to the heat death of the universe has been estimated at
  10^200 years (and if there's one significant digit in that exponent
  I'd be surprised...)

So the product I fancifully mentioned would weigh in somewhere around
10^300, and thus be *well* within the capability of even the proposed
restricted numeric format.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: 8.1, OID's and plpgsql
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: 8.1, OID's and plpgsql