http://h2database.com/html/grammar.html#create_alias
On 2013-10-10 10:13, BeginnerH2 wrote:
there is a hard way to create or add this function on H2 database?
--
You received this message because you are subscribed to the Google Groups H2
Database group.
To unsubscribe from this group and
Hi,
Thanks a lot for the great test case! I think I found the problem, but
couldn't fix it yet. It is a concurrency problem. By default, the MVStore
now stores changes in a background thread. This background writing thread
conflicts with the main thread. Concurrency problems are always hard to
UNACCENT appears to be a PostgreSQL specific function, which we do not
support.
However, if you are trying to do some kind of full-text search, we
support Lucene:
http://h2database.com/html/tutorial.html#fulltext
On 2013-10-10 12:07, BeginnerH2 wrote:
thank you for your answer
but I'm
Hi!
We have a Postgres DB, which we use for processing some data (few millions
rows). We thought about moving some part of the processing to H2 (because
that internal state is not critical, we are happy to store it in H2).
I've started playing around and my first difficulty is about
Thanks, Noel. The changes make sense - and several (now that I have seen
http://www.h2database.com/html/build.html#providing_patches) I should have
done myself and will with any future patches.
On Wednesday, October 9, 2013 11:56:14 PM UTC-7, Noel Grandin wrote:
Thanks John.
I have
Yes, doing a copy with PAGE_SIZE of 2k reduced the average query time even
a bit more, to under 100ms. So this is mostly about the order of the data
on disk.
On Wednesday, October 9, 2013 10:48:14 PM UTC-7, Noel Grandin wrote:
It's quite likely that a dump and restore improved the locality
I'm glad to be able to help you stabilize MVStore! writeDelay(-1) fixed
the IllegalStateException (and slow memory leak), but even with the
h2-latest.jar I still have the original BufferOverflowException, plus a new
NPE that I had not seen yet (both stack's below):
I found that I'm getting