Re: Top features in 9.6?

On Wed, Apr 13, 2016 at 7:13 AM, Darren Duncan <darren(at)darrenduncan(dot)net> wrote:
> On 2016-04-12 10:54 AM, Robert Haas wrote:
>>
>> On Tue, Apr 12, 2016 at 8:59 AM, Justin Clift <justin(at)postgresql(dot)org>
>> wrote:
>>>
>>> On 12 Apr 2016, at 13:37, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
>>>>
>>>> On Tue, Apr 12, 2016 at 3:21 AM, Magnus Hagander <magnus(at)hagander(dot)net>
>>>> wrote:
>>>>>
>>>>> I think that may turn out to be one of those "hidden gems" of this
>>>>> release.
>>>>> As in being the one that nobody talks about now, but then a few years
>>>>> down
>>>>> the road it's the one that everybody talks about. But it's somewhat
>>>>> hard to
>>>>> explain to people who (1) don't know how the system really works
>>>>> (though
>>>>> that would count for things like snapshot too old as well) or (2)
>>>>> actually
>>>>> have run into the current problem (why hey, that's also the same with
>>>>> snapshot too old)
>>>>
>>>>
>>>> Agreed. Unfortunately, for many people, the first time they really
>>>> become aware of autovacuum is when all of their tables hit the freeze
>>>> threshold for the first time. And this doesn't help with that. You
>>>> still have to scan everything after 200 million transactions; it's
>>>> just that you no longer have to do it again every 200 million
>>>> transactions after that. I still think it's a great feature, though.
>>>
>>>
>>> Er... we don't provide a warning ahead of time in the logs or something?
>>
>>
>> No. That would be a little strange, honestly. I have to assume that
>> many wraparound vacuums go totally unnoticed; how would you
>> distinguish the ones that are likely to annoy somebody from the other
>> ones?
>
>
> I suggest providing a config option for those warnings, if there isn't one
> already. Global plus override per table etc. The option says we only log
> the warnings if the wraparound vacuum is likely to take more than a certain
> amount of time, and pick something reasonable for that default time. Or to
> generalize, have a config saying what to do if a wraparound vacuum is coming
> up soon, including what amount of estimated time may be considered
> inconvenient. -- Darren Duncan

postgres users no longer care about anti-wraparound vacuum at 9.6 and
postgres already emits WARNING log at 10 million transaction
remaining.

Regards,

--
Masahiko Sawada