Bỏ qua để đến Nội dung
Menu
Câu hỏi này đã bị gắn cờ
4 Trả lời
12779 Lượt xem

Could somebody please explain what the is the purpose of the Scheduled Action - "Base: Auto-vacuum internal data"?

What does this action do exactly?

Ảnh đại diện
Huỷ bỏ
Câu trả lời hay nhất

Hi,

Base: Auto-vacuum Internal Data:

Module: This action could be related to the Database Maintenance or System module in Odoo.
Purpose: "Auto-vacuum Internal Data" typically refers to a database maintenance task. Auto-vacuum is a process used to reclaim storage space and optimize the database by removing obsolete data or reclaiming space from deleted records. This schedule action automates the database maintenance process to keep the system running efficiently and prevent unnecessary data bloat.


Hope it helps


Ảnh đại diện
Huỷ bỏ
Tác giả Câu trả lời hay nhất

Thank you for the above replies. I don't have enough karma to comment individually on the above.

Follow-up - So then this is the same as the internal "Vacuum Verbose" and "Vacuum Full" functionality provided by a PostgreSQL DB?

I also read somewhere (but can't find it now) that "Base: Auto-vacuum internal data" also cleans up the Odoo filestore - deleting unneeded files. Is that true?

Ảnh đại diện
Huỷ bỏ

Regarding your first question, they're probably not the same as the code is basically running a COALESCE command. Here's a link to the underlying code if you are interested in exploring it further.

https://github.com/odoo/odoo/blob/13.0/odoo/models.py#L4716

Regarding your second question. Yes. "Base: Auto-vacuum internal data" performs garbage collection of the filestore. Link to underlying code for this:

https://github.com/odoo/odoo/blob/13.0/odoo/addons/base/models/ir_attachment.py#L140

Câu trả lời hay nhất

Hello Faisal
Base: Auto-vacuum internal data use for Transient model data cleans up automatically by Scheduled Action

Ảnh đại diện
Huỷ bỏ
Câu trả lời hay nhất

It's related to postgres. Here's an explanation of autovacuum from the postegres documentation:

"autovacuum checks for tables that have had a large number of inserted, updated or deleted tuples and then vacuum or analyze the table based on the threshold."

Ảnh đại diện
Huỷ bỏ
Bài viết liên quan Trả lời Lượt xem Hoạt động
1
thg 3 24
2044
3
thg 6 23
11330
1
thg 12 21
14224
2
thg 11 23
2566
0
thg 3 15
3724