Re: degenerate performance on one server of 3 - Mailing list pgsql-performance

From Tom Lane
Subject Re: degenerate performance on one server of 3
Date
Msg-id 16593.1243865172@sss.pgh.pa.us
Whole thread Raw
In response to Re: degenerate performance on one server of 3  (Erik Aronesty <erik@q32.com>)
Responses Re: degenerate performance on one server of 3
List pgsql-performance
Erik Aronesty <erik@q32.com> writes:
> but why wasn't autovac enough to reclaim at least *most* of the space?

Autovac isn't meant to reclaim major amounts of bloat; it's more in the
line of trying to prevent it from happening in the first place.  To
reclaim bloat it would have to execute VACUUM FULL, or some other
operation that requires exclusive table lock, which doesn't seem like
a good idea for an automatic background operation.

            regards, tom lane

pgsql-performance by date:

Previous
From: Greg Smith
Date:
Subject: Re: Postgresql cache (memory) performance + how to warm up the cache
Next
From: Greg Smith
Date:
Subject: Re: Vacuuming technique doubt