Having clients running on read-only mode, when possible, can help.
Also partitioning the database can help, but then it's too much trouble already.