Re: reindexing db

Поиск
Список
Период
Сортировка
Искать
От
Paul Förster
Тема
Re: reindexing db
Дата
Msg-id
A54CA469-6EAA-40AD-AD37-7E877268786A@gmail.com
Ответ на
Список
Дерево обсуждения
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 по дате отправления
От: Ron
Дата:
Сообщение: Re: reindexing db
От: Ron
Дата:
Сообщение: Re: reindexing db
FAQ