On Sun, Mar 8, 2026 at 7:41 PM Igor Korot <[email protected]> wrote:
> David, > > On Sun, Mar 8, 2026 at 6:37 PM David G. Johnston > <[email protected]> wrote: > > > > On Sunday, March 8, 2026, Igor Korot <[email protected]> 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. -- Death to <Redacted>, and butter sauce. Don't boil me, I'm still alive. <Redacted> lobster!
