pg 8.1.4 has a very ugly bug which prevents VACUUM and AUTOVACUUM from
performing well....
I certain situations the AUTOVACUUM will start failing and any VACUUM
operations will fail too.
solution I found was to periodically REINDEX my tables and INDEXES.
the major effect of this bug is Pg starts continuously taking up
filesystem space for nothing.... pg looses track of disk space that is
no longer needed and simply requests more and more;
another side effect is that, in that situation, query execution time
grows continuously too.... until client applications simply tiemout.
This issue is documented and has been fixed starting Pg 8.1.6.
JOao
On Fri, 2009-04-24 at 12:01 -0500, Josh Trutwin wrote:
> I've been asked to put together a list of reasons to upgrade a db
> from 8.1 to 8.3 and I've looked over the changelog, but they want a
> bullet list of 4-5 top things. I'm curious what others would say the
> most 5 important updates from 8.1 to 8.3 are.
>
> I can say "performance improvevents" but I'm not sure how to sell
> that better other than listing what's in the release notes. I also
> think the autovac was greatly improved in these releases as well? Or
> maybe I'm thinking 8.0 to 8.1?
>
> Sorry this is so vague, I'm frustrated with this request as I figured
> just the amount of bug-fixes alone would be adequate reasoning.
>
> Thanks,
>
> Josh
>