Feature Request: multithreaded reindexdb --concurrently of a single table - Mailing list pgsql-admin

From Ron Johnson
Subject Feature Request: multithreaded reindexdb --concurrently of a single table
Date
Msg-id CANzqJaCWmJDMvfZR2Zsi=dzjNmRYJoyM_CMLN9L58GEU9YSvYQ@mail.gmail.com
Whole thread Raw
Responses Re: Feature Request: multithreaded reindexdb --concurrently of a single table
List pgsql-admin
PG 14.15

This command executes the single command "REINDEX TABLE foo;" and the reindexfb doc page says that --jobs is incompatible with --index.

$ reindexdb -d dba -v --concurrently -j4 -t foo
INFO:  index "public.foo_pkey" was reindexed
INFO:  index "public.i_foo_2" was reindexed
INFO:  index "public.i_foo_3" was reindexed
INFO:  index "public.i_foo_23" was reindexed
INFO:  table "public.foo" was reindexed
DETAIL:  CPU: user: 26.90 s, system: 7.47 s, elapsed: 59.37 s.

It would be really really handy to be able to run multiple REINDEX INDEX jobs at the same time, either by just specifying the table as above and reindexdb automagically getting the index names, or by manually enumerating each index, and then see all four REINDEX INDEX statements in pg_stat_activity.

$ reindexdb -d dba -v --concurrently -j4 -i foo_pkey -i i_foo_2 -i i_foo_3 -i i_foo_23

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

pgsql-admin by date:

Previous
From: kaido vaikla
Date:
Subject: Replica and transaction
Next
From: Kouber Saparev
Date:
Subject: Re: CREATE SUBSCRIPTION hangs indefinitely