Re: reindexing db
От
Paul Förster
Тема
Re: reindexing db
Дата
Msg-id
A54CA469-6EAA-40AD-AD37-7E877268786A@gmail.com
Ответ на
Re: reindexing db (Ron)
Список
Дерево обсуждения
reindexing db Scott Ribe <scott_ribe@elevated-dev.com>
Re: reindexing db "David G. Johnston" <david.g.johnston@gmail.com>
Re: reindexing db Scott Ribe <scott_ribe@elevated-dev.com>
Re: reindexing db "David G. Johnston" <david.g.johnston@gmail.com>
Re: reindexing db Scott Ribe <scott_ribe@elevated-dev.com>
Re: reindexing db Ron <ronljohnsonjr@gmail.com>
Re: reindexing db Paul Förster <paul.foerster@gmail.com>
Re: reindexing db Ron <ronljohnsonjr@gmail.com>
Re: reindexing db Paul Förster <paul.foerster@gmail.com>
Re: reindexing db Ron <ronljohnsonjr@gmail.com>
Re: reindexing db Paul Förster <paul.foerster@gmail.com>
Re: reindexing db Ron <ronljohnsonjr@gmail.com>
Re: reindexing db Paul Förster <paul.foerster@gmail.com>
Re: reindexing db Ron <ronljohnsonjr@gmail.com>
Re: reindexing db Scott Ribe <scott_ribe@elevated-dev.com>
Re: reindexing db Paul Förster <paul.foerster@gmail.com>
Re: reindexing db Scott Ribe <scott_ribe@elevated-dev.com>
Hi Ron, > On 08. Dec, 2020, at 07:59, Ron wrote: > > Probably a habit from my VAX/VMS days, but I prefer to enumerate every table, not only for tracking but so that if the command fails 90% of the way through, I can skip over the the completed portions. doing this IMHO defeats the purpose of concurrency because you'd have to issue reindex statements sequentially. Also, but I definitely can't say for sure, reindexdb should skip and report indexes which it has a problem with and then continue to do the remaining indexes. But as I said, I may be wrong with this. Cheers, Paul
В списке pgsql-admin по дате отправления