Hello Marco,
On 2/27/23 16:50, Marco Gaiarin wrote:
I've tried to lieave more RAM to the VM that run the director (and the DB),
first 8, the 16 now i try with 32GB, but...
For the archive, with 32GB of RAM pstgres does not crash, but still cath an
out_of_memory condition (correctly) and abort the query.
How can i do? Thanks.
I would recommend to tune the database server correctly, PostgreSQL is smart
enough to use the resources that are allocated for any kind of query. When
running "out of memory", it will for example use the disk.
Maybe the disk is not correctly sized for your database? Maybe the Postgresql
configuration is not adequate? (the default work_mem was about 64k few versions
ago), etc...
Hope it helps!
Best Regards,
Eric
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
