Re: Heavily modified big table bloat even in auto vacuum is running

On Thu, Dec 12, 2013 at 12:24 PM, Haribabu kommi
<haribabu(dot)kommi(at)huawei(dot)com> wrote:
> On 06 December 2013 11:57 Amit Kapila wrote:
>
> A simplified test and updated patch by taking care the above comment are attached in the mail.
> I am not able to reduce the test duration but changed as the test automatically exists after 45 mins run.
> Please check vacuum_test.sh file more details for running the test.
>
> Auto vacuum count Bloat size
> Master 15 220MB
> Patched_nkeep 18 213MB

I ran the attached test and the numbers are as below:
Auto vacuum count Bloat size
Master 16 222MB
Patched_nkeep 23 216MB

Here by Bloat size, it means the table_size after the test finished and
by Auto vacuum count, it means number of times Auto Vacuum is
triggered during test run.

It clearly shows that by setting number of dead tuples at end of Vacuum improves
the situation.
I am marking this (based on patch vacuum_fix_v7_nkeep.patch) as Ready
For Committer.

With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com