]> git.sur5r.net Git - bacula/bacula/commit
Remove the file_fp_idx index for Postgresql (FilenameId, PathId) on
authorEric Bollengier <eric@eb.homelinux.org>
Tue, 22 Sep 2009 21:17:03 +0000 (23:17 +0200)
committerEric Bollengier <eric@eb.homelinux.org>
Tue, 22 Sep 2009 21:17:03 +0000 (23:17 +0200)
commit18c6a923657b3adfcafc07cee60de4a319c23e0a
tree8192c9ad79237056bca88fbd3761ad3a6239e6c4
parent66ad6c6aa0a048f26983ff8e2b9cee5ebe40a959
Remove the file_fp_idx index for Postgresql (FilenameId, PathId) on
File table.
It is useless for common usage, and causes performance issues.
This index fragments over the time and the update cost grows
very quickly. (This index is not present on Mysql schema)
bacula/src/cats/make_postgresql_tables.in
bacula/technotes