Now I've run 5 times the drop/data import process copying data from a smaller Postgres local DB (the first import produces a h2 db of less than 800mb). All the import were executed within the same JVM instance. These are the size measurements taken after every import (with the Tomcat JVM still running):So in this scenario the db size trend seems almost linear:
<https://docs.google.com/spreadsheet/ccc?key=0Am3ZF0bmUOy8dDlCSndfSU9kYW9fYTlhM3piWmhfSkE&usp=sharing> <https://docs.google.com/spreadsheet/oimg?key=0Am3ZF0bmUOy8dDlCSndfSU9kYW9fYTlhM3piWmhfSkE&oid=1&zx=1zy4n4en3jp0> Then I shut down Tomcat, and the db size slightly decreased to 2888MB.Then I ran the recovery tool on the db.These are the relevant statistics:Then I exported the DB to a sql script and used RunScript to reimport it into a new one, which size in turn decreased to 471MB. Then I relaunched recovery tool that produced the following stats:It seems that the rows number of the huge db is nearly 5 times the shrunk one. OTOH on a raw check (comparing the number of rows for the bigger tables) it seems that the shrunk db contains the same data. Would it be compatible with a scenario of pending transactions/sessions? Thomas Mueller-6 wrote > Hi,How large is the database exactly, and how does it grow exactly? Are > youcompletely sure it doesn't stop growing? If yes, could you kill the > processwhile the database is about 10 times as big as it should be, and > then runthe recovery tool, and post the statistics part of the the output? > Andthen, could you shrink the file (for example by export to SQL script > /import from SQL script), run recovery again, and post the statistics > ofthis new file?Regards,ThomasOn Tue, Aug 13, 2013 at 6:27 PM, > davide.cavestro< > davide.cavestro@ > >wrote:> I didn't measure it, but it was certainly lower. I'll give you > more data> asap.>>> Noel Grandin wrote> > On Tue, Aug 13, 2013 at 5:56 PM, > davide.cavestro> > <>> > davide.cavestro@>> > > wrote:> >> I've > tried replacing setCharacterStream() with setString() but the db> >> size> > >> still continues to increase. Is there any way to get an idea of actual> > >> fragmentation of internal data-structures?> >>> >> > Sorry, no, no > idea.> > But I thought we were chasing a bug where shutdown was taking > too> > long, in which case making this change should make a difference.> > > Did you measure your new shutdown time with this change?> >> > --> > 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>> > h2-database+unsubscribe@>> > .> > > To post to this group, send email to>> > h2-database@>> > .> > Visit this > group at http://groups.google.com/group/h2-database.> > For more options, > visit https://groups.google.com/groups/opt_out.>>>>>> --> View this > message in context:> > http://h2-database.66688.n3.nabble.com/h2-Continuous-Increase-in-H2-db-size-after-dropping-and-loading-same-data-repeatedly-tp4026836p4027132.html> > Sent from the H2 Database mailing list archive at Nabble.com.>> --> 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 > h2-database+unsubscribe@ > .> To post to this group, send email to > h2-database@ > .> Visit this group at http://groups.google.com/group/h2-database.> For > more options, visit https://groups.google.com/groups/opt_out.>>>-- 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 > h2-database+unsubscribe@ > .To post to this group, send email to > h2-database@ > .Visit this group at http://groups.google.com/group/h2-database.For more > options, visit https://groups.google.com/groups/opt_out. -- View this message in context: http://h2-database.66688.n3.nabble.com/h2-Continuous-Increase-in-H2-db-size-after-dropping-and-loading-same-data-repeatedly-tp4026836p4027140.html Sent from the H2 Database mailing list archive at Nabble.com. -- 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 http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
