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 <[email protected]> Sent: Saturday, October 7, 2023 3:19 PM To: Yateen Shaligram Bhagat (Nokia) <[email protected]> Cc: Dan Langille <[email protected]>; fk+bacula--- via Bacula-users <[email protected]> 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) <[email protected]<mailto:[email protected]>> 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 [email protected]<mailto:[email protected]>
_______________________________________________ Bacula-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-users
