On Tue, Apr 12, 2016 at 3:21 AM, Magnus Hagander <magnus@hagander.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.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company