Re: Renaming 800GB size table in postgresql

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

 




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






[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