A customer that uses tryton has a fairly large database that suffers performance issues.
Three tables in particular (stock_move, account_move, account_move_line) have grown to reach tens of GBs.
We have tried several methods of optimization, such as profiling queries, adding indexes, removing locks, modifying processes and adding hardware. While these attempts have improved performance, the continous growth of these 3 tables is still a problem, so we are looking for more a more agressive approach.
The options we are working with include database clustering, table partitioning and just deleting old data.
Has anybody faced these problems? If so, how did you overcome then?