Feature Request: multithreaded reindexdb --concurrently of a single table

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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!

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux