Hi Amit, >I think one table with a varying amount of data is sufficient for the vacuum >test. >I think with more number of tables there is a greater chance of variation. >We have previously used multiple tables in one of the tests because of the >Truncate operation (which uses DropRelFileNodesAllBuffers that takes multiple >relations as input) >and that is not true for Vacuum operation which I suppose you are testing here.
Thanks for your advice and kindly explanation. I'll continue the threshold test with one single table. Regards, Tang