Re: reindexing db

Поиск
Список
Период
Сортировка
От Paul Förster
Тема Re: reindexing db
Дата
Msg-id 214E5DBC-1F6F-49C1-8B83-9A2EB33E969A@gmail.com
обсуждение исходный текст
Ответ на Re: reindexing db  (Ron <ronljohnsonjr@gmail.com>)
Ответы Re: reindexing db
Re: reindexing db
Список pgsql-admin
Hi Ron,

> On 08. Dec, 2020, at 06:42, Ron <ronljohnsonjr@gmail.com> wrote:
>
> Changing subjects, but the thought of reindexing every index, whether it needs it or not, in one command, seems like
acrime against database administration. 

hmm, yes, I agree to *some* point. But also think about possible changes in glibc and the collation problems corrupting
indexesthat come with it. So, you do a reindexdb deliberately to protect yourself against index corruption because
PostgreSQLcan't know by itself that it needs such protection because it doesn't know of any changes in glibc. 

So, it's not a crime against database administration but rather a means of defense for a database administrator against
anexternal crime attacking the database. 

Cheers,
Paul


В списке pgsql-admin по дате отправления:

Предыдущее
От: Ron
Дата:
Сообщение: Re: reindexing db
Следующее
От: Ron
Дата:
Сообщение: Re: reindexing db