Re: Turning off HOT/Cleanup sometimes - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Turning off HOT/Cleanup sometimes
Date
Msg-id CA+U5nM+yUvd-wfqVQQeTRkiqW5HHXPNhHq3zDDDYybkxZNWC7g@mail.gmail.com
Whole thread Raw
In response to Re: Turning off HOT/Cleanup sometimes  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Turning off HOT/Cleanup sometimes
List pgsql-hackers
On 14 April 2015 at 21:53, Robert Haas <robertmhaas@gmail.com> wrote:

> Peter commented previously that README.HOT should get an update.  The
> relevant section seems to be "When can/should we prune or
> defragment?".

That's easy enough to change once we agree to commit.

> I wonder if it would be a useful heuristic to still prune pages if
> those pages are already dirty.

Useful for who? This is about responsibility. Why should someone
performing a large SELECT take the responsibility for cleaning pages?

-- Simon Riggs                   http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, RemoteDBA, Training &
Services



pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: FPW compression leaks information
Next
From: Peter Eisentraut
Date:
Subject: Re: [COMMITTERS] pgsql: Move pg_upgrade from contrib/ to src/bin/