From: | Gregory Maxwell <gmaxwell(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, "John D(dot) Burger" <john(at)mitre(dot)org>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Reduce NUMERIC size by 2 bytes, reduce max length to 508 digits |
Date: | 2005-12-05 19:07:27 |
Message-ID: | e692861c0512051107y126c01a3h13e85a6d98b34ef9@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers pgsql-patches |
On 12/5/05, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> > Not only does 4000! not work, but 400! doesn't even work. I just lost
> > demo "wow" factor points!
>
> It looks like the limit would be about factorial(256).
>
> The question remains, though, is this computational range good for
> anything except demos?
I've hesitated commenting, because I think it might be a silly reason,
but perhaps it's one other people share. ... I use PG as a
calculator for big numbers because it's the only user friendly thing
on my system that can do factorial(300) - factorial(280). I'd rather
use something like octave, but I've found its pretty easy to escape
its range. If the range for computation is changed, then I'll
probably keep an old copy around just for this, though I'm not quite
sure how much I'd be affected..
From | Date | Subject | |
---|---|---|---|
Next Message | Rory Campbell-Lange | 2005-12-05 19:14:37 | Using a 250GB RAID10 server for postgres |
Previous Message | Eric E | 2005-12-05 19:02:27 | Preventing or controlling runaway queries |
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2005-12-05 19:15:28 | Re: [PATCHES] snprintf() argument reordering not working |
Previous Message | Andrew Dunstan | 2005-12-05 19:02:07 | Re: [PATCHES] snprintf() argument reordering not working |
From | Date | Subject | |
---|---|---|---|
Next Message | Volkan YAZICI | 2005-12-05 19:10:57 | Re: mvcc.sgml make up |
Previous Message | Andrew Dunstan | 2005-12-05 19:02:07 | Re: [PATCHES] snprintf() argument reordering not working |