Thanks Radoslaw for this input. Well , I am not an expert on PostgreSQL fine tuning, will look in to that if you can provide some high level hints.
-Yateen From: Radosław Korzeniewski <rados...@korzeniewski.net> Sent: Saturday, October 7, 2023 3:19 PM To: Yateen Shaligram Bhagat (Nokia) <yateen.shaligram_bha...@nokia.com> Cc: Dan Langille <d...@langille.org>; fk+bacula--- via Bacula-users <bacula-users@lists.sourceforge.net> Subject: Re: [Bacula-users] Running backup job without file records in catalog CAUTION: This is an external email. Please be very careful when clicking links or opening attachments. See the URL nok.it/ext for additional information. Hello, śr., 4 paź 2023 o 14:29 Yateen Shaligram Bhagat (Nokia) <yateen.shaligram_bha...@nokia.com<mailto:yateen.shaligram_bha...@nokia.com>> napisał(a): We don’t need the File Records in backup because : 1. Each of our production servers (hundreds of them) being backed up, has number of files in the range of hundred-thousands. 2. With Catalog Files = Yes (default), the database (PostGreSQL) hogs the CPUs on the host, with say 100 concurrent weekly Full backup jobs, putting a lot of stress on the server. My catalog handles 81M files on very ancient hardware and it is far below any stress on the server. I tuned my PostgreSQL instance, so it performs smoothly (even on spinning disks). best regards -- Radosław Korzeniewski rados...@korzeniewski.net<mailto:rados...@korzeniewski.net>
_______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
