Re: Reducing relation locking overhead

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Reducing relation locking overhead
Дата
Msg-id 29250.1133507677@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Reducing relation locking overhead  (Greg Stark <gsstark@mit.edu>)
Ответы Re: Reducing relation locking overhead  (Simon Riggs <simon@2ndquadrant.com>)
Concurrent CREATE INDEX, try 2 (was Re: Reducing relation locking overhead)  (Hannu Krosing <hannu@skype.net>)
Список pgsql-hackers
Greg Stark <gsstark@mit.edu> writes:
> It was a *major* new feature that many people were waiting for when Oracle
> finally implemented live CREATE INDEX and REINDEX. The ability to run create
> an index without blocking any operations on a table, even updates, was
> absolutely critical for 24x7 operation.

Well, we're still not in *that* ballpark and I haven't seen any serious
proposals to make us so.  How "absolutely critical" is it really?
Is REINDEX-in-parallel-with-reads-but-not-writes, which is what we
actually have at the moment, an "absolutely critical" facility?
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Fork-based version of pgbench
Следующее
От: Michael Glaesemann
Дата:
Сообщение: Buildfarm: Bear, Branch 2?