| From: | <fburgess(at)radiantblue(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | autovacuum and dead tuples |
| Date: | 2013-09-18 15:42:42 |
| Message-ID: | 20130918084242.5a830134ae84016b0174832fdc1a3173.28709778ba.wbe@email11.secureserver.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
<html><body><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 tuples counts decrease. My colleague is under the impression that dead tuples are only cleaned up via vacuum full only, while I 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></body></html>
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/html | 572 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shaun Thomas | 2013-09-18 16:27:35 | Re: autovacuum and dead tuples |
| Previous Message | Александр Белинский | 2013-09-18 11:24:11 | Re: function execute on v.9.2 slow down |