Feature Request: multithreaded reindexdb --concurrently of a single table
| От | Ron Johnson |
|---|---|
| Тема | Feature Request: multithreaded reindexdb --concurrently of a single table |
| Дата | |
| Msg-id | CANzqJaCWmJDMvfZR2Zsi=dzjNmRYJoyM_CMLN9L58GEU9YSvYQ@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: Feature Request: multithreaded reindexdb --concurrently of a single table
|
| Список | 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.
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 по дате отправления: