> > Devs: any objection to making this permanent on at least the > > PostgreSQL catalog? > > > > There is really no downside to this. > > Yes I have an objection, it will slow down all backups to speed up > very > special restore case. > > I think that the problem is more on the database tuning or on the > query > itself. I have the same kind of query in Bweb and it runs instantly > (that displays all version of a file for a client) on very large > catalog. > > When you add new indexes on the File table it leads to support > problems > where people are complaining about backup speed...
At least on this box, the CPU isn't an issue, so updating some more indices won't hurt too much. With some old box with old spinning rust for the databse, it might matter more, though. Anyway - if not adding it to the mainline, perhaps adding it to the FAQ instead? The query time went from 15 minutes to <50ms after adding this index... Vennlige hilsener / Best regards roy -- Roy Sigurd Karlsbakk (+47) 97542685 r...@karlsbakk.net http://blogg.karlsbakk.net/ -- I all pedagogikk er det essensielt at pensum presenteres intelligibelt. Det er et elementært imperativ for alle pedagoger å unngå eksessiv anvendelse av idiomer med fremmed opprinnelse. I de fleste tilfeller eksisterer adekvate og relevante synonymer på norsk. ------------------------------------------------------------------------------ 5 Ways to Improve & Secure Unified Communications Unified Communications promises greater efficiencies for business. UC can improve internal communications as well as offer faster, more efficient ways to interact with customers and streamline customer service. Learn more! http://www.accelacomm.com/jaw/sfnl/114/51426253/ _______________________________________________ Bacula-devel mailing list Bacula-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-devel
