New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Tables should include a collection of Indexes for management and scripting purposes #13

Open

nvarscar opened this issue Feb 20, 2023 · 0 comments

Labels

enhancement SQL

Collaborator

nvarscar commented Feb 20, 2023

Review the following to implement:
https://www.postgresql.org/docs/current/sql-createindex.html
https://www.postgresql.org/docs/current/sql-alterindex.html

Some of the features it should be implementing:

cluster.tables['foo'].reindex(concurrently=True)
idxs: IndexCollection = cluster.tables['foo'].indexes
idx: Index = idxs['pk_foobar']
idx.reindex(concurrently=True)
idx.drop()
idx.fillfactor
idx.null_order
idx.null_distinct
idx.collation
idx.tablespace
idx.filter: Composable

nvarscar added enhancement SQL labels

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment