On Wed, Jan 15, 2014 at 05:37:27PM -0800, Lists wrote:
> it's clearing out the cruft that results from creating temp tables,
> loading a bunch of data, then dropping the table, either explicitly
> or when the connection is terminated. This causes PG disk usage to
> climb without causing any change in pg_dump output.
Oh. You need to up your autovacuum settings for the system catalog
tables. I built a system that did this sort of thing. If your
autovacuum settings are correct, this will stabilize.
A
--
Andrew Sullivan
ajs(at)crankycanuck(dot)ca