On Thu, Feb 23, 2017 at 5:15 PM, Masahiko Sawada <[email protected]> wrote: > On Wed, Feb 22, 2017 at 12:01 AM, Amit Kapila <[email protected]> wrote: > >> I understand that there could be some delay in reclaiming dead pages >> but do you think it is such a big deal that we completely scan the >> index for such cases or even try to change the metapage format? > > IIUC, I think that we need to have the number of half-dead pages in meta page. >
Don't you think we need to consider backward compatibility if we want to do that? > Isn't it a problem that the freespace map of btree index is not > vacuumed if all vacuums skip the second pass? > AFAIU, you want to skip only when there is no dead tuple removal, if so what is the need to update freespace map of btree index? -- With Regards, Amit Kapila. EnterpriseDB: http://www.enterprisedb.com -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
