How to REMOVE a fillfactor set by accident?

Поиск
Список
Период
Сортировка
От Thorsten Schöning
Тема How to REMOVE a fillfactor set by accident?
Дата
Msg-id 1908635665.20201231211328@am-soft.de
обсуждение исходный текст
Ответы Re: How to REMOVE a fillfactor set by accident?
Re: How to REMOVE a fillfactor set by accident?
Список pgsql-general
Hi all,

I'm using the GUI tool pgModeler to maintain schemas and at some point
in the past it used fillfactor 10 for some indexes by default. That
seems to have changed in the meantime and most of my indexes don't
have ANY fillfactor set explicitly.

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);

So removing isn't possible at all and I can only set to concrete
values like 100 or don't care at all instead? Because fillfactor=10 is
only set for some low throughput test databases currently.

Thanks!

Mit freundlichen Grüßen,

Thorsten Schöning

--
Thorsten Schöning
AM-SoFT IT-Service - Bitstore Hameln GmbH

E-Mail:  Thorsten.Schoening@AM-SoFT.de
Web:     http://www.AM-SoFT.de/

Telefon: 05151-  9468-55
Fax:     05151-  9468-88
Mobil:    0178-8 9468-04

Firmensitz: Bitstore IT-Consulting, Frankfurter Allee 285, 10317 Berlin
Steuernummer 037/230/30566, HR 27198, Amtsgericht Potsdam Geschäftsführer Janine Galonska




В списке pgsql-general по дате отправления:

Предыдущее
От: Thorsten Schöning
Дата:
Сообщение: Re: Declarative partitioning and automatically generated row-IDs using BIGSERIAL
Следующее
От: Ron
Дата:
Сообщение: Re: How to REMOVE a fillfactor set by accident?