Re: optimizing vacuum truncation scans - Mailing list pgsql-hackers

From Andres Freund
Subject Re: optimizing vacuum truncation scans
Date
Msg-id 20150723150941.GE21169@awork2.anarazel.de
Whole thread Raw
In response to Re: optimizing vacuum truncation scans  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On 2015-07-23 11:06:25 -0400, Robert Haas wrote:
> I don't know what to do about the fact that it loses to the VM-bit
> based approach, but I think it's a bad bet that we will never care
> about setting visibility map bits anyplace other than VACUUM.

+1

A background process that tries to hint all pages shortly before they're
written out would be truly awesome. And would very likely set hint
bits...

Andres



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: optimizing vacuum truncation scans
Next
From: Robert Haas
Date:
Subject: Re: Eliminating CREATE INDEX comparator TID tie-breaker overhead