postgres table have a large number of relpages and occupied a big memory size

[Vivekkumar Pandey <vivekkumar.pandey@xxxxxxxxxxxxxxx>]

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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general