On 04/10/10, James Harper (james.har...@bendigoit.com.au) wrote: > > On 04/10/10, James Harper (james.har...@bendigoit.com.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 r...@campbell-lange.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users