> 31 июля 2020 г., в 17:32, Ashutosh Sharma <ashu.coe...@gmail.com> написал(а): > > > On Wed, Jul 29, 2020 at 9:58 AM Ashutosh Sharma <ashu.coe...@gmail.com> wrote: > > > I think we should let VACUUM do that. > Sometimes VACUUM will not get to these pages, because they are marked All > Frozen. > An possibly some tuples will get stale on this page again > > Hmm, okay, will have a look into this. Thanks. > > I had a look over this and found that one can use the DISABLE_PAGE_SKIPPING > option with VACUUM to disable all its page-skipping behavior. Oh, wow, I didn't know that. Thanks! This actually will do the trick. I'll try to review your patch again next week. Thanks! Best regards, Andrey Borodin.
- Re: recovering from "found xmin ... from before rel... Robert Haas
- Re: recovering from "found xmin ... from before rel... Andres Freund
- Re: recovering from "found xmin ... from before rel... Robert Haas
- Re: recovering from "found xmin ... from before rel... Robert Haas
- Re: recovering from "found xmin ... from before rel... Ashutosh Sharma
- Re: recovering from "found xmin ... from before rel... Andrey M. Borodin
- Re: recovering from "found xmin ... from before rel... Ashutosh Sharma
- Re: recovering from "found xmin ... from before rel... Andrey M. Borodin
- Re: recovering from "found xmin ... from before rel... Ashutosh Sharma
- Re: recovering from "found xmin ... from before rel... Ashutosh Sharma
- Re: recovering from "found xmin ... from before rel... Andrey M. Borodin
- Re: recovering from "found xmin ... from before rel... MBeena Emerson
- Re: recovering from "found xmin ... from before rel... Ashutosh Sharma
- Re: recovering from "found xmin ... from before rel... Ashutosh Sharma
- Re: recovering from "found xmin ... from before rel... Robert Haas
- Re: recovering from "found xmin ... from before rel... Ashutosh Sharma
- Re: recovering from "found xmin ... from before rel... Robert Haas
- Re: recovering from "found xmin ... from before rel... Ashutosh Sharma
- Re: recovering from "found xmin ... from before rel... Robert Haas
- Re: recovering from "found xmin ... from before rel... Ashutosh Sharma
- Re: recovering from "found xmin ... from before rel... Ashutosh Sharma