Eric McKeeth wrote:
I wander what is taking up my space on disk ...
btv=# SELECT pg_size_pretty(pg_database_size('btv_good'));
pg_size_pretty
10 GB
(1 row)
[SELECT total size of all non-system tables]
The sum of biggest tables is not even close to the total db size .
Hi,
I wander what is taking up my space on disk ...
btv=# SELECT pg_size_pretty(pg_database_size('btv_good'));
pg_size_pretty
10 GB
(1 row)
btv=# SELECT nspname || '.' || relname AS relation,
pg_size_pretty(pg_total_relation_size(C.oid)) AS total_size
FROM pg_class C
Georgi Ivanov georgi.r.iva...@gmail.com wrote:
Hi,
I wander what is taking up my space on disk ...
btv=# SELECT pg_size_pretty(pg_database_size('btv_good'));
pg_size_pretty
10 GB
(1 row)
btv=# SELECT nspname || '.' || relname AS relation,
On Thu, May 19, 2011 at 1:05 AM, Andreas Kretschmer
akretsch...@spamfence.net wrote:
Georgi Ivanov georgi.r.iva...@gmail.com wrote:
Hi,
I wander what is taking up my space on disk ...
btv=# SELECT pg_size_pretty(pg_database_size('btv_good'));
pg_size_pretty
10