My odoo postgresql database size increased abnormally

Question

Hi everyone,

I'm facing a discrepancy in my PostgreSQL database management:
i have check my datbase size from backend with this command

SELECT
datname AS database_name,
pg_size_pretty(pg_database_size(datname)) AS database_size
FROM
pg_database
ORDER BY
pg_database_size(datname) DESC;

Database Size Reports from this command around 1135 MB.
But when I downloaded the backup from myinstance/web/database/manager, it around 15Gb increased suddenly. this is a high alert for me, please help me
Any

khan · Answer

i have check my filestore size which is now 20 gb
root@vmi991291:~/services/test_instance# du -sh data/filestore/Restored/
20G  data/filestore/Restored/
root@vmi991291:~/services/test_instance#
kindly tell me what should i do  because now i can't even take the backups

Ray Carnes (ray) · Answer

Attachments like PDFs, images, and other documents are stored in the filestore.
The database only stores metadata about these attachments (such as file name, file type, and path to the file in the filestore).
The backup size will include the database size and the filestore size. If the filestore contains a large number of attachments, it can significantly increase the overall backup size.

المنشورات ذات الصلة	الردود	أدوات العرض
Como puedo poner el campo de una relación Many2one es un selection? help odoo	1 أغسطس 24	2994
calcule amount_taxed in stock_picking تم الحل help odoo	2 أبريل 24	2147
ValueError: Compute method failed to assign product.product(627,).alert_tag help odoo	1 أبريل 24	2688
Events on field change in Odoo 16 odoo odoo16features odoo16	2 أبريل 25	1812
Inter company transfer error intercompany odoo odoo16	0 ديسمبر 24	1451

لقد تم الإبلاغ عن هذا السؤال

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!