autovacuum and dead tuples - Mailing list pgsql-performance

From
Subject autovacuum and dead tuples
Date
Msg-id 20130918084242.5a830134ae84016b0174832fdc1a3173.28709778ba.wbe@email11.secureserver.net
Whole thread Raw
Responses Re: autovacuum and dead tuples  (Shaun Thomas <sthomas@optionshouse.com>)
List pgsql-performance
<span style="font-family:Verdana; color:#000000; font-size:10pt;"><div>We are running PostgreSQL 9.1.6 with autovacuum
=on and I am reporting on dead tuples using the pgstattuple extension. Each time I run the pgstattuple package our dead
tuplescounts decrease. My colleague is under the impression that dead tuples are only cleaned up via vacuum full only,
whileI suggested that the autovaccum process was cleaning up these dead tuples. Is this true?</div><div><br
mce_bogus="1"/></div><div>Thanks</div><div><br /></div><div><br /></div></span> 

pgsql-performance by date:

Previous
From: Александр Белинский
Date:
Subject: Re: function execute on v.9.2 slow down
Next
From: Shaun Thomas
Date:
Subject: Re: autovacuum and dead tuples