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 1uR9hw-007RRY-Rv for pgsql-admin@arkaria.postgresql.org; Mon, 16 Jun 2025 13:17:04 +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 1uR9hu-000Bmo-Ob for pgsql-admin@arkaria.postgresql.org; Mon, 16 Jun 2025 13:17:03 +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 1uR9hu-000Bmg-Aq for pgsql-admin@lists.postgresql.org; Mon, 16 Jun 2025 13:17:03 +0000 Received: from mail-ej1-x629.google.com ([2a00:1450:4864:20::629]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uR9hs-002Muv-2P for pgsql-admin@lists.postgresql.org; Mon, 16 Jun 2025 13:17:02 +0000 Received: by mail-ej1-x629.google.com with SMTP id a640c23a62f3a-ad89ee255easo826883366b.3 for ; Mon, 16 Jun 2025 06:17:00 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1750079819; x=1750684619; darn=lists.postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=RCzsCX9u1qNYn4Vu9zI39EhniegoNff91G+S8Eil+E8=; b=cD3FlJpw3KnemU5AH8q/j456cgyMK8F5D0Q/cgabsnON5+14t1ycxF41lZKmjvxtl1 xvtZUUE0+5cplsBPctZF61ep4oBd5lOWVArX4a0dvrWbo1YNlCv98HLGZSpWzh5Ibn/C HmieDs4ouGsd1KK6t59l/aPJUE6ccgIqsapSeQwM+w9SOienc1jIrCpeN6eR6kwVL2cm rMA1rd/5TRBT8g7BV+aJ84909RMcEE0OWVJARTpYpfVb2OMFIeGEu9SdnQn/VG0pps3I 2EYO4hUROV2lPojxQMA3wvomzi61Aq5pDjbbu1PeOh4IakI5fdvoaKDoSTzRcM2tTYoB SwlQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1750079819; x=1750684619; h=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=RCzsCX9u1qNYn4Vu9zI39EhniegoNff91G+S8Eil+E8=; b=jEXhzCF77jQw2YDLzjBCWDEIxsJZB/v7hdmK3imbTJk4hjBbUSf7adLN7NcP2mdrnj PdD/0FCF7Y/yKvrowIEfOOtpIhqnII3iRInVtKasYfEG296nJGTRT/k0/zpcF5/1xPVK F3mdFrBvANpVYuTV9z/FcZt6CnuCfER48Lk3xTNN09NIfxmjh2AoqGH4XN1T9HQM5SlI egocbRFLObjbZmJXNZkK/QWjCzFVcWdl15tM35+uoint1jdCIn5/gz8KdKRumakAYNWO JsvWVR/5xTdDWHpdLeortLufss3cB7apityXOy3z2uVx4Dk92d72Sfx5zbD7aUKXs2kR /IVA== X-Gm-Message-State: AOJu0Yxanhr1otpLBrxDIZI4nz6AW6npH9zJkWXoFtNYmNGs8HTQnUoH QR5/RP31CfjEt0wl3fmDU8nSKqW/7Qkeipj+1HLtKXYxxhLabg79Fy2Ths5KIgTz0pPNmwgh+01 BbXqrMiNF0+YLITtxTW/yk3uYBb1oYdVAA0uk X-Gm-Gg: ASbGncttW1Latnz76u4/PAt+GEdkx635gg+2WdpE512UK1ASYrzb5rthN5om9SnFz8J auHAg0IH3Y223DWYoZ8+/2UOlQOlvYUy5C24RdqcO+WLKfOo78iwkyVPK5l2h/Cm5W5KRmIYuid bhhdPGrswRlapmZgZ4aiErBcDS0Tj3F+9d++B7rIJu48HSvl/XJbqksfYbrTqj8VhP7RzlruLQp Do8 X-Google-Smtp-Source: AGHT+IEKUN9Mki4yL7Y6tCivFTRuAWnFhDv8TR6n89NJTEhsuS83bECWX/wjrdhecdiahUGGKW6WPpa2vPUtV5PdQPM= X-Received: by 2002:a17:907:97d5:b0:ad2:2146:3b89 with SMTP id a640c23a62f3a-adfad60acb7mr739813666b.47.1750079819004; Mon, 16 Jun 2025 06:16:59 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Gambhir Singh Date: Mon, 16 Jun 2025 18:46:47 +0530 X-Gm-Features: AX0GCFtzKUwR85jQl81N_YMMWYgUK-iMNAW4zTliSq7IYxRxmgAwFpXP2KjUt2k Message-ID: Subject: Re: alter the datatype of Partition Key To: Pgsql-admin Content-Type: multipart/alternative; boundary="000000000000f0bf6d0637b035cf" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000f0bf6d0637b035cf Content-Type: text/plain; charset="UTF-8" Please help me on this Thanks & Regards Gambhir Singh On Mon, 16 Jun 2025 at 12:45, Gambhir Singh wrote: > Hi, > > We have a partition table with partitioning type range and got the > requirement from the application team to alter the datatype of partitioning > key from bigint to varchar. Please suggest to me the way how this can be > achieved. > > Data volume is quite huge in the table. ~50 Billion rows > > -- > Thanks & Regards > Gambhir Singh > > --000000000000f0bf6d0637b035cf Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Please help me on this

Thanks & Regards
Gambhir Singh



On Mon, 16 Jun 2025= at 12:45, Gambhir Singh <g= ambhir.singh05@gmail.com> wrote:
Hi,

We have a partition table with parti= tioning type range and got the requirement from the application team to alt= er the datatype of partitioning key from bigint to varchar. Please suggest = to me the way how this can be achieved.
Data volume is quite huge in the table. ~= 50 Billion rows

--
Thanks &= Regards
Gambhir Singh

--000000000000f0bf6d0637b035cf--