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 <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1se8zo-004GcM-0g
	for pgsql-general@arkaria.postgresql.org; Wed, 14 Aug 2024 08:04:40 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1se8zl-008xMK-Ls
	for pgsql-general@arkaria.postgresql.org; Wed, 14 Aug 2024 08:04:37 +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 <ddevienne@gmail.com>)
	id 1se8zl-008xMB-54
	for pgsql-general@lists.postgresql.org; Wed, 14 Aug 2024 08:04:37 +0000
Received: from mail-oi1-x230.google.com ([2607:f8b0:4864:20::230])
	by makus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <ddevienne@gmail.com>)
	id 1se8ze-004fgF-OK
	for pgsql-general@lists.postgresql.org; Wed, 14 Aug 2024 08:04:35 +0000
Received: by mail-oi1-x230.google.com with SMTP id 5614622812f47-3db16129143so3572944b6e.0
        for <pgsql-general@lists.postgresql.org>; Wed, 14 Aug 2024 01:04:30 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1723622670; x=1724227470; darn=lists.postgresql.org;
        h=content-transfer-encoding:to:subject:message-id:date:from
         :in-reply-to:references:mime-version:from:to:cc:subject:date
         :message-id:reply-to;
        bh=qSbb9QuGVz3EpbLQWefC9EyOag4LpG0ges5AgZSW+r4=;
        b=Qt3r9NvE2n3OX7ltvF4LaOoo/ymkD5nabXazuXoHN9XrxepyHnlYXvHyKjZhmdMQvy
         bpSlUSDRGku/JdGMBy0gr4MubivJn7MsWAotLWS/6CyZITWARHTqfOyq3iLjfgh2z6my
         fbS3okK79fabzUJ7AmNu/g2abllHW1eQb94d3AERphQhaiHFaU9s0eDHTLcoVR4RRGJV
         O/CmYdf3VcFVlziqRZo3FVuBnWjCrYqE15yeVUF1DjZ2wLb4LdsR1SQXt+rtknP4xIqZ
         i1nWLp7cegQv5h5bTF4HJeaxFL/0s4SxGWo5brfby0Q4E0y6Cgk5qM4PcbYcoPepsISk
         bzOw==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1723622670; x=1724227470;
        h=content-transfer-encoding:to:subject:message-id:date:from
         :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc
         :subject:date:message-id:reply-to;
        bh=qSbb9QuGVz3EpbLQWefC9EyOag4LpG0ges5AgZSW+r4=;
        b=Ew7nD0FuxcqRHcRHgX5osvEeL9KJqBVWjgkj91cpAm0S0AQ7QBiP+dn9vPk99f/C6k
         0ZsFGz6HuAr1v+trVUbpzLC4gUXaJixU4+qz8sOtTOjH0PcPgMvdwd6z+dmr9W5c2WYT
         KQ4dfdINz3C7kyGpOA6aDwk6Hsj6AHEoLhuAAkLyPDHk19OMxRVItKYL5xiiWSdu1jZo
         WFa3jD2BXFQgfbo5VA2sm6sPP8f+1pWNoaXOrswhG8pbJAFejlEdPlGVWtKg6c3mXXyy
         zzVoYpC0RfFZU+/AwdVEQ6t0lAQWQyEkq9D6Eu/QVjZ7tTh/UH482Fu7pJemCvRPBmQJ
         N/hQ==
X-Gm-Message-State: AOJu0YzG17RHrBLuIjsVBMQoT/2dmSprrFAdjaZPPh62LIA45M0Kf25Y
	vCOQ7KDM1fZch9Uwk4/XY1n1916mpHpx9qSnJLJKX4PgunMr2A8inGgny0Rsx/q+Lq69L8KBRtf
	mFppjnkgv7XSycTmZW8l3MmJ1bfy4RA==
X-Google-Smtp-Source: AGHT+IG0a7hzCsqY9rcXoNulLyUo4XNQra2Yym3j6vPvJO7i/NKiA4Qsl5hawHxEni0f9/BSTvQOW9r593WrYbriOZs=
X-Received: by 2002:a05:6808:4484:b0:3d9:22a4:d5f3 with SMTP id
 5614622812f47-3dd29912cf8mr2195540b6e.21.1723622669747; Wed, 14 Aug 2024
 01:04:29 -0700 (PDT)
MIME-Version: 1.0
References: <CAD=mzVUX13ZM16kP4QhY+F5XiLr=ezCXftKOTKA4eUvhphgOJw@mail.gmail.com>
 <CAKna9Vb_mx+dX02XOV6mpr8RFC-5io38kM6=4xRHQj_MUvQ+aQ@mail.gmail.com>
 <CAKAnmmJ6fqyYafLB_im75oxxfTuCLUY0ftBPU57pUm0g+pm6FQ@mail.gmail.com>
 <CAKna9VZJ4fginFJZenGQxWs9eAw9Z8g-YkdnOFcie5RvuJ=5OQ@mail.gmail.com>
 <CAKAnmmLv72uk1p8+zmWpkC+BTatrdmRe_NpRbwRsi1LAU-cJFQ@mail.gmail.com>
 <CAKna9VZGwtNx9NAZ0QjdT-WhtFETAaFzpUsvM6R90mjaAoP3vA@mail.gmail.com>
 <CAD=mzVVS6HbV25M7EA+TJYk22G=GJvQK5Gbe9eeifYSmadYtNA@mail.gmail.com>
 <CAKna9Vb0ABStAWogCsXK+jTT9ZuLESJ0_-r3Wtvd=rZpYMYwxw@mail.gmail.com>
 <CAKAnmm+_avfVEFGgADebEyH=oQrEDuvviOcMYNa+myjJrds8Eg@mail.gmail.com>
 <CAKna9VaA5N7sNRmjL7QujG92Mk-rx-7R1nSGhOVNZyXma=8LPw@mail.gmail.com> <20240813205351.eqzihh5t7urh7olf@hjp.at>
In-Reply-To: <20240813205351.eqzihh5t7urh7olf@hjp.at>
From: Dominique Devienne <ddevienne@gmail.com>
Date: Wed, 14 Aug 2024 10:04:17 +0200
Message-ID: <CAFCRh-_5Mpj64rNkx0NTHY3dpB2OZyVOm5PKwUKwRiBTejCqhw@mail.gmail.com>
Subject: Re: Column type modification in big tables
To: pgsql-general@lists.postgresql.org
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/CAFCRh-_5Mpj64rNkx0NTHY3dpB2OZyVOm5PKwUKwRiBTejCqhw%40mail.gmail.com>
Precedence: bulk

On Tue, Aug 13, 2024 at 10:54=E2=80=AFPM Peter J. Holzer <hjp-pgsql@hjp.at>=
 wrote:
> You could look at the data files. Tables in PostgreSQL are stored as a
> series of 1GB files, so you watching them being created and/or read
> gives you a pretty good idea about progress.

Thanks Peter, very insightful. Appreciated. --DD