From: | "Roger Strandberg / Hamsta" <roger(dot)strandberg(at)hamsta(dot)se> |
---|---|
To: | "hubert depesz lubaczewski" <depesz(at)gmail(dot)com> |
Cc: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Database size, and table size |
Date: | 2005-10-22 18:01:11 |
Message-ID: | 00e201c5d732$964d4470$03997483@rogercud6b5ksq |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)postgresql(dot)org
Sent: Saturday, October 22, 2005 8:05 AM
Subject: Re: [ADMIN] Database size, and table size
On 10/22/05, Roger Strandberg / Hamsta <roger(dot)strandberg(at)hamsta(dot)se> wrote:
I wondering about file size of a table.
dont wonder :) install dbsize module from postgresql contrib, and check.
depesz
From | Date | Subject | |
---|---|---|---|
Next Message | Kishore B | 2005-10-22 21:15:25 | Need help in setting optimal configuration for a huge database. |
Previous Message | hubert depesz lubaczewski | 2005-10-22 06:05:04 | Re: Database size, and table size |