On 18 October 2016 at 21:41, Joshua D. Drake <j...@commandprompt.com> wrote:
> Are we > trading initial performance gains for performance degradation through > maintenance? Eh? That's backwards, so No. The whole point of this is it avoids long term degradation currently caused by non-HOT updates. Normal UPDATEs that don't change PKs won't generate any changes to VACUUM away, so only actions that remove PK values will cause anything to be collected and removed from indexes. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
