We have more than 8500 indexes , > 1000 tables, many partition tables too ;
it’s safe to update pg_index set indisready=false and indisvisilbe=false , then
reindexdb with parallel ? reindex parallel got done by multiple sessions ,
each session reindex one index at the same time , reindex the
I believe you should be able to use reindexdb with parallel jobs:
https://www.postgresql.org/docs/13/app-reindexdb.html
It will still create multiple connections, but you won't need to run
multiple commands.
чт, 16 черв. 2022 р. о 22:34 James Pang (chaolpan)
пише:
> Hi ,
>
> We plan to migrate
