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 1qmo47-0090DT-RI for pgsql-general@arkaria.postgresql.org; Sun, 01 Oct 2023 04:28:23 +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 1qmo44-005GaR-Ew for pgsql-general@arkaria.postgresql.org; Sun, 01 Oct 2023 04:28:20 +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 1qmo44-005GX1-0Q for pgsql-general@lists.postgresql.org; Sun, 01 Oct 2023 04:28:20 +0000 Received: from mail-yw1-x112a.google.com ([2607:f8b0:4864:20::112a]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qmo41-007YVE-13 for pgsql-general@lists.postgresql.org; Sun, 01 Oct 2023 04:28:18 +0000 Received: by mail-yw1-x112a.google.com with SMTP id 00721157ae682-59f7cc71e2eso130750927b3.0 for ; Sat, 30 Sep 2023 21:28:16 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1696134376; x=1696739176; darn=lists.postgresql.org; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=L0WYDizjxztLoFHEXMsqNLWaESGKlPSr/8jbFWeigLQ=; b=kTa9smY3xgATonTcnbxhVSINmfYLyRqYG7CwJkn6B4qRzVK51XyPCqsS/HH0HKM1Xf UuZ2+4HFYL4/dPdh/fe4Lo96kWpm21FHeHkeHIpKj8N6+2gZmjUPZ/BsNh3U11EIzVtI b+iaOrS/JBdlqdOJG1zxGbqTXJ6ZTIYklzqbGLtUhz1gMvm9+TQ+JIV9RK+2t2zcmeoK GKRrMVEpk/3WhtDMfY9Og9DDC71NlBvkrDde3WgDDJxnBF17NC3wAZIRLhCuyjAFNTrg NWmrUd3NjVToa0hJ/DqDMrKHo9jVM7Y34ck+w7JEM6REM/FXnvuAoeiyji8AzVHFFh3m /2NA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1696134376; x=1696739176; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=L0WYDizjxztLoFHEXMsqNLWaESGKlPSr/8jbFWeigLQ=; b=CvgObPHAt/2YpazeUyrEr2Dmre85bCgS+9fOiydAiL2Uu4YLlmYhD0sOEbcWee9vA6 hBzwIhIUsrPxNEcD1MKM3Vy4J3fWZUqfZNeBS2NvXZOfyrRRpAtpNrLIOiVewMBxcPFW 0smewILp4dCEqhUMOzBLqNkFSumsjz3l6B6kjhj4QB84zSxSLWFdm5H/70Ou2ML49+xP vUh5bzDO8xsoP7WsN1gZJbBRUy/gcl59HDo44ySD7qUbYXxlw2GRyiPsTy51E7JbHdQz jPxsKQvZtd9eNFZvnEjka0H2wyLOgxOO6jRsoCHWOyQ6lnp7hDaiV7egkA5jxC0mjvEg Fqng== X-Gm-Message-State: AOJu0YyHFw+o1XRwHFxD6IadoqD98uUSulqn/B8AVJtZKW6syfujQWz5 bmGTqbn0rwwqTGspnZELQNozd5wbxPM= X-Google-Smtp-Source: AGHT+IHYc+Z2OQ/W33MTWRQjiEDRxhcI5HmRcB30jEGpVw0ZBhwzMp7Hzu/NOVHNjJiQC3Ugv8fD3Q== X-Received: by 2002:a81:71c4:0:b0:577:3d46:f90e with SMTP id m187-20020a8171c4000000b005773d46f90emr7985615ywc.32.1696134376059; Sat, 30 Sep 2023 21:26:16 -0700 (PDT) Received: from ?IPV6:2600:1700:bd2c:b810:75e3:be98:7e14:76fa? ([2600:1700:bd2c:b810:75e3:be98:7e14:76fa]) by smtp.googlemail.com with ESMTPSA id w5-20020a0dd405000000b00570599de9a5sm3787171ywd.88.2023.09.30.21.26.15 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sat, 30 Sep 2023 21:26:15 -0700 (PDT) Message-ID: Date: Sat, 30 Sep 2023 23:26:14 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.11.0 Subject: Re: Gradual migration from integer to bigint? Content-Language: en-US To: pgsql-general@lists.postgresql.org References: <1635509.1696131447@sss.pgh.pa.us> From: Ron In-Reply-To: <1635509.1696131447@sss.pgh.pa.us> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 9/30/23 22:37, Tom Lane wrote: [snip] > especially not a break that adds more per-row overhead. > > So really the only way forward for this would be to provide more > automation for the existing conversion processes involving table > rewrites. When altering an unindexed INT to BIGINT, do all of the indices get rewritten? -- Born in Arizona, moved to Babylonia.