[Bacula-users] PostgreSQL db indexes on 7.0.5 question

I’m a bit irritated about indexes for PostgreSQL installations of 7.0.5.

In 7.0.5, those are the indexes created by make_postgresql_tables:

CREATE UNIQUE INDEX filename_name_idx on Filename (Name);
CREATE UNIQUE INDEX path_name_idx on Path (Path);
CREATE INDEX file_jpfid_idx on File (JobId, PathId, FilenameId);
CREATE INDEX file_jobid_idx on File (JobId);
CREATE INDEX restore_jobid_idx on RestoreObject(JobId);
CREATE INDEX job_name_idx on job (name);
CREATE INDEX jobhisto_idx ON JobHisto ( StartTime );
CREATE INDEX fileset_name_idx on fileset (fileset);
CREATE INDEX job_media_job_id_media_id_idx on jobmedia (jobid, mediaid);
CREATE INDEX media_poolid_idx ON Media (PoolId);
CREATE INDEX pool_name_idx on pool (name);
create unique index client_name_idx on client (name);
create index log_name_idx on Log (JobId);
CREATE INDEX basefiles_jobid_idx ON BaseFiles ( JobId );


In the upgrade scripts for PostgreSQL, we have found this additional indexes 
are enabled by default:
update_postgresql_tables_7_to_8:create index file_pathid_idx on file(pathid);
update_postgresql_tables_7_to_8:create index file_filenameid_idx on 
file(filenameid);

But the make_postgresql_tables script states:
  -- Possibly add one or more of the following indexes
  --  if your Verifies are too slow, but they can slow down
  --  backups.

Shouldn’t those indexes be optional in the upgrade scripts as well to have 
consistent db installations?

Additionally, I haven’t  found anything about this alternate concurrent 
file_jpf_idx index. 
Is it better to use this one on PGSQL >= 8.2? Is it documented somewhere? 
It’s also not stated in the make_postgresql_tables script:

-- Create the good one
-- If you want to create this index during production, you can use
-- update_postgresql_tables_11_to_12:-- CREATE INDEX CONCURRENTLY file_jpf_idx 
ON File (JobId, PathId, FilenameId)


Thanks,
Robert



------------------------------------------------------------------------------
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users