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.96)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1wA89H-0025jn-1i
	for pgsql-bugs@arkaria.postgresql.org;
	Tue, 07 Apr 2026 15:15:27 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.96)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1wA89G-0011QU-0D
	for pgsql-bugs@arkaria.postgresql.org;
	Tue, 07 Apr 2026 15:15:26 +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.96)
	(envelope-from <noreply@postgresql.org>)
	id 1w9nj9-00AqK4-2P
	for pgsql-bugs@lists.postgresql.org;
	Mon, 06 Apr 2026 17:27:08 +0000
Received: from mahout.postgresql.org ([2001:4800:3e1:1::227])
	by magus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.98.2)
	(envelope-from <noreply@postgresql.org>)
	id 1w9nj7-00000000w4o-23Ip
	for pgsql-bugs@lists.postgresql.org;
	Mon, 06 Apr 2026 17:27:07 +0000
DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed;
	d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject:
	Content-Transfer-Encoding:MIME-Version:Content-Type:Sender:Content-ID:
	Content-Description:In-Reply-To:References;
	bh=Rg7LQPWQOT8N6kqdj0r9UcSJw8Z4JveEu0sbJtk4zWY=; b=sx6tjteyBgL/+jH92ukjGjTK9D
	ziQXX8fNhRN/o/jxFvS6wDgellLTYVgVj6ZAHngTIs9cFsmzT1IBqTFPSOQF/akrjrYxGTbB4C12S
	kpq04/K8/F9MulGg0LRenOWf7ZSvHZmfR510f53f4sMXptpMkuBXHv9y1F0V5Ybg0YnoMZ2mK0xaq
	PMD7zNR0g0DZOZa1Xiwt43gGqlVqxtKR1ic9We9tXB8CNZm2Epnhndj0o7myNBXt+kBllYsgJKI3p
	rhHmnn6UPdSD8R259NQ8GG1Z86F1yJb14CqGo+F1DS4cVAmtzofHcvK5VypW6kWLAxID78vzo9m5P
	+0RSPTgw==;
Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60])
	by mahout.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <noreply@postgresql.org>)
	id 1w9nj6-002XDN-1C
	for pgsql-bugs@lists.postgresql.org;
	Mon, 06 Apr 2026 17:27:04 +0000
Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org)
	by wrigleys.postgresql.org with esmtp (Exim 4.96)
	(envelope-from <noreply@postgresql.org>)
	id 1w9nj4-000Gj6-1b
	for pgsql-bugs@lists.postgresql.org;
	Mon, 06 Apr 2026 17:27:03 +0000
Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Subject: BUG #19451: In postgreSQL v13 For 1000 tables how to update from rrn column to GUID. Each table more than 2crore
To: pgsql-bugs@lists.postgresql.org
From: PG Bug reporting form <noreply@postgresql.org>
Cc: abichchal123@gmail.com
Reply-To: abichchal123@gmail.com, pgsql-bugs@lists.postgresql.org
Date: Mon, 06 Apr 2026 17:26:40 +0000
Message-ID: <19451-e229547a8d37468b@postgresql.org>
X-Auto-Response-Suppress: All
Auto-Submitted: auto-generated
List-Id: <pgsql-bugs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-bugs@lists.postgresql.org>
List-Owner: <mailto:pgsql-bugs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-bugs>
Archived-At: <https://www.postgresql.org/message-id/19451-e229547a8d37468b%40postgresql.org>
Precedence: bulk

The following bug has been logged on the website:

Bug reference:      19451
Logged by:          Amarnath Bichchal
Email address:      abichchal123@gmail.com
PostgreSQL version: Unsupported/Unknown
Operating system:   ubuntu
Description:       =20

In postgreSQL v13 For 1000 tables how to update from rrn column to GUID.
Each table more than 2crores records. What is strategy use with no any
issues , performance, lock , need to fast complete in 2hrs to 3hrs. use
uninx script