From eb0141480c34ec3dfd54bdf78bcf97fbe31537c4 Mon Sep 17 00:00:00 2001 From: Kern Sibbald Date: Sat, 18 Sep 2004 21:08:09 +0000 Subject: [PATCH] Add new PostgreSQL indexes git-svn-id: https://bacula.svn.sourceforge.net/svnroot/bacula/trunk@1596 91ce42f0-d328-0410-95d8-f526ca767f89 --- bacula/src/cats/make_postgresql_tables.in | 2 ++ 1 file changed, 2 insertions(+) diff --git a/bacula/src/cats/make_postgresql_tables.in b/bacula/src/cats/make_postgresql_tables.in index 3e0b517789..f145ae6ed9 100644 --- a/bacula/src/cats/make_postgresql_tables.in +++ b/bacula/src/cats/make_postgresql_tables.in @@ -207,6 +207,8 @@ create table file ); create index file_jobid_idx on file (jobid); +create index file_pathid_idx on file(pathid); +create index file_filenameid_idx on file(filenameid); create table jobmedia ( -- 2.39.2