Re: Creating indexes in the background - Mailing list pgsql-hackers

From Daniel Farina
Subject Re: Creating indexes in the background
Date
Msg-id CAAZKuFYP58fK8jBtARftgFW5P7N75+qrnrYQr6v7e5A-Z9LFOQ@mail.gmail.com
Whole thread Raw
In response to Re: Creating indexes in the background  (David Lee <davidomundo@gmail.com>)
List 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 by date:

Previous
From: Robert Haas
Date:
Subject: Re: [COMMITTERS] pgsql: Fix erroneous choices of segNo variables
Next
From: Noah Misch
Date:
Subject: Re: [PATCH] Support for Array ELEMENT Foreign Keys