[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-02 Thread Robert Haas
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

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

2016-12-01 Thread xu jian
月1日 13:50:49 收件人: Tom Lane 抄送: 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 <t...@sss.pgh.pa.us> wrote: > Robert Haas <rob

[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

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

2016-12-01 Thread Tom Lane
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

[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 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

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

2016-12-01 Thread xu jian
a.m...@gmail.com> 发送时间: 2016年12月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 <jame...@outlook.com> wrote: > Hello, > >Please execute me if

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

2016-12-01 Thread Masahiko Sawada
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

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

2016-11-30 Thread xu jian
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.