----- Original Message -----
From: "Michael Fuhr" <mike@fuhr.org>
To: "Harald Armin Massa" <haraldarminmassa@gmail.com>
Cc: "Joe Kramer" <cckramer@gmail.com>; <>
Sent: Thursday, August 24, 2006 2:37 PM
Subject: Re: [GENERAL] Large database design advice
> On Thu, Aug 24, 2006 at 07:19:29PM +0200, Harald Armin Massa wrote:
>> so with serial there are only 2.147.483.648 possible recordnumbers.
>
> Actually 2147483647 using the default sequence start value of 1 and
> going up to 2^31 - 1, the largest positive value a 32-bit integer
> can hold. You could get the full 32-bit range (4294967296) by
> allowing negative numbers and setting the sequence's MINVALUE and
> RESTART value to -2^31 (-2147483648).
>
>> Which should still be enough for "millions of records"
>
> Correct.
>
> --
> Michael Fuhr
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.405 / Virus Database: 268.11.5/426 - Release Date: 23/8/2006
>
>