Hi, we are using H2 in version 1.3.176 from quite some time without any probleam. Recently without any apparent change file .db has started to grow quite a lot with no apparent reason. Note that this happens even with the the flow of transactions (i.e. INSERT/UPDATE/DELETE) is stopped. So we have come to the conclusion that the space is needed for SELECT management. We have some quite heavy views but these do not return that many rows (~13000). A couple of tables involved in the views have ~1000 columns
When the DB is not stressed with queries the db file is less than 50MB but when some queries are run on the views the db file grows with a pace of ~80/150MB at each query until it finishes the file system capacity (which is about 18,5GB). Some notes: we are using this version because there is a requirement to use Java 6 the OS is red hat linux the Recovery tool gives as statistics the following (at 3.2 GB) ---- Statistics ---- --* page count: 1631834, free: 1585744* * ****** -- page data bytes: head 854070, empty 35048525, rows 24994685 (43% full) -- free 76%, 1256019 page(s) -- data leaf 1%, 29735 page(s) -- data node 0%, 188 page(s) -- data overflow 0%, 241 page(s) -- btree leaf 0%, 3100 page(s) -- btree node 0%, 62 page(s) -- free list 0%, 120 page(s) -- stream trunk 0%, 673 page(s) -- stream data 20%, 341719 page(s) ******* Why does the size increases even if it has got so many free pages? Any workaround (also ugly is OK!)? Shutdown defragment would work but it does shutdown all the connections which creates problems to the clients... Many thanks Anna -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
