[HACKERS] Re: [HACKERS] Re: [HACKERS] 答复: [HACKERS] postgres 1 个(共 2 个) can pg 9.6 vacuum freeze skip page on index?

2016-12-05 Thread Masahiko Sawada
On Fri, Dec 2, 2016 at 3:50 AM, Robert Haas wrote: > On Thu, Dec 1, 2016 at 1:39 PM, Tom Lane wrote: >> Robert Haas writes: >>> I think that the indexes only need to be scanned if the VACUUM finds >>> dead tuples. But even 1

[HACKERS] Re: [HACKERS] Re: [HACKERS] 答复: [HACKERS] postgres 1 个(共 2 个) can pg 9.6 vacuum freeze skip page on index?

2016-12-01 Thread Robert Haas
On Thu, Dec 1, 2016 at 1:39 PM, Tom Lane wrote: > Robert Haas writes: >> I think that the indexes only need to be scanned if the VACUUM finds >> dead tuples. But even 1 dead tuple will cause a complete scan of >> every index. I've complained about