Okay i did so, result:
html_slave=# select pg_size_pretty(relation_size('quick_search'));
pg_size_pretty
----------------
490 MB
(1 row)
html_slave=# select pg_size_pretty(relation_size('html_company'));
pg_size_pretty
----------------
1567 MB
(1 row)
html_slave=# select pg_size_pretty(database_size('html_slave'));
pg_size_pretty
----------------
4120 MB
(1 row)
Okay the quic_search_table is aroun 490, but then i need to ask why does the machine reboot when i only make use of 510MB of the 2.8G mfs disk. .....
I need to mail freebsd then.
/R
----- Original Message -----
Sent: Saturday, October 22, 2005 8:05 AM
Subject: Re: [ADMIN] Database size, and table size
On 10/22/05, Roger Strandberg / Hamsta <roger.strandberg@hamsta.se> wrote: I wondering about file size of a table.
dont wonder :) install dbsize module from postgresql contrib, and check.
depesz