id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
34843	Feature request: Support postgres table storage options	Anton Shutik	nobody	"There is a list of storage options (https://www.postgresql.org/docs/current/sql-createtable.html#SQL-CREATETABLE-STORAGE-PARAMETERS) that can be applied when creating a table in postgres database. So, since django manages database schema, it would be nice to extend it to support these storage options.

It might look like:

{{{
class MyModel(models.Model):
  
    #  fields go here
  
    class Meta:
      storage_options = {
          ""autovacuum_vacuum_scale_factor"": 0.01,
          ""autovacuum_vacuum_threshold"": 1000
      }

}}}

and that would produce migration which eventually will run sql like this:

`CREATE TABLE mymodel WITH (autovacuum_vacuum_scale_factor = 0.01, autovacuum_vacuum_threshold = 1000);`


For now it could be done with `RunSQL(sql='ALTER TABLE .... WITH (...);')` migration, but it would be better to have the settings on the model class itself for better visibility and managed by django.

What do you think ?"	New feature	new	Migrations	3.2	Normal		postgres, autovacuum, storage options, django migrations		Unreviewed	0	0	0	0	0	0