On Nov 5, 2007 8:04 PM, Gokulakannan Somasundaram <[EMAIL PROTECTED]> wrote:
> > > There may not be anything called chain-pruning. Instead the tuples, which > are to be vacuumed, will get vacuumed, after redirecting their index tuple > peers, during the Vacuum process. > > This won't help us check the heap bloat. Though containing index bloat is important, most of the performance benefits of HOT comes from doing page level retail vacuuming. This not only reduces the heap bloat but also results in less frequent vacuuming of the table. Thanks, Pavan -- Pavan Deolasee EnterpriseDB http://www.enterprisedb.com
