turicas/rows

pgimport enhancements

开放

#353 创建于 2020年7月19日

 (0 条评论) (0 个反应) (0 位负责人)Python (136 个派生)github user discovery
enhancementhelp wantedplugin

仓库指标

星标
 (886 个星标)
PR 合并指标
 (30 天内没有已合并 PR)

描述

  • It's very useful to run VACUUM ANALYZE tablename; just after importing data, so we could have an option on pgimport to do it (function and CLI).
  • The performance of pgimport could 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).

贡献者指南