> [snip]
>
> > Have you tried reindexing your active tables?
>
> Not yet, the db is in production use and I have to plan for a down-time
> for that... or is it not impacting the activity on the table ?
>
It will cause some performance hit while you are doing it. It sounds like
something is bloating rapidly on your system and the indexes is one possible
place that could be happening.