In order to speed up loading a set of 12 tables, I have declared them as UNLOGGED. As per documentation, an unlogged table will also have unlogged indices.
Question: When the table is converted back to logged, does PG rebuild all indices before marking them as logged. Also what about FKY constraints. Does it revalidate them ?
thanks.