Although...having said that...page ids are ints...so there does seem to be a maximum amount of data , which is Integer.MAX_INT * pagesize. By default, that is 4 398 046 509 056, or roughly 4 Terabytes.
Harish, how big is your db file once H2 stops responding? On Wednesday, 4 April 2012 17:23:52 UTC+2, Steve McLeod wrote: > > I don't think increasing the page size is the answer. I've been running a > test with the default page size, inserting batches of 1,000,000 rows at a > time, and it has surpassed Integer.MAX_INT. > > I'll change my test now to use INSERT INTO AS SELECT to see if that > surpasses Integer.MAX_INT > > > > On Wednesday, 4 April 2012 16:47:10 UTC+2, Noel Grandin wrote: >> >> >> Cranking up the page size will probably extend the number of rows you >> can store in a table. >> The default is 2K, I would crank it up to 16K. >> >> -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/xmY1F3B2bVMJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
