From: | "Tomas Vondra" <tv(at)fuzzy(dot)cz> |
---|---|
To: | "Vivekkumar Pandey" <vivekkumar(dot)pandey(at)globallogic(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: postgres table have a large number of relpages and occupied a big memory size |
Date: | 2011-08-05 07:17:59 |
Message-ID: | d7dc836c05a87ae0173edb8f0824ff82.squirrel@sq.gransy.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 5 Srpen 2011, 9:00, Vivekkumar Pandey wrote:
> 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.
What version of PostgreSQL is this, what kind of cluster, and what do you
mean by "approximately"?
With xlog-based replication (file shipping or streaming replication), the
relations should have exactly the same size, but they should also contain
exactly the same data.
That suggests you're using something else to build the cluster (e.g. slony
or something like that). In that case the size difference may be simply
due to data differences or dead tuples. VACUUM FULL should compact the
dead tuples, but it's not a cheap command (takes exclusive locks, time and
memory).
Tomas
From | Date | Subject | |
---|---|---|---|
Next Message | Vivekkumar Pandey | 2011-08-05 07:37:50 | Re: postgres table have a large number of relpages and occupied a big memory size |
Previous Message | Vivekkumar Pandey | 2011-08-05 07:00:36 | postgres table have a large number of relpages and occupied a big memory size |