"Vadim Mikheev" <[EMAIL PROTECTED]> writes: > It probably will not cause more IO than vacuum does right now. > But unfortunately it will not reduce that IO. Uh ... what? Certainly it will reduce the total cost of vacuum, because it won't bother to try to move tuples to fill holes. The index cleanup method I've proposed should be substantially more efficient than the existing code, as well. > My point is that we'll need in dynamic cleanup anyway and UNDO is > what should be implemented for dynamic cleanup of aborted changes. UNDO might offer some other benefits, but I doubt that it will allow us to eliminate VACUUM completely. To do that, you would need to keep track of free space using exact, persistent (on-disk) bookkeeping data structures. The overhead of that will be very substantial: more, I predict, than the approximate approach I proposed. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
- Re: [HACKERS] Plans for solving the VACUUM prob... Vadim Mikheev
- Re: [HACKERS] Plans for solving the VACUUM ... Tom Lane
- Re: [HACKERS] Plans for solving the VAC... Vadim Mikheev
- Re: [HACKERS] Plans for solving th... Tom Lane
- Re: [HACKERS] Plans for solvin... Vadim Mikheev
- Re: [HACKERS] Plans for solving th... The Hermit Hacker
- Re: [HACKERS] Plans for solvin... Tom Lane
- Re: [HACKERS] Plans for solvin... Vadim Mikheev
- Re: [HACKERS] Plans for solvin... Tom Lane
- Re: [HACKERS] Plans for solvin... Vadim Mikheev
- Re: [HACKERS] Plans for solvin... Tom Lane
- Re: [HACKERS] Plans for solving the VACUUM problem Nathan Myers
- Re: [HACKERS] Plans for solving the VACUUM problem Tom Lane
- Re: [HACKERS] Plans for solving the VACUUM problem Tom Lane
- Re: [HACKERS] Plans for solving the VACUUM problem Tom Lane
- Re: [HACKERS] Plans for solving the VACUUM problem Vadim Mikheev
- RE: [HACKERS] Plans for solving the VACUUM problem Mikheev, Vadim
- RE: [HACKERS] Plans for solving the VACUUM problem Mikheev, Vadim
- RE: [HACKERS] Plans for solving the VACUUM problem Mikheev, Vadim
- RE: [HACKERS] Plans for solving the VACUUM problem Mikheev, Vadim
- Re: [HACKERS] Plans for solving the VACUUM problem Tom Lane