Re: Database size, and table size

["Roger Strandberg / Hamsta" <roger.strandberg@xxxxxxxxx>]

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 -----

From: hubert depesz lubaczewski

To: Roger Strandberg / Hamsta

Cc: pgsql-admin@xxxxxxxxxxxxxx

Sent: Saturday, October 22, 2005 8:05 AM

Subject: Re: Database size, and table size

On 10/22/05, Roger Strandberg / Hamsta <roger.strandberg@xxxxxxxxx> wrote:

I wondering about file size of a table.

dont wonder :) install dbsize module from postgresql contrib, and check.

depesz