From: | Csaba Nagy <nagy(at)ecircle-ag(dot)com> |
---|---|
To: | Greg Sabino Mullane <greg(at)turnstep(dot)com> |
Cc: | Postgres general mailing list <pgsql-general(at)postgresql(dot)org>, bruce(at)momjian(dot)us |
Subject: | Re: Index bloat of 4x |
Date: | 2007-01-17 16:48:15 |
Message-ID: | 1169052495.22307.283.camel@coppola.muc.ecircle.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
[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.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-01-17 16:48:37 | Re: SELECT INTO TEMPORARY problem |
Previous Message | Richard Huxton | 2007-01-17 16:47:07 | Re: SELECT INTO TEMPORARY problem |