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 dead tuple will cause a complete scan of
>>> every index. I've compla
On Thu, Dec 1, 2016 at 9:54 PM, xu jian 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* t
: xu jian; Masahiko Sawada; pgsql-hackers@postgresql.org
主题: Re: [HACKERS] Re: [HACKERS] 答复: [HACKERS] postgres 1 个(共 2 个) can pg 9.6
vacuum freeze skip page on index?
On Thu, Dec 1, 2016 at 1:39 PM, Tom Lane wrote:
> Robert Haas writes:
>> I think that the indexes only need to be scann
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 this before and I think there's
>> room for imp
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 this before and I think there's
> room for improvement here, but nobody's been motivated enough to
>
On Thu, Dec 1, 2016 at 9:45 AM, xu jian 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
1日 9:06:15
收件人: xu jian
抄送: pgsql-hackers@postgresql.org
主题: Re: [HACKERS] postgres 1 个(共 2 个) can pg 9.6 vacuum freeze skip page on
index?
On Thu, Dec 1, 2016 at 1:33 AM, xu jian wrote:
> Hello,
>
>Please execute me if I am using the wrong mailing list, but I ask the
> quest
On Thu, Dec 1, 2016 at 1:33 AM, xu jian wrote:
> Hello,
>
>Please execute me if I am using the wrong mailing list, but I ask the
> question in pgsql-admin, looks like no one know the answer.
>
>
> we upgraded our pg db to 9.6, as we know, pg9.6 doesn't need full table scan
> in vacuum free
Hello,
Please execute me if I am using the wrong mailing list, but I ask the
question in pgsql-admin, looks like no one know the answer.
we upgraded our pg db to 9.6, as we know, pg9.6 doesn't need full table scan in
vacuum freeze.
http://rhaas.blogspot.com/2016/03/no-more-full-table-v