[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 по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: [GENERAL] Moving from 9.5 to 9.6
Следующее
От: PAWAN SHARMA
Дата:
Сообщение: [GENERAL] factor effecting performance of postgres