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

Hi,
slon process is running on the system .

Now , I have a question that Why dead tupples are remains in the table
while AUTOVACUUM process running at the fixed interval of time without
any error.
Also suggest the Query that can view the dead tuples in the table.

Thanks for instant reply.......
On Fri, Aug 5, 2011 at 1:22 PM, Jaime Casanova <jaime(at)2ndquadrant(dot)com> wrote:
> On Fri, Aug 5, 2011 at 2:37 AM, Vivekkumar Pandey
> <vivekkumar(dot)pandey(at)globallogic(dot)com> wrote:
>>
>> Hi Tomas,
>>
>>    I am using the slony cluster and both the database have the same Data.
>>
>> So Please provide the appropriate solution....
>>
>> On Fri, Aug 5, 2011 at 12:47 PM, Tomas Vondra <tv(at)fuzzy(dot)cz> wrote:
>> >
>> > 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).
>> >
>
> It seems like Tomas gives you the solution (at least part of it): use
> VACUUM FULL to compact your data on the master.
> Also, probably you want to revisiti your autovacuum's configuration.
>
> Finally, remember that Slony has two tables that logs all changes in
> the database... normally only one of the table should be in use while
> Slony is processing the queu of the other and truncate it. but if the
> slon process are not running those tables start to grow... can you
> check that the slon processes are running
>
> --
> Jaime Casanova         www.2ndQuadrant.com
> Professional PostgreSQL: Soporte 24x7 y capacitación
>

--
Thanks

VIVEK KUMAR PANDEY