Re-enable autovacuum and fix sequence naming post swap

[shiwangini93]

pgosc disables autovacuum for the new table it creates - (probably because we want to go with faster inserts ),so we need to re-enable autovacuum manually for the new fresh table.

Also, it gives some weird name to sequence and primary key which we also need to rename back/correct. In my case , there was a dependent function on that table sequence ,so that stopped working :)

[shayonj]

Hi @shiwangini93 - We actually, do we restore storage params (autovaccum) and any other settings on a table here:

pg-osc/lib/pg_online_schema_change/orchestrate.rb

Line 246 in f47f7aa

#{storage_params_reset}

Could you share an example perhaps? Also note that, pg-osc isn't compatible with partitioned tables yet (#68), so in case this is related to #68, its normal in this case to not see the vaccum settings transferred.

Regarding the sequence naming, collapsing that into: #20

Closing the issue for now, but please feel free to re-open in case you see any issues with autovaccum settings being not restored. Thanks