Sorry, I was wrong about the number of files. We actually have about
13k files. Each commit now is adding almost 700k to /dv/revs. If we
were versioning only at the file level (which is all we really require),
each commit should only use at most the size of the files being updated,
plus any commit comments. This is one reason I'd consider going back to
cvs for this particular repository. I believe we'd have to do a
significant amount of work to recode our app to interface with cvs.
As far as pruning older revisions goes, that's possible for roughly 25%
of the files in the repository. I rebuilt the repository with the
historical revisions for the other 75%, then imported only the most
recent version of the 25% in a single mass commit. This decreased the
repository size to about 11gb.
-----Original Message-----
From: Kevin Greiner [mailto:greinerk@gmail.com]
Sent: Friday, January 27, 2006 5:28 PM
To: Dan White
Cc: users@subversion.tigris.org
Subject: Re: application ill-suited for svn?
On 1/25/06, Dan White <dwhite@clubmom.com> wrote:
> Unfortunately we didn't consider how repository
> level versioning (which has no benefit in this application) would
> inflate the db size. Some 6000 files, each only a few kb in size, and
> 62000 revisions later, our /db/revs dir is about 19gb in size and
> growing almost 1gb daily. We never have multiple file commits.
This is the first I've heard about reposity level versioning inflating
the db size. Could you elaborate? If I did my math right (19,000,000kb
/ 62,000 revs) you're averaging about 300kb per commit. That does seem
high to me. And if you're growing at 1gb/day that means you're getting
roughly 3,300 commits/day. That sound about right?
I'm wondering if you could remove older revisions periodically? The
dump file outputs revisions in date order but I don't know if you
could chop off, say, the first 20,000 revisions without borking the
resulting loaded repo or not. Anyone tried this?
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org
Received on Sun Jan 29 00:27:16 2006