Michael Paquier <michael.paqu...@gmail.com> writes: > On Sat, Oct 22, 2016 at 12:15 AM, Jim Nasby <jim.na...@bluetreble.com> wrote: >> On 10/21/16 8:47 AM, Tom Lane wrote: >>> If we are willing to do that then we don't really have to solve the >>> problem on the backend side. One could expect that autovacuum would >>> clean things up within a few minutes after a backend failure.
> I am really thinking that we should just do that and call it a day > then, but document the fact that if one wants to look at the content > of orphaned tables after a crash he had better turn autovacuum to off > for the time of the analysis. Yeah, agreed. This also points up the value of Robert's suggestion of a "really off" setting. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers