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 1tVya4-00D9EZ-7B for pgsql-general@arkaria.postgresql.org; Thu, 09 Jan 2025 19:52:36 +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 1tVya2-007GKF-Dz for pgsql-general@arkaria.postgresql.org; Thu, 09 Jan 2025 19:52:34 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tVya2-007GJs-0R for pgsql-general@lists.postgresql.org; Thu, 09 Jan 2025 19:52:33 +0000 Received: from mout.gmx.net ([212.227.15.15]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tVyZz-000lFu-03 for pgsql-general@lists.postgresql.org; Thu, 09 Jan 2025 19:52:32 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1736452348; x=1737057148; i=shammat@gmx.net; bh=kwuTZsh1ANg9AoF7t52cUooA4jW/VLba0/SOaTyspTQ=; h=X-UI-Sender-Class:Message-ID:Date:MIME-Version:Subject:To: References:From:In-Reply-To:Content-Type: Content-Transfer-Encoding:cc:content-transfer-encoding: content-type:date:from:message-id:mime-version:reply-to:subject: to; b=ARQxrHW3A5kPI6lL2xqRkQ1Zg0oqKj3XjpqgZsNCM+7RAy+6pblgbEC9NoPsOZYj d0edB4zwTQUIlCZ6RelVEZBZcip52qjGYsudY7XMvTrV/cnIsdmf7QMSm6f4eROF4 xGsQ2guOBZuCSMRLW839oxS4ZbVxed2XDu/paVktd4xITrPpmeuoQ5gd5d8Yxkfm/ Mh4Lkk2K/TRldPFpdJzJaAKo0lrCSsCt2ftwRoV6s0UZA+mChWhj4np6t1O6bQgLU gst5ILoacjS8LCS3BssRWMo85zKFOFSN5R9wmQin8KS25Ac1im5aAdt/kBRL79fld iYW97KcYEDfkM61LpA== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from [192.168.178.31] ([88.217.180.117]) by mail.gmx.net (mrgmx005 [212.227.17.190]) with ESMTPSA (Nemesis) id 1MZkpR-1u2l231hmp-00JEcf for ; Thu, 09 Jan 2025 20:52:28 +0100 Message-ID: <9e3d705e-df1d-4d32-b5ba-718f492cb1cc@gmx.net> Date: Thu, 9 Jan 2025 20:52:27 +0100 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Alter table fast To: pgsql-general@lists.postgresql.org References: Content-Language: de-DE, en-US From: shammat@gmx.net In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: quoted-printable X-Provags-ID: V03:K1:MaDHfje2iwpFc2TMsTh6uHLqh8NyQAl9qijtMn+qfVLRuoETOW+ SBq+Fbp/RqS7xrHZ4+6C9KjjjAjx4VqJCTMBzLmlHZbAZm8bU1z+f8PV0/HXbIorXdtiTNp KJNTMZ9BY2IXnesowH01V0lz+Oho7SNWY82RnscA605H/qS2sdlv3NvkOP6gLAhC5bXulJj u9OnL5mmUDhkmkrxoBhJA== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:u/0s5Ap+a48=;VQ+CWSGCG30qEhNpZBwTivgTYW+ SqiwI6WXLglOXKrdCUsAOelXd5v0AE6obc5piC75WsPqyRKupUXwam5P60AqpMtjq6Z4JI08G Ev2EKuXssHqgIBXlCR6wDD0IoyyOeDUYc7zPylK8eaNkIXjkk1+1h2NvZ+73VgwpG9GnlbDpS /DvTcXa5PjXOUeDU2+aexY0D2STjLjZ/vTJ/B2Smsj/62zxjBTPzQB7ez4xryHr6ksu2/fOH1 2BZlpdQQpdk4zbtF6WZDIadMj7UgmJpK4Dfj2XMYDhF49Zxy7oCO2/n0GI1IETg1vrbJjAv2F OEBX8+M+N8As9+q3Q4ULIrMssplym1vXhVvZSpoMbZkmki5aWFJJAswHCpf4k4+trW1aHg6kY uA7zDe4JCZ09p5Z9AgkflyvkXVgtBH3cAg1cbWDVI1YGW4lsmoZicV2coWs1QKbqXfPTNeyMH cx6zqQ7drbt0E+36v51RIUT/5VBB20NLgdfJk7EjZr5+YYZM154U96b4jOLfmvwjCRX/wdoUm PlHIUsOgCmlbqs1oc2jnkzet9pjif3d/ZW+B0MXjqfXzV4ZvO0glCaWFM8GPg3qLY+Z2LCYVd oiOAdDkTc9FJmg1evySG+N1/pir1oME/pYc4rvoVkegNxhExy1/aXfcWvOHidA6rNsdRG/cbp 8hVCXcnlxCSqrKQc1nZsYqYcc4FM8MxoWQIl4x9ZzYJ7DgKXfhoRpyzbAMt5afj5kaYaqsUaE eyq0C49KMs83bZWYflO8BanZ+b9FN56D/g87RNXXA3435i3HfFDwC/mDZQH+Dl71Q7d38+ssd cxtlueHzcUeChaOu336ZiItiP5vBK82ABNfOBzwJ6aKpLI+BJvUW0oMid6YvjUwGGAXrqXCGq 3IdIK9FkpKEm1I9nxyUFB6pUzM++EiyB6R4jA2Q7vDJDPjWXG6h3QnHmdU/69KQ9QRh5T5JyR +2ErQ6AQzex4w77fRucEhwM858sXDRi8KJIg+VduU9FOLB65QGRdb5UyGcAUVatWuUXv+qnx0 GYvGrKzM6a4yjbz9QEiReCtfJMXrLX/8gRqNjA0Pz/OsRNzVpZWdZtMsPvs7SBZTpzS8G86NO ZJN6E/31aaBrUh7Xgs4UOJQF6Lmf+R List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Am 09.01.25 um 20:17 schrieb veem v: >> Out of curiosity, why NUMERIC(15,0) instead of BIGINT? > > It's for aligning the database column types to the data model and > it's happening across all the upstream downstream systems. I was > thinking if this can be made faster with the single line alter > statement "Alter table alter column type > numeric(15,0) USING ::NUMERIC(15,0);" Hmm, I would rather change numeric(15,0) to bigint if I had to "align" typ= es across systems.