Re: reloption to prevent VACUUM from truncating empty pages at theend of relation - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: reloption to prevent VACUUM from truncating empty pages at theend of relation
Date
Msg-id CAFj8pRBE22MBbaMbP1yqmwNRq4SVBRXhoP1EDaLqG5FsvKM2pw@mail.gmail.com
Whole thread Raw
In response to Re: reloption to prevent VACUUM from truncating empty pages at theend of relation  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-hackers


2018-04-19 21:56 GMT+02:00 Alvaro Herrera <alvherre@alvh.no-ip.org>:
Michael Paquier wrote:

> Then, let's consider the beginning of the first commit fest of v12 as
> judgement.  Implementing radix tree for shared buffers is a long-term
> project, which has no guarantee to get merged, while a visibly-simple
> reloptions which helps in some cases...

In the scenario we studied, the truncations were causing periodic
hiccups which were quite severe.  The truncations were completely
useless anyway because the table grew back to the original size daily (a
few dozen GBs I think).  That was a lot of unnecessary work, and under
exclusive lock no less.

has sense

Pavel

--
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: initdb fails to initialize data directory
Next
From: Andres Freund
Date:
Subject: Re: reloption to prevent VACUUM from truncating empty pages at theend of relation