Re: Renaming 800GB size table in postgresql

Поиск
Список
Период
Сортировка
От Mladen Gogala
Тема Re: Renaming 800GB size table in postgresql
Дата
Msg-id 0d9bf8bf-d33d-f821-29a3-a890802731f2@gmail.com
обсуждение исходный текст
Ответ на Re: Renaming 800GB size table in postgresql  (Vijaykumar Jain <vijaykumarjain.github@gmail.com>)
Список 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




В списке pgsql-admin по дате отправления:

Предыдущее
От: John Scalia
Дата:
Сообщение: Re: Understanding was terminated by signal 9: Killed
Следующее
От: Henry Francisco Garcia Cortez
Дата:
Сообщение: Re: bgwriter_flush_after