Am trying to create an index concurrently on production. However when doing so the index when viewing via \d
says INVALID
.
Why is this the case? Never seen it happen before.
Have tried re-creating but still get the same issue:
Index:
create index concurrently idx_wallet_customer_id_credit_stake_expires on wallet (customer_id,wallet_credit_stake,wallet_expires)
where wallet_closed is null and wallet_staked is null;