From 62505d7e0567f93058f8a0c55fd6ac47a2107df0 Mon Sep 17 00:00:00 2001 From: Dan Langille Date: Mon, 20 Sep 2004 12:44:40 +0000 Subject: [PATCH] Improve speed of VolumeToCatalog verify jobs by adding an index on file(pathid); git-svn-id: https://bacula.svn.sourceforge.net/svnroot/bacula/trunk@1599 91ce42f0-d328-0410-95d8-f526ca767f89 --- bacula/src/cats/make_postgresql_tables.in | 5 +++++ 1 file changed, 5 insertions(+) diff --git a/bacula/src/cats/make_postgresql_tables.in b/bacula/src/cats/make_postgresql_tables.in index f145ae6ed9..c8f9a15db4 100644 --- a/bacula/src/cats/make_postgresql_tables.in +++ b/bacula/src/cats/make_postgresql_tables.in @@ -327,6 +327,11 @@ create table unsavedfiles -- add foreign key (filenameid) -- references filename (filenameid) on update restrict on delete restrict; +-- See http://bugs.bacula.org/bug_view_advanced_page.php?bug_id=0000106 +-- Improve speed of VolumeToCatalog + +create index file_pathid on file(pathid); + END-OF-DATA then echo "Creation of Bacula PostgreSQL tables succeeded." -- 2.39.5