Greetings! Please try to either a) partitioning you update into smaller chunks/commits or b) use a CTAS instead (although I am not a big fan of this). Good luck
Andreas On Sat, 2024-03-16 at 22:11 -0700, Alexander Kainz wrote: > Hi, > > I wanted to mention this issue that took me a while to identify. > > Here's the output from my test code (https://github.com/akainz/h2db) > > Table created successfully.12 KB > Rows inserted successfully. File 986 MB actual data 983 MB > Rows updated successfully. 9 GB > > the code sets up a table, then inserts 100K rows and the does an > UPDATE sample_table SET COUNT = 0 > and the db file just 10x's in size. > > That seems to be excessive and forced me to stop updating all rows, > maybe you want to look into it. > > Alex > -- > 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 view this discussion on the web visit > https://groups.google.com/d/msgid/h2-database/91a34196-107b-4fc7-860b-0cc9c3ce523dn%40googlegroups.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 view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/519379422a74235fd7b5d92897fe55c14cee59ce.camel%40manticore-projects.com.
