Postgres Pro
Downloads
Home   >   mailing lists

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

From Robert Haas
Subject Re: 答复: [HACKERS] Re: [HACKERS] 答复: [HACKERS] postgres 1 个(共 2 个) can pg 9.6 vacuum freeze skip page on index?
Date
Msg-id CA+TgmoYxdhOvG_0chTLeXUjs3VDGkOmsAmeFH9XF5Gd6vJCmhg@mail.gmail.com
Whole thread Raw
In response to 答复: [HACKERS] Re: [HACKERS] 答复: [HACKERS] postgres 1 个(共 2 个) can pg 9.6 vacuum freeze skip page on index?  (xu jian <jamesxu@outlook.com>)
List pgsql-hackers
Tree view 
On Thu, Dec 1, 2016 at 9:54 PM, xu jian <jamesxu@outlook.com> wrote:
> Thanks every for your help. I am not familiar with the internal of the
> vacuum freeze, just curious if there is no row change on the table(in other
> words, all pages are frozen), why could index page have dead tuple?

It can't.   If the *entire* table is frozen, then I would think it
shouldn't be scanning the indexes.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Logical Replication WIP
Next
From: Robert Haas
Date:
Subject: Re: Write Ahead Logging for Hash Indexes