#2264 Does Cloudberry support `CREATE INDEX` / `REINDEX` / `DROP INDEX CONCURRENTLY`? New discussion created by yanboer 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. apache/cloudberry