Re: Renaming 800GB size table in postgresql

From: Mladen Gogala <gogala(dot)mladen(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Renaming 800GB size table in postgresql
Date: 2021-10-20 00:04:02
Message-ID: 0d9bf8bf-d33d-f821-29a3-a890802731f2@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


On 10/19/21 13:17, Vijaykumar Jain wrote:
> so, if I read it correctly, the renaming operation is independent of
> the size of the table (as it is just updating the system catalog
> somewhere).

Rename table is done in the data dictionary, where the table is defined.
You don't even touch the table during the process.

Regards

--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Henry Francisco Garcia Cortez 2021-10-20 15:42:20 Re: bgwriter_flush_after
Previous Message John Scalia 2021-10-19 23:12:04 Re: Understanding was terminated by signal 9: Killed