Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.

Dismiss

Ingres DB Dimension

0 views

Skip to first unread message

unread,

Jul 19, 2000, 3:00:00 AM7/19/00

to ingres newsgroup, Giovanni Franzese

Hi,

Try this query, it gives you the size off the database in MB (OpenIngres only)

For Ingres 6.4 the pagesize is 2048 bytes.

select sum(float8(number_pages) * (table_pagesize/1024)) / 1024

from iitables;

\p\g

Regards,

Raoul A. Joemman

Nibble Consultancy b.v.
Oude Amersfoortseweg 22
1213 AD Hilversum

0 new messages