Re: Heavily modified big table bloat even in auto vacuum is running - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: Heavily modified big table bloat even in auto vacuum is running
Date
Msg-id 1381533049.83343.YahooMailNeo@web162906.mail.bf1.yahoo.com
Whole thread Raw
In response to Heavily modified big table bloat even in auto vacuum is running  (Haribabu kommi <haribabu.kommi@huawei.com>)
List pgsql-hackers
Haribabu kommi <haribabu.kommi@huawei.com> wrote:

> To handle the above case instead of directly resetting the dead
> tuples as zero, how if the exact dead tuples are removed from the
> table stats. With this approach vacuum gets triggered frequently
> thus it reduces the bloat.
> Patch for the same is attached in the mail.

Please add this to the open CommitFest to ensure that it gets
reviewed:

https://commitfest.postgresql.org/action/commitfest_view/open

For more information about the process, see:

http://wiki.postgresql.org/wiki/CommitFest

You may also want to reveiw:

http://wiki.postgresql.org/wiki/Developer_FAQ

-- 
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: Auto-tuning work_mem and maintenance_work_mem
Next
From: "MauMau"
Date:
Subject: Re: Auto-tuning work_mem and maintenance_work_mem