Re: Feature Request: multithreaded reindexdb --concurrently of a single table
| От | Ron Johnson |
|---|---|
| Тема | Re: Feature Request: multithreaded reindexdb --concurrently of a single table |
| Дата | |
| Msg-id | CANzqJaDbob-nHc+pAu-mvb+WuXd4Dehe3atwqktq+nUbTG325Q@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Feature Request: multithreaded reindexdb --concurrently of a single table (Álvaro Herrera <alvherre@alvh.no-ip.org>) |
| Список | pgsql-admin |
On Fri, Feb 21, 2025 at 1:46 PM Álvaro Herrera <alvherre@alvh.no-ip.org> wrote:
On 2025-Feb-18, Ron Johnson wrote:
> 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.
I don't think multiple REINDEX commands can run concurrently on the same
table, so this is not a reindexdb issue but a server issue. And TBH I
think the server feature to support that is not likely to be implemented
soon.
That's a shame. Big server, lots of RAM, lots of CPUs, a big table, and lots of indices just begs for concurrently running REINDEX / CREATE INDEX statements on the same table.
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
В списке pgsql-admin по дате отправления: