Thorsten Schöning schrieb am 31.12.2020 um 21:13:
Is there some way to REMOVE the fillfactor where it is set, so that
Postgres applies it's defaults? Would be great to have an output of
NULL everywhere where fillfactor is output instead of sometimes e.g.
100 and more often NULL.
I've already tried setting things to NULL, which failed with
mentioning that a decimal number is necessary. Though, even setting 0
fails, because a value between 10 and 100 is required.
ALTER INDEX pk_clt_rec_src SET (fillfactor = NULL);
ALTER INDEX pk_clt_rec_src SET (fillfactor = 0);
ALTER INDEX pk_clt_rec_src RESET (fillfactor);
should do it.
