Postgres Pro
Downloads
Home   >   mailing lists

Alter the column data type of the large data volume table. - Mailing list pgsql-general

From charles meng
Subject Alter the column data type of the large data volume table.
Date
Msg-id CAD5cqMJT9Q=U3EkpgjsL5QcHNXfwvHVHe+RBabZBXh4OW9n8AA@mail.gmail.com
Whole thread Raw
Responses Re: Alter the column data type of the large data volume table.  (Michael Lewis <mlewis@entrata.com>)
List pgsql-general
Tree view
Hi all,

I have a table with 1.6 billion records. The data type of the primary key column is incorrectly used as integer. I need to replace the type of the column with bigint. Is there any ideas for this?

Solutions that have been tried:
Adding temporary columns was too time-consuming, so I gave up.
Using a temporary table, there is no good way to migrate the original table data to the temporary table

Thanks in advance.

pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: pg_dump of partitioned table not working.
Next
From: Michael Krüger
Date:
Subject: Postgres C-API: How to get the Oid for a custom type defined in a schema outside of the current search path