On Thu, Feb 23, 2017 at 5:15 PM, Masahiko Sawada <sawada.m...@gmail.com> wrote: > On Wed, Feb 22, 2017 at 12:01 AM, Amit Kapila <amit.kapil...@gmail.com> 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 (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
