Ah, I missed that part of your original post where you said you killed it after 30 mins.
Hmmm, that may not be practical in that case. Are you sure you created indexes when you did this? It seems to be doing tablescans exclusively, which does not make a lot of sense. Possibly pg_dump is not writing them out, or they did not get imported to H2 correctly? -- 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/d/optout.
