Hi all,
I have a cluster database with a master and slave ,
the size of master database is very high reltive to slave
while both have approximatly same data.
On master
# select pg_size_pretty(pg_database_size('table_name'));
pg_size_pretty
----------------
15 GB
(1 row)
relname | reltuples | MB
--------------------------------------+-------------+------
Table1 | 876 | 4395
Table2 | 1.69135e+06 | 1919
Table3 | 1.69137e+06 | 1298
Table4 | 289 | 1062
Table5 | 2007 | 1031
Table6 | 1.69136e+06 | 1019
Table7 | 1809 | 673
Table8 | 1.69137e+06 | 476
On Slave
# select pg_size_pretty(pg_database_size('table_name'));
pg_size_pretty
----------------
1411 MB
(1 row)
all of the table having same number of tuples on slave while having
very low space relative to master .
Please give the reason and appropriate solution of this problem.................
--
Thanks
VIVEK KUMAR PANDEY