Re: vacuum vs vacuum full - Mailing list pgsql-general

From Paul Förster
Subject Re: vacuum vs vacuum full
Date
Msg-id CB3E8A7A-9481-4D81-9D93-9BA1B9100B05@gmail.com
Whole thread Raw
In response to Re: vacuum vs vacuum full  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: vacuum vs vacuum full
List 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 by date:

Previous
From: Eric Svenson
Date:
Subject: Problem with compiling extensions with Postgres Version 13
Next
From: Ravi Krishna
Date:
Subject: Re: vacuum vs vacuum full