I am working on feature#6374 which is adding storage parameters while creating an index. I have made changes in the definition tab of create index to have all the required parameters. Attached is the new design, please review it.
I also have a few points which require suggestions.
Storage parameters are different for different access methods. If an access method does not support a parameter we can either disable it or hide it (I am thinking of hiding it based on the access method).
Disable the controls.
There is a storage parameter namedbufferingwhich is by default auto and takes on/off value. What type of control should I use for it? Should it be a switch or a drop down with three options on, off and auto, if we have a switch user won't be able to move to auto.
It should be a drop-down with all three options.
There is a parameter vacuum_cleanup_index_scale_factorthat was added on PostgreSQL 11 but was removed on PostgreSQL 13, should we add this too?