Postgres Pro
Downloads
Home   >   mailing lists

[GENERAL] What happens when a large table is alterted from UNLOGGED to LOGGED - Mailing list pgsql-general

From Rakesh Kumar
Subject [GENERAL] What happens when a large table is alterted from UNLOGGED to LOGGED
Date
Msg-id DM2PR05MB622E8AE2C3186BB6F8CA6618C7E0@DM2PR05MB622.namprd05.prod.outlook.com
Whole thread Raw
List pgsql-general
Tree view 
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 by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: [GENERAL] Moving from 9.5 to 9.6
Next
From: PAWAN SHARMA
Date:
Subject: [GENERAL] factor effecting performance of postgres