]> 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)
commit8e7a742d1b1d90703ba65256b48fd3681dffad04
treec2326478424784b06ff9da69416e945803405b8d
parentc1f8cca7bc220e7db77a0415846bfd39a5693d9f
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