Subject: Re: Index bloat of 4x
From: Csaba Nagy <nagy@ecircle-ag.com>
To: Greg Sabino Mullane <greg@turnstep.com>
Cc: Postgres general mailing list <pgsql-general@postgresql.org>,
	bruce@momjian.us
In-Reply-To: <19dcd19103d2e8b6656dac44879e2fcb@biglumber.com>
References: <19dcd19103d2e8b6656dac44879e2fcb@biglumber.com>
Content-Type: text/plain
Message-Id: <1169052495.22307.283.camel@coppola.muc.ecircle.de>
Mime-Version: 1.0
Date: Wed, 17 Jan 2007 17:48:15 +0100
Content-Transfer-Encoding: 7bit

[snip]
> Come to think of it, an auto-reindex option might be nice in core someday.
> TODO item?

Marry it with autovacuum + online index build, and it will be cool ;-)

BTW, having a privileged background thread doing the reindex could be a
solution to most of the objections regarding online reindex, as the
thread would be privileged enough already to be able to back out if
something fails (part of the objections), and it could stay around long
enough to only lock tentatively in a loop in order to avoid deadlocks
(another part of the objections).

If it would be also marked the same as the vacuum threads not to block
other vacuums, then it would also not be a problem that it runs 2
days...

Cheers,
Csaba.