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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
