H2 Database table size

[Vali]

Hello,

Is there a way to compute the size of a table with the H2 engine?
Is yes some SQL example would be great.

Thank you,
Vali

[Mike Goodwin]

Hi Vali,

Presumably you mean the size on disk?

I think the answer will be no. Between different storage mechanisms
and string data being shared there is no easy way to define what size
of a single table is in bytes.

Regards,

mike

> --
>
> You received this message because you are subscribed to the Google Groups "H2 Database" group.
> To post to this group, send email to h2-da...@googlegroups.com.
> To unsubscribe from this group, send email to h2-database...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/h2-database?hl=.
>
>
>

[Vali]

Thank you for the help.

PS: Yes I was talking about the size on disk.

Best Regards,
Vali

On Nov 18, 7:51 pm, Mike Goodwin <mkpgood...@gmail.com> wrote:
> Hi Vali,
>
> Presumably you mean the size on disk?
>
> I think the answer will be no. Between different storage mechanisms
> and string data being shared there is no easy way to define what size
> of a single table is in bytes.
>
> Regards,
>

[Thomas Mueller]

Hi,

There is already a feature request, I will increase the priority:
"Functions to calculate the memory and disk space usage of a table, a
row, or a value."

However I don't know when I have time to implement that - not in the
near future (not this year).

One way that always works is: create a new database and insert the
data you need to know the size of. Then measure the file size.

Regards,
Thomas

[Manohar Amkem]

Hi Thomas,

After many tries still I am trying to find large tables in my H2 db and came to this group. Could you please help me to find the exact query if this is available now for H2 db

Regards,

Manohar 

[Noel Grandin]

http://h2database.com/html/functions.html#disk_space_use
​