On Wed, 2006-06-14 at 11:52, Sriram Dandapani wrote: > Hi > > > > I have a table into which data flows at a high rate say 2 million rows > per hour. Every 15 minutes, these rows are processed and deleted. > > At any point in time, the row count for the table hovers around 500K > (due to the deletes). > > > > I have set max_fsm_pages to about 2000000. I still see the > pg_total_relation_size constantly reporting an increasing size. > > > > How do I know if autovacuum is reclaiming space or is my max_fsm > setting plain wrong. (I understand that autovacuum marks tuples for > reuse, but shouldn’t pg_total_relation_size take that into account) I wouldn't really rely on just autovacuum to do this. But, if you must, adjust the threshholds to have it trigger more easily. Me personally, if I'm running a script that deletes 500,000 rows, I put a vacuum at the end of it. That way you KNOW the vacuum got run.
