After plenty of querys the database use 40 times more disk space than the original data, How can I avoid this?

liyuesen 00108910 liyuesen at huawei.com
Thu Jun 6 09:08:09 CEST 2013


Hi guys:
       In my case , original data 8G bytes, but after plenty of query, the disk space usage is 361G bytes. The query is simply, first five UNION ALL, then fetch the result. When the query is running, I use vmstat to watch the IO status. When the database becomes larger, the BI and BO number increase very large too, for example  bo 355224, bi 27392. And the query cost ten times longer than before! 
       After rebooting the database, the database disk space was reduced to its original data size, 8G. It seems too much runtime data was produced. How can I solve the problem or avoid the problem!

Thanks,Jason

******************************************************************************************
 This email and its attachments contain confidential information from HUAWEI, which is intended only for the person or entity whose address is listed above. Any use of the information contained here in any way (including, but not limited to, total or partial disclosure, reproduction, or dissemination) by persons other than the intended recipient(s) is prohibited. If you receive this email in error, please notify the sender by phone or email
 immediately and delete it!
 *****************************************************************************************



More information about the developers-list mailing list