Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tb3ie-007cai-FD for pgsql-admin@arkaria.postgresql.org; Thu, 23 Jan 2025 20:22:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tb3id-0047xZ-41 for pgsql-admin@arkaria.postgresql.org; Thu, 23 Jan 2025 20:22:27 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tb3ic-0047xQ-PZ for pgsql-admin@lists.postgresql.org; Thu, 23 Jan 2025 20:22:26 +0000 Received: from mailout.easymail.ca ([64.68.200.34]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tb3iZ-00191K-0j for pgsql-admin@lists.postgresql.org; Thu, 23 Jan 2025 20:22:26 +0000 Received: from localhost (localhost [127.0.0.1]) by mailout.easymail.ca (Postfix) with ESMTP id 07ADB6215C for ; Thu, 23 Jan 2025 20:22:21 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=elevated-dev.com; s=easymail; t=1737663741; bh=RKmSaJe+tLjg++/tuMAUqSvjqICKCh19mAyDlOacjVo=; h=From:Subject:Date:References:To:In-Reply-To:From; b=ElEmMs1mYInWuuIKOuc1m/3uSbnUupg4SbuiOZuzleJZffVOfqfdSXCcaai0+C0fr o1AQwQqH+HrlyCxeQSQWLZv5GqaAOSY7l8Onj4Rgc1rY9VqPxferDvBK/GJAGb9PSk xuKb9E8ljkVea3z7UQ2JS27gsVprcOB7/XUAq9msLOxOHLBl5rouKED0ghwOC2Qwuk Abu/D3kE1W280To+axh7ZwvGdDQ6ootfoPKxnMsGFK6M2za1bw2yucrNlGI9QhqaMP sjusUtlcCi/4C1CbhUfUMWcvsHZ1QaxrRdkg7lPhyX/3zhlBo0YOAqqII4flv3teb1 OMaYzQ0y4Ww1A== X-Virus-Scanned: Debian amavisd-new at emo07-pco.easydns.vpn Received: from mailout.easymail.ca ([127.0.0.1]) by localhost (emo07-pco.easydns.vpn [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 21tuicn4oU4z for ; Thu, 23 Jan 2025 20:22:20 +0000 (UTC) Received: from smtpclient.apple (unknown [165.140.184.195]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by mailout.easymail.ca (Postfix) with ESMTPSA id 8C5BF61FCD for ; Thu, 23 Jan 2025 20:22:20 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=elevated-dev.com; s=easymail; t=1737663740; bh=RKmSaJe+tLjg++/tuMAUqSvjqICKCh19mAyDlOacjVo=; h=From:Subject:Date:References:To:In-Reply-To:From; b=lDGyR4XRXcWdWzAYaixaDGvL4LPT/q2UbdiiyVar9axPc4WS0nHqZaCqQGbPyAZkE jJxmCaLFPziZbi0c01ymBnkbWe/3PO6r7XKuey6LjQALR7ZK7A6dsyrLjzkTphitk9 uySgYJzUNA+or/nDcMuNB8R143yq2iCc+EdKWyfi4eOd9/Bn0+3QOp8iEH6yqtjm7a JY9c2ZErggWANN3DHjSyQuSbkxTQl7Ahj1+wF8R/FdiO8OWNj+blhRsPNDOkCBP4/w fFGoSnnSs6c8jG25EVdwiBDC5NCKR5gRQgf8DrnfCVL1homls4KPHsXtyXaWBxZD3I dk+/ALvZTWlWg== From: Scott Ribe Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3826.300.87.4.3\)) Subject: Re: [EXT] Sequence Cycle question Date: Thu, 23 Jan 2025 13:22:10 -0700 References: <202380.1737654100@sss.pgh.pa.us> To: Pgsql-admin In-Reply-To: Message-Id: <2D959E91-FF1C-4761-BA3E-B9EE09874244@elevated-dev.com> X-Mailer: Apple Mail (2.3826.300.87.4.3) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On Jan 23, 2025, at 12:37=E2=80=AFPM, Wong, Kam Fook (TR Technology) = wrote: >=20 > 1) Create a new column with bigint datatype (double the max limits of = int). Double the width, ~4,000,000,000 times max limit > ... > 5) Then this will buy you time to consider other design options for = PK. =20 Like, until the sun burns out and engulfs the earth ;-) -- Scott Ribe scott_ribe@elevated-dev.com https://www.linkedin.com/in/scottribe/