Re: Creating indexes in the background

On Sun, Oct 28, 2012 at 8:22 AM, David Lee <davidomundo(at)gmail(dot)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