From: | "Cleber" <cleber(at)siscomp(dot)inf(dot)br> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | unsubscrible |
Date: | 2006-08-24 19:43:41 |
Message-ID: | 000401c6c7b5$9e191610$3c01a8c0@CLEBER |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
----- Original Message -----
From: "Michael Fuhr" <mike(at)fuhr(dot)org>
To: "Harald Armin Massa" <haraldarminmassa(at)gmail(dot)com>
Cc: "Joe Kramer" <cckramer(at)gmail(dot)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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jasbinder Bali | 2006-08-24 19:46:00 | Re: Shared Objects (Dynamic loading) |
Previous Message | Thomas Kellerer | 2006-08-24 19:32:07 | Re: SQL:2003 Window Functions for postgresql 8.3? |