On 04/10/10, James Harper (james.harper AT bendigoit.com DOT au) wrote:
> > On 04/10/10, James Harper (james.harper AT bendigoit.com DOT au) wrote:
> > A full pg_dump of the catalogue is 2.8G. The output of the catalogue
> > snapshot for job 60 is 1.6G. Naturally, the full pg_dump of the
> > whole database will continue to grow over time.

> > I'm a little suprised that the proportion of job 60 to the whole is
> > so high. Job 60 is similar to job 1, but I don't expect they share
> > much information. I'll have to look into that.
> 
> If jobid 60 and job 1 were the same backup job then a lot of the
> information may be shared in the filename table. Even if they are
> backups of similar servers then they will share a lot of filename data
> and that filename data has to come with the extracted catalogue so you
> might not be saving that much.

My backups are all full backups. Also, the key "file" table in postgres (which
joins files and paths) is job specific, so I'm not sure where any
duplication is emanating from.

Regards
Rory

                             Table "public.file"
   Column   |  Type   |                       Modifiers                       
------------+---------+-------------------------------------------------------
 fileid     | bigint  | not null default nextval('file_fileid_seq'::regclass)
 fileindex  | integer | not null default 0
 jobid      | integer | not null
 pathid     | integer | not null
 filenameid | integer | not null
 markid     | integer | not null default 0
 lstat      | text    | not null
 md5        | text    | not null


-- 
Rory Campbell-Lange
rory AT campbell-lange DOT net

Campbell-Lange Workshop
www.campbell-lange.net
0207 6311 555
3 Tottenham Street London W1T 2AF
Registered in England No. 04551928

------------------------------------------------------------------------------
Virtualization is moving to the mainstream and overtaking non-virtualized
environment for deploying applications. Does it make network security 
easier or more difficult to achieve? Read this whitepaper to separate the 
two and get a better understanding.
http://p.sf.net/sfu/hp-phase2-d2d
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users