## Igor Korot ([email protected]): > [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.
It's available as a TABLE storage parameter, but you put it on the index definition (where it's not valid) - this could be a conceptual mistake or a misplaced right parenthesis. See the example on your linked page: https://www.postgresql.org/docs/16/sql-createtable.html#SQL-CREATETABLE-STORAGE-PARAMETERS:~:text=fill%20factor%20for%20both%20the%20table%20and%20its%20unique%20index Regards, Christoph -- Spare Space
