"Kern Sibbald" <[email protected]> wrote:
>On Wednesday 07 April 2010 10:07:25 Jeroen van Meeuwen wrote:
>> "Eric Bollengier" <[email protected]> wrote:
>> >> In PostgreSQL, toast objects (like blob) larger than 1024bytes are
>> >> compressed by the engine in toast area. (MySQL should do the same thing)
>> >
>> >MySQL can compress fields, but you need to modify sql queries to add
>> > COMPRESS() and UNCOMPRESS() calls. Not so nice.
>>
>> Just thinking out loud here; could one do this through a number of db level
>> functions?
>>
>
>Hello Jeroen,
>
>Thanks for your web site blog on the Bacula Administration I course :-)
>
Thanks for mentoring us and let me be at the party ;-)
>Well, it would be nice if we could get the SQL engine to compress data for us,
>but if they cannot all do it, then we must do it ourselves.
>
Of course. Possibly (probably?) the latter is the more sustainable route no
matter how you look at it, as Bacula would not have a dependency on db engines
that can take such db level functions for it to be able to compress anything.
-- Jeroen
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Bacula-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-devel
