table partitioning

[gust_vn]

I researched table partitioning of MySQL and PostgreSQL. That's very
good. Does H2 have any plan to implement table parttioning in new
features ?

[Thomas Mueller]

Hi,

No, currently there are no plans to implement this feature. I will add
it to the roadmap however.

Regards,
Thomas

[ko]

Hi,

I'm gona use h2 in my product. but database size is huge.
So table partitioning is very important!!! (for my product)
I hope that this feature will be implemented.

On 5月10日, 午後5:36, Thomas Mueller <thomas.tom.muel...@gmail.com> wrote:
> Hi,
>
> No, currently there are no plans to implement this feature. I will add
> it to the roadmap however.
>
> Regards,
> Thomas
>

[Thomas Mueller]

Hi,

> I'm gona use h2 in my product. but database size is huge.
> So table partitioning is very important!!! (for my product)
> I hope that this feature will be implemented.

I will add a feature request, but so far this feature does have low
priority for me (I'm sorry). That will change if other people also
request it of course. There are a few workarounds: one is to partition
tables 'manually' in the application, and use linked tables so that
each table partition is stored in a different database.

Regards,
Thomas

[Dario V. Fassi]

Thomas Mueller escribió:

Hi Thomas,
increment your counter by one (me).

I have some apps that can't port to H2 because lack of partitioning.
Tipical case are simple models with few dependent tables and one or few
_very_ large tables.
Use cases like reporting from automation captured data, PBX data or
telco like accounting where you have a good natural partitioning key
(ex. account no.)
and the same key drive almost any data navigation case.
For this type of applications partitioning really help.

Regards,
Dario.

[ko]

Hi Thomas,

I have some questions.

1)
to partition tables 'manually' (use linked tables) may consume system
resource much more?
(specially memory resource : by jdbc)

my product have 1000 over partition (h2 database) ...

2)
to partition tables 'manually' can choose best SQL execution plan by
optimizer?
(like Oracle 7 'partition view'. I went through hardships once)

3)
to partition tables 'manually' is hard of maintain the database...
(like Oracle 7 'partition view'. I went through hardships once)

regards,
ko

On May 20, 3:12 am, Thomas Mueller <thomas.tom.muel...@gmail.com>
wrote:

[Maarten Bosteels]

+1 for partitioning support in h2.

regards,
Maarten

[kefa]

+1 for table partitioning.

I'm the same case as Dario: few VERY large tables (data acquisition in
electrical power industry).

[Thomas Mueller]

Hi,

H2 supports splitting the database file in multiple smaller files
using the split: file name prefix:

jdbc:h2:split:test

The default is to split into 1 GB files. Would that solve the problem
(at least partially)?

Regards,
Thomas

[ko]

Hi,

Thank you for your suggestion.
but I think this function is not table partitioning function.

I want to use table partitioning. (like Composite Range-List
Partitioning)
( the partition can backup/recover/drop/add/... )

regards,
ko

On 5月28日, 午前3:41, Thomas Mueller <thomas.tom.muel...@gmail.com> wrote:
> Hi,
>
> H2 supports splitting the database file in multiple smaller files
> using the split: file name prefix:
>
> jdbc:h2:split:test
>
> The default is to split into 1 GB files. Would that solve the problem
> (at least partially)?
>
> Regards,
> Thomas
>

[Thomas Mueller]

Hi,

> Thank you for your suggestion.
> but I think this function is not table partitioning function.

As far as I understand, don't have enough space on one device, right?
Or is it a different problem? If the problem is just space, then I
guess splitting the file should solve it.

> I want to use table partitioning. (like Composite Range-List
> Partitioning)

Why?

> ( the partition can backup/recover/drop/add/... )

With the split feature, you could do that as well as far as I understand.

Regards,
Thomas

[bob mcgee]

+1 more interested in partitioning OR clustering OR bitmap indices
(any of these could solve my performance issues).
On Jun 1, 4:03 am, Thomas Mueller <thomas.tom.muel...@gmail.com>
wrote:

> Hi,
>
> > Thank you for your suggestion.
> > but I think this function is not tablepartitioningfunction.
>
> As far as I understand, don't have enough space on one device, right?
> Or is it a different problem? If the problem is just space, then I
> guess splitting the file should solve it.
>

> > I want to use tablepartitioning. (like Composite Range-List

[Toni Isidoro]

+1 for partitioning support

[Naveen Kumar]

One more vote for Partition support in H2.

[wener]

Currently I do the same thing, I use h2 as a SQL Parser and the undolog, but I still not clear enough. Now I trying to implement a MySQL protocol for H2(or any JDBC Datasource),because in the product, the mysql protocol is better, kind like a replacement for mysql.

在 2009年5月6日星期三 UTC+8下午12:33:43，gust_vn写道：

[iJava]

Hi Thomas

7 years have passed. Can you say if partitioning is supported or when it will be supported?

Best regards, Pavel

воскресенье, 10 мая 2009 г., 12:36:52 UTC+4 пользователь Thomas Mueller Graf написал:

[Noel Grandin]

I doubt that partioning is likely to rise to the top of our priority list anytime soon.

We have many more pressing issues.

​

[Anatolii K]

+1 vote for partitioning

I hope partitioning will improve insert/update scalability. In current implementation I see huge contention on table's MVMap