Re: REINDEX CONCURRENTLY 2.0

Поиск
Список
Период
Сортировка
От Robert Treat
Тема Re: REINDEX CONCURRENTLY 2.0
Дата
Msg-id CABV9wwMQS6CoS5OrTfZFZJX53jOJNHP35y9MeuBeKF-++LbpYg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: REINDEX CONCURRENTLY 2.0  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Ответы Re: REINDEX CONCURRENTLY 2.0
Список pgsql-hackers
On Fri, Mar 29, 2019 at 3:28 AM Peter Eisentraut
<peter.eisentraut@2ndquadrant.com> wrote:
>
> On 2019-03-28 09:07, Sergei Kornilov wrote:
> > Unfortunately patch does not apply due recent commits. Any chance this can be fixed (and even committed in pg12)?
>
> Committed :)
>

Given this has been committed I've probably missed the window, but
philosophically speaking, is there any reason not to make the
"concurrently" behavior the default behavior, and require a keyword
for the more heavy-weight old behavior? In most production scenarios
you probably want to avoid exclusive locking, and in the cases where
that isn't an issue, 'concurrently' isn't that much slower that most
users would object to it. I would perhaps give a nod to historical
syntax concerns, but this would more closely align with the behavior
in vacuum vs vacuum full, and we've done behavior modifying changes
such as the recent WITH ... MATERIALIZED change. Thoughts?

Robert Treat
https://xzilla.net



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

Предыдущее
От: Daniel Gustafsson
Дата:
Сообщение: Re: PostgreSQL pollutes the file system
Следующее
От: Andres Freund
Дата:
Сообщение: Re: REINDEX CONCURRENTLY 2.0