alter the datatype of Partition Key

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Pgsql-admin <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>
Subject: alter the datatype of Partition Key
From: Gambhir Singh <gambhir.singh05@xxxxxxxxx>
Date: Mon, 16 Jun 2025 12:45:18 +0530

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

Follow-Ups:
- Re: alter the datatype of Partition Key
  - From: Gambhir Singh
- Re: alter the datatype of Partition Key
  - From: Christophe Courtois

Prev by Date: Re: extensive data use setting in production
Next by Date: Re: alter the datatype of Partition Key
Previous by thread: extensive data use setting in production
Next by thread: Re: alter the datatype of Partition Key
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Home] [Postgresql General] [Postgresql Performance] [Postgresql PHP] [Postgresql Jobs] [PHP Users] [PHP Databases] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Yosemite Forum]

Powered by Linux