What happens when a large table is alterted from UNLOGGED to LOGGED
Started by Rakesh Kumarabout 9 years ago1 messagesgeneral
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.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general