On Montag, 25. Januar 2010 Kevin Grittner wrote: > Any chance you had or have long-running transactions. We once had > very low free space in a big database which suddenly ballooned. It > turned out an application programmer had left a connection in "idle > in transaction" state for a few days. > > Another possibility is that you had an update or delete which > affected a lot of rows. Even if it rolls back, it can cause bloat. I don't believe that. This machine holds the "dbmail" Mail Database, locks and transactions are very small, just to insert a new mail. The system is very low loaded, so such a bloat can't happen in a day. Finding out which table the toast belongs to would be great, maybe that helps further investigation. -- mit freundlichen Grüssen, Michael Monnerie, Ing. BSc it-management Internet Services http://it-management.at Tel: 0660 / 415 65 31 // Wir haben zwei Häuser zu verkaufen: // http://zmi.at/langegg/ // http://willhaben.at/iad/realestate/object?adId=15923011
Attachment:
signature.asc
Description: This is a digitally signed message part.