[GENERAL] What happens when a large table is alterted from UNLOGGED to LOGGED

Поиск
Список
Период
Сортировка
От Rakesh Kumar
Тема [GENERAL] What happens when a large table is alterted from UNLOGGED to LOGGED
Дата
Msg-id DM2PR05MB622E8AE2C3186BB6F8CA6618C7E0@DM2PR05MB622.namprd05.prod.outlook.com
обсуждение исходный текст
Список pgsql-general
In order to speed up loading a set of 12 tables, I have declared them as UNLOGGED.  As per documentation, an unlogged
tablewill also have unlogged indices.   

Question: When the table is converted back to logged, does PG rebuild all indices before marking them as logged.  Also
whatabout FKY constraints. Does it revalidate them ? 

thanks.


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