I have a database which is bloated because of vacuum full, so you find indexes bigger than the table itself.
I have dumped this database and restored it without reindixing and it was extremely slow. So, my question what is the relation between bloated database and pg_restore.