Re: postgres out of disk space


Matthew Sykes <matthew.sykes@...>
 

Just a thought: How large is your events table? Is it getting pruned at the
correct interval for you?

I believe events, app usage events, and audit events are pruned when
they're more than 31 days old default. You could change the cc properties
in the deployment manifest to make that a little more aggressive if that's
the problem.

On Fri, Sep 25, 2015 at 7:22 AM, Matthias Ender <Matthias.Ender(a)sas.com>
wrote:

I have a cf-aws-tiny cf-boshrelease deployment, and it’s been running well
for over 4 months.

We have about 40 apps, with a couple of dozen of cf pushes each day.

Yesterday pushing apps became spotty and then impossible, with various
errors.

Turned out the 100GB disk for the postgres instance on the data note was
full.

I increased the disk size and things a running again.

But – what happened there? 100G and growing seems like awfully large
database for a rather modest use.

And I’m worried it’ll just happen again in a few months.



thanks,

Matthias




--
Matthew Sykes
matthew.sykes(a)gmail.com

Join cf-dev@lists.cloudfoundry.org to automatically receive all group messages.