Postgres Pro
Downloads
Home   >   mailing lists

do only critical work during single-user vacuum? - Mailing list pgsql-hackers

From John Naylor
Subject do only critical work during single-user vacuum?
Date
Msg-id CAFBsxsFL5LoWanSLDjt_SjS9=FU_9XWi22iHMexRS2SubkX-Vw@mail.gmail.com
Whole thread Raw
Responses Re: do only critical work during single-user vacuum?  ("Bossart, Nathan" <bossartn@amazon.com>)
Re: do only critical work during single-user vacuum?  (Peter Geoghegan <pg@bowt.ie>)
Re: do only critical work during single-user vacuum?  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
Tree view 
When a user must shut down and restart in single-user mode to run
vacuum on an entire database, that does a lot of work that's
unnecessary for getting the system online again, even without
index_cleanup. We had a recent case where a single-user vacuum took
around 3 days to complete.

Now that we have a concept of a fail-safe vacuum, maybe it would be
beneficial to skip a vacuum in single-user mode if the fail-safe
criteria were not met at the beginning of vacuuming a relation. This
is not without risk, of course, but it should be much faster than
today and once up and running the admin would have a chance to get a
handle on things. Thoughts?

-- 
John Naylor
EDB: http://www.enterprisedb.com

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: pg_stat_bgwriter.buffers_backend is pretty meaningless (and more?)
Next
From: Andres Freund
Date:
Subject: Re: Avoiding smgrimmedsync() during nbtree index builds