> Really?! Once again: WAL records give you *physical* address of tuples > (both heap and index ones!) to be removed and size of log to read > records from is not comparable with size of data files. So how about a background "vacuum like" process, that reads the WAL and does the cleanup ? Seems that would be great, since it then does not need to scan, and does not make forground cleanup necessary. Problem is when cleanup can not keep up with cleaning WAL files, that already want to be removed. I would envision a config, that sais how many Mb of WAL are allowed to queue up before clients are blocked. Andreas ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
- AW: [HACKERS] Plans for solving the VACUUM problem Zeugswetter Andreas SB
- Re: AW: [HACKERS] Plans for solving the VACUUM... Tom Lane
- AW: [HACKERS] Plans for solving the VACUUM pro... Zeugswetter Andreas SB
- AW: [HACKERS] Plans for solving the VACUUM pro... Zeugswetter Andreas SB
- AW: [HACKERS] Plans for solving the VACUUM pro... Zeugswetter Andreas SB
- AW: [HACKERS] Plans for solving the VACUUM pro... Zeugswetter Andreas SB
- AW: [HACKERS] Plans for solving the VACUUM pro... Zeugswetter Andreas SB
- RE: AW: [HACKERS] Plans for solving the VACUUM... Mikheev, Vadim
- AW: [HACKERS] Plans for solving the VACUUM pro... Zeugswetter Andreas SB
- RE: AW: [HACKERS] Plans for solving the VACUUM... Mikheev, Vadim
- AW: [HACKERS] Plans for solving the VACUUM pro... Zeugswetter Andreas SB
- AW: [HACKERS] Plans for solving the VACUUM pro... Zeugswetter Andreas SB
- AW: [HACKERS] Plans for solving the VACUUM pro... Zeugswetter Andreas SB
- Re: AW: [HACKERS] Plans for solving the VA... Philip Warner