unsubscrible
От | Cleber |
---|---|
Тема | unsubscrible |
Дата | |
Msg-id | 000401c6c7b5$9e191610$3c01a8c0@CLEBER обсуждение исходный текст |
Ответ на | Large database design advice ("Joe Kramer" <cckramer@gmail.com>) |
Список | pgsql-general |
----- 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 > >
В списке pgsql-general по дате отправления: