pgimport enhancements #353
Description
- It's very useful to run
VACUUM ANALYZE tablename;just after importing data, so we could have an option onpgimportto do it (function and CLI). - The performance of
pgimportcould be better if vacuum for the imported table is disabled before import (ALTER TABLE tablename SET (autovacuum_enabled = off);) and then (after import) re-enabled. This could be the default behaviour but may be an option to disable it (could be useful in cases where we're importing data into an existing table).