Glyn Astill <glynastill@xxxxxxxxxxx> writes: > So it appears now that if I restore the database using pg_restore, I end up with bloated indexes, which are fixed with a vacuum full. > The dump is a data only dump with the -Fc flag, Data only dump? Then what is the state of the database you're restoring it into? regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin