> It'd be really nice if Bacula could store this information in a more
> query-friendly way.

Oh, as a follow-up to my prior post:

For what it's worth, in PostgreSQL the amount of storage required to
store the lstat information as individual int4 fields is almost exactly
the same as what's needed to store it in Bacula's base64-encoded form:

bacula=# SELECT (decode_stat(lstat)).* INTO TEMPORARY TABLE lstat_real
FROM file;
bacula=# SELECT lstat INTO TEMPORARY TABLE lstat_text FROM file;

bacula=# select pg_total_relation_size('lstat_text');
 pg_relation_size
------------------
        754434048
(1 row)

bacula=# select pg_total_relation_size('lstat_real');
 pg_relation_size
------------------
        749903872
(1 row)

... so it'd be REALLY nice if Bacula was able to just store the lstat
data directly.

--
Craig Ringer

------------------------------------------------------------------------------
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users