java - PostgreSQL, Hibernate : Moving contents of db to text file/XML file for storage purposes -

i working on spring-mvc application in seeing database growing big. space consumed chat messages history mostly, , other stuff old notifications, not useful.

because of thought of moving guys text/xml file give db room breath , increase performance of queries thereby. indexes not useful many insertions.

i wanted know if there way, postgresql or hibernate has support such task, data picked out of db , saved in plain files, can accessed , result in atleast performance gains.

i have started looking stuff, don't have in hand show. kindly let me know if there questions guys have.

thanks lot.

i use postgresql json storage , have 2 databases:

• the current operations db, 1 moving data away slim it
• the archive database old data aggregated save storage

this way can move data current database archive database without compromising acid attributes , can aggregate old data simplify retrieval, grouping various related entities based on common root entity, you'll use access old data.

this way current operation database remains small enough, while archive database can shared. way, it's easier configure current operation high performance, while archive 1 scalability.

anyway, hibernate doesn't support out-of-the-box, can implement using custom hibernate types , jta transactions.