[Feature] Allowing autovacuum_enabled to be set during table creation

[joshuataylor]

Is this your first time submitting a feature request?

• I have read the expectations for open source contributors
• I have searched the existing issues, and I could not find an existing issue for this feature
• I am requesting a straightforward extension of existing dbt-postgres functionality, rather than a Big Idea better suited to a discussion

Describe the feature

With Postgres, you can use the following to create a table without autovacuum:

CREATE TABLE public.new_table (
    id serial primary key
) WITH (autovacuum_enabled = false);

You can also do it using alter table, for example with a post hook.

Why?

Certain tables don't need autovacuum turned on, and use system resources. Yes, autovacuum is set to low priority, but you still don't want this, sometimes.

For example, tables which are always re-created during a run (staging tables, etc) and can't be incremental, for whatever reason.

We're seeing very long times for vacuums for larger tables we recreate every run.

Describe alternatives you've considered

Post hooks.

Who will this benefit?

Users needing to set autovacuum.

Are you interested in contributing this feature?

yes

Anything else?

I would ideally like this to be generic, so the user can instead select other options when creating a table https://www.postgresql.org/docs/current/sql-createtable.html.