回复：[pgsql-zh-general] 不做vacuum是否会影响pg的性能

From: 萧少聪(铁庵) <shaocong(dot)xsc(at)alibaba-inc(dot)com>
To: "pgsql-zh-general(at)postgresql(dot)org" <pgsql-zh-general(at)postgresql(dot)org>, "pgsql-zh-general-owner" <pgsql-zh-general-owner(at)postgresql(dot)org>
Subject: 回复：[pgsql-zh-general] 不做vacuum是否会影响pg的性能
Date: 2016-03-16 09:03:20
Message-ID: 15c062bd-125f-445a-afb1-cb83464498fb.shaocong.xsc@alibaba-inc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-zh-general

会的，特别是如果有大量的UPDATE或DELETE。你的表会越来越大，性能会逐步下降！建议最少定期进行人工的vacuum，另外9.x以后我并不建议关闭autovacuum

------------------------------萧少聪(铁庵) Scott SiuMobile: +86 18600036141AliCloud RDS for PostgreSQL/PPAS PD 产品专家

Responses

Browse pgsql-zh-general by date

  From Date Subject
Next Message 张文升 2016-03-16 10:00:05 Re: 回复：[pgsql-zh-general] 不做vacuum是否会影响pg的性能
Previous Message Ming 2016-03-16 08:57:20 不做vacuum是否会影响pg的性能