GitHub user yanboer created a discussion: Does Cloudberry support `CREATE INDEX` / `REINDEX` / `DROP INDEX CONCURRENTLY`?
Hi, I checked the documentation for the following statements: - `CREATE INDEX`: https://cloudberry.apache.org/docs/sql-stmts/create-index - `DROP INDEX`: https://cloudberry.apache.org/docs/sql-stmts/drop-index - `REINDEX`: https://cloudberry.apache.org/docs/sql-stmts/reindex According to the docs, only `DROP INDEX` mentions support for `CONCURRENTLY`. However, in Apache Cloudberry 2.0.0-incubating, all three statements appear to accept the `CONCURRENTLY` syntax: ``` gpadmin=# select version(); version ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- PostgreSQL 14.4 (Apache Cloudberry 2.0.0-incubating build 1) on x86_64-pc-linux-gnu, compiled by gcc (GCC) 11.5.0 20240719 (Red Hat 11.5.0-11), 64-bit compiled on Dec 2 2025 19:35:44 (with assert checking) (1 row) gpadmin=# create index CONCURRENTLY on test(name); CREATE INDEX gpadmin=# reindex index CONCURRENTLY "test_name_idx"; REINDEX gpadmin=# drop index CONCURRENTLY "test_name_idx"; DROP INDEX gpadmin=# ``` Could you please clarify: 1. Are `CREATE INDEX CONCURRENTLY` and `REINDEX ... CONCURRENTLY` officially supported in 2.0.0? 2. If so, are the documentation pages out of date and should they be updated? 3. Are there any known limitations or caveats for these commands, for example with AO/CO tables, partitioned tables, Partial indexes (`WHERE` predicate), or invalid indexes left behind after a failed concurrent build? Thanks. GitHub link: https://github.com/apache/cloudberry/discussions/2264 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
