On Sun, Mar 8, 2026 at 6:10 PM Igor Korot <[email protected]> wrote:
> Hi, ALL, > > [quote] > draft=# CREATE TABLE leagues_new(id serial, name varchar(100), > drafttype smallint, scoringtype smallint, roundvalues smallint, > leaguetype char(5), salary integer, benchplayers smallint, primary > key(id) INCLUDE (drafttype, scoringtype) WITH( fillfactor = 50, > autovacuum_enabled )); > ERROR: unrecognized parameter "autovacuum_enabled" > [/quote] > > But the page at > > https://www.postgresql.org/docs/16/sql-createtable.html#SQL-CREATETABLE-STORAGE-PARAMETERS > says it's available. > > What am I missing? > Probably "= on", since this does work: ALTER TABLE foo SET (autovacuum_enabled = off); ALTER TABLE foo SET (autovacuum_enabled = on); This raises the question "why are you explicitly enabling autovacuum_enabled in the CREATE TABLE statement?", since autovavuum should be globally enabled. -- Death to <Redacted>, and butter sauce. Don't boil me, I'm still alive. <Redacted> lobster!
