During restore of a database (from a full backup), the general practice is to rebuild the indexes. I think with pg_dump and pg_restore (or psql restore), the only option is to rebuild the indexes. Am I right or is it possible to backup indexes as well and restore them ?
Just exploring, to figure if time to rebuild a fully functional database (with indexes) can be lower one way or the other.
Thank you,
AJ