Postgres Pro
Downloads
Home   >   mailing lists

Re: Renaming 800GB size table in postgresql - Mailing list pgsql-admin

From Mladen Gogala
Subject Re: Renaming 800GB size table in postgresql
Date
Msg-id 0d9bf8bf-d33d-f821-29a3-a890802731f2@gmail.com
Whole thread Raw
In response to Re: Renaming 800GB size table in postgresql  (Vijaykumar Jain <vijaykumarjain.github@gmail.com>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: John Scalia
Date:
Subject: Re: Understanding was terminated by signal 9: Killed
Next
From: Henry Francisco Garcia Cortez
Date:
Subject: Re: bgwriter_flush_after