Re: Database size, and table size - Mailing list pgsql-admin

From Roger Strandberg / Hamsta
Subject Re: Database size, and table size
Date
Msg-id 00e201c5d732$964d4470$03997483@rogercud6b5ksq
Whole thread Raw
In response to Database size, and table size  ("Roger Strandberg / Hamsta" <roger.strandberg@hamsta.se>)
List 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 -----
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

pgsql-admin by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: Database size, and table size
Next
From: Kirby Ubben
Date:
Subject: Pgpool errors: pgpool 2.6.4 postgres 7.3.10 ProcessFrontendResponse: failed to read kind from frontend. fronend abnormally exited