From: Tom Lane <tgl@sss.pgh.pa.us>
To: Douglas Reed <dougreed765@yahoo.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Cc: Douglas Reed <douglas@fsbtech.com>
Subject: Re: Problem with Altering a table column
Date: Thu, 19 Dec 2019 08:48:43 -0500
Message-ID: <7122.1576763323@sss.pgh.pa.us> (raw)
In-Reply-To: <825474461.1387396.1576738664403@mail.yahoo.com>
References: <825474461.1387396.1576738664403.ref@mail.yahoo.com>
<825474461.1387396.1576738664403@mail.yahoo.com>
Douglas Reed <dougreed765@yahoo.com> writes:
> I have issued and alter column against the following;
> price_id | integer | not null default nextval('bet.price_price_id_seq'::regclass) | plain | |
> ALTER TABLE bet.price ALTER COLUMN price_id TYPE bigint;
> The process has taken a very long time, I know that it is rebuilding the table and a lot of temp files have been created, deleted etc
> It now seems to have gone quiet (no temp disk files etc), it still seems to be clicking up CPU
> - Is there a final part of the process where it may just be doing validation etc?
Foreign key revalidation maybe ... does this column participate in any
foreign keys?
> - Is it safe to terminate the process?
Yeah, but you'd lose all the work done so far.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, dougreed765@yahoo.com, douglas@fsbtech.com
Subject: Re: Problem with Altering a table column
In-Reply-To: <7122.1576763323@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox