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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general