[HACKERS] how to shrink pg_attribute table?

Hello, My application creates temp table frequently. Now I find pg_attribute table is growing larger and larger, 90GB now. pgstattuple shows 82% free space, so I restored the db to dev env, and tried vacuum full to shrink it. However, the vacuum full run for 24 hours, and hang

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

月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] 答复: [HACKERS] postgres 1 个(共 2 个) can pg 9.6 vacuum freeze skip page on index?

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] postgres 1 个(共 2 个) can pg 9.6 vacuum freeze skip page on index?

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.