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

Reply via email to