Re: Creating indexes in the background

Поиск
Список
Период
Сортировка
От Daniel Farina
Тема Re: Creating indexes in the background
Дата
Msg-id CAAZKuFYP58fK8jBtARftgFW5P7N75+qrnrYQr6v7e5A-Z9LFOQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Creating indexes in the background  (David Lee <davidomundo@gmail.com>)
Список pgsql-hackers
On Sun, Oct 28, 2012 at 8:22 AM, David Lee <davidomundo@gmail.com> wrote:
> Thanks. Is this something viable as a feature request?

Just to contribute a tiny amount of data: I also get this request from
users on a semi-regular basis. It's definitely below the pains of
pg_dump/restore or fork-and-reuse-of-connections of libpq in the space
of caveats that come to mind, but it's worth noting that regular
people do notice this is a gap (disconnected session support)
reasonably frequently.  However, the workaround is fairly clear and
network connections are pretty reliable, and that blunts its severity.

it's also useful for other use cases besides CREATE INDEX, like
incremental data rewrites.  I think there's some indirect overlap here
with the daemon facility under discussion that is active in another
thread.

--
fdr



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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: [COMMITTERS] pgsql: Fix erroneous choices of segNo variables
Следующее
От: Noah Misch
Дата:
Сообщение: Re: [PATCH] Support for Array ELEMENT Foreign Keys