4 ms·
Anyone who's worked with Postgres at scale would guess autovacuum. Postgres doesn't have many weaknesses, but most of them relate to autovacuum.
by nl 10y ago
Anyone who's worked with Postgres at scale would guess autovacuum.
Postgres doesn't have many weaknesses, but most of them relate to autovacuum.
- nickpsecurity 10y ago"Anyone who's worked with Postgres at scale would guess autovacuum." Well, there's knowing it's autovacuum-related then there's the specific way it's causing a failure. First part was obvious. The rest took work. "Postgres doesn't have many weaknesses, but most of them relate to autovacuum." Sounds like that statement should be on a bug submission or something. They probably need to replace that with something better.
- anarazel 10y agoIt's known to the postgres developers, and we are working on it. This specific issue (anti-wraparound vacuums being a lot more expensive) should be fixed in the upcoming 9.6.
- nickpsecurity 10y agoAwesome! I already push Postgres and praise its team for the quality focus. Just extra evidence in your favor. :)