Re: vacuum vs vacuum full

Поиск
Список
Период
Сортировка
От Paul Förster
Тема Re: vacuum vs vacuum full
Дата
Msg-id CB3E8A7A-9481-4D81-9D93-9BA1B9100B05@gmail.com
обсуждение исходный текст
Ответ на Re: vacuum vs vacuum full  (Laurenz Albe <laurenz.albe@cybertec.at>)
Ответы Re: vacuum vs vacuum full  (Ravi Krishna <srkrishna@yahoo.com>)
Список pgsql-general
Hi Laurenz,

> On 18. Nov, 2020, at 13:02, Laurenz Albe <laurenz.albe@cybertec.at> wrote:
>
> I personally hope that we will never have global indexes.
> I am not looking forward to helping customers with the problems that
> they create (long duration of ATTACH/DETACH PARTITION, index fragmentation).

+1.

Experience shows that global index in Oracle lead to problems when dropping a partition. rebuilding an index, or other
suchnice administrative stuff, often leading to unnecessarily long downtimes. 

Cheers,
Paul


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

Предыдущее
От: Eric Svenson
Дата:
Сообщение: Problem with compiling extensions with Postgres Version 13
Следующее
От: Ravi Krishna
Дата:
Сообщение: Re: vacuum vs vacuum full