On Sun, Mar 8, 2026 at 6:37 PM David G. Johnston <david.g.johnston@gmail.com> wrote: > > On Sunday, March 8, 2026, Igor Korot <ikorot01@gmail.com> wrote: >> >> >> >> >> >> 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? > > > Those are table storage parameters. > >> >> primary >> key(id) INCLUDE (drafttype, scoringtype) WITH( fillfactor = 50, >> autovacuum_enabled = on )); >> ERROR: unrecognized parameter "autovacuum_enabled" >> draft=# > > > You are specifying index storage parameters here. > > The first paragraph of your linked section says: > > “Storage parameters for indexes are documented in CREATE INDEX.” > > You will find autovacuum_enabled is not listed there. Because you can’t vacuum an index separately from its table.
So I will have to compare the CREATE INDEX page with this one and figure out which one is supported where?
Well, yes. Why should you be shocked that some storage parameters just aren't relevant to indices.
