I run Bacula+Postgres on a raspberry pi, 4 core, 8GB and have never tuned the database, just the default settings. The dbcheck works fine.
I'm wondering now whether i should tune it or leave well alone? -Chris Wilkinson On Tue, 28 Feb 2023, 08:04 Eric Bollengier via Bacula-users, < bacula-users@lists.sourceforge.net> wrote: > 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 >
_______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
