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

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..

In response to

Browse pgsql-general by date

  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

Browse pgsql-hackers by date

  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

Browse pgsql-patches by date

  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