From: Kern S. <ke...@si...> - 2010-04-07 09:26:55
|
On Wednesday 07 April 2010 10:07:25 Jeroen van Meeuwen wrote: > "Eric Bollengier" <er...@eb...> 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? > > My $.02 > > -- Jeroen Hello Jeroen, Thanks for your web site blog on the Bacula Administration I course :-) 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. In starting to write the code to handle these restore objects as I call them, which are handled differently from file data, I am venturing into Bacula code that I have rarely touched since the year 2000. I am pleasantly surprised to see the code is very flexible and already had provisions for passing "special" data in the way I want. This that at least for Bacula's internal treatment of this restore object data (Windows XML) files, it will all be treated much as Bacula has been treating certain data now for many years. Best regards, Kern |