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+hcT1h=G9ViUAVVg7A-5A_KKqpBaqvm0WCSi+DG=mQsg@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  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
On 19 September 2014 13:04, Robert Haas <robertmhaas@gmail.com> wrote:

> What I'm thinking about is that the smarts to enable pruning is all in
> the executor nodes.  So anything that updates the catalog without
> going through the executor will never be subject to pruning.  That
> includes nearly all catalog-modifying code throughout the backend.

Are you saying this is a problem or a benefit? (and please explain why).

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



pgsql-hackers by date:

Previous
From: Marko Tiikkaja
Date:
Subject: Re: Anonymous code block with parameters
Next
From: Andres Freund
Date:
Subject: Re: Turning off HOT/Cleanup sometimes