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

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: xu jian <jamesxu(at)outlook(dot)com>
Cc: Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [HACKERS] 答复: [HACKERS] postgres 1 个(共 2 个) can pg 9.6 vacuum freeze skip page on index?
Date: 2016-12-01 18:23:21
Message-ID: CA+Tgmobu=sHd=2F+L5UW3pZhVp9Sagf0PfgU7O1TVgev0kM9vw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Dec 1, 2016 at 9:45 AM, xu jian <jamesxu(at)outlook(dot)com> wrote:
> Thanks for your reply. Is there any reason to update index
> statistics even if there is no changes on the table?
> or is there any way to disable index statistics update during vacuum freeze?
> thanks

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 this before and I think there's
room for improvement here, but nobody's been motivated enough to
pursue this yet.

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2016-12-01 18:39:26 Re: Re: [HACKERS] 答复: [HACKERS] postgres 1 个(共 2 个) can pg 9.6 vacuum freeze skip page on index?
Previous Message Robert Haas 2016-12-01 18:21:46 Re: s/xlog/wal/ in tools and function names?