Re: [GENERAL] What's eating my space ?

2011-05-20 Thread Albe Laurenz
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 .

[GENERAL] What's eating my space ?

2011-05-19 Thread Georgi Ivanov
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

Re: [GENERAL] What's eating my space ?

2011-05-19 Thread Andreas Kretschmer
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,

Re: [GENERAL] What's eating my space ?

2011-05-19 Thread Eric McKeeth
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