Re: Adding storage parameters on index

Hi All,

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.

1. 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).
   

1. There is a storage parameter named buffering which 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.
   

1. There is a parameter vacuum_cleanup_index_scale_factor that was added on PostgreSQL 11 but was removed on PostgreSQL 13, should we add this too?

Thanks

Pravesh Sharma

--

	Pravesh Sharma Software Engineer +91 9406461406 www.enterprisedb.com Power to Postgres