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 there.
: 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
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
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
