ha
Joshi
To: [EMAIL PROTECTED] ; [EMAIL PROTECTED]
Sent:
Wednesday, June 25, 2003 12:34 PM
Subject:
[SQL] database & table size
Hello ,
Here is something Ive found
related to database & table size
My databse name
is test and table name is cdrrec.
On Wed, 25 Jun 2003, Anagha Joshi wrote:
> 4. the file '2078989' corresponds to 'cdrrec' file (table)
>
> $ ls -l 2078989
> -rw--- 1 postgres postgres 2359296 Jun 24 17:18 2078989
>
> This means table 'cdrrec' takes approx. 2030.2626953125 KB i.e. approx.
> 2MB
>
> Table is like
Title: database & table size
Hello ,
Here is something I’ve found related to database & table size
My databse name is ’test’ and table name is ‘cdrrec’.
1. Following will give oids & database
test=# select datname, oid from pg_database;
datname | oid
-+-
