RE: FSFS packing: experiences?

> I don't think so, I've not seen any performance improvements using it.
> However, bear in mind that revprops are not packed - only revisions, so
> log performance will not be affected at all anyway.

After some analysis of svn log, I think revs are certainly just as relevant as revprops. I've been meaning to start another (user or dev) thread about that (and I will), but here is some output of "rwsnoop" on our Solaris SVN server (1.5.4). We captured this while running "svn log https://svnserver/svn/trunk/file_with_lots_of_revisions".

-------- extract from rwsnoop
24435 9896 httpd R 3862 /path/to/repos/db/revs/58/58335
24435 9896 httpd R 4096 /path/to/repos/db/revs/58/58335
24435 9896 httpd R 4096 /path/to/repos/db/revs/58/58335
24435 9896 httpd R 4096 /path/to/repos/db/revs/58/58335
24435 9896 httpd R 4096 /path/to/repos/db/revs/58/58335
24435 9896 httpd R 4096 /path/to/repos/db/revs/58/58335
24435 9896 httpd R 4096 /path/to/repos/db/revs/58/58335
24435 9896 httpd R 4096 /path/to/repos/db/revs/58/58335
24435 9896 httpd R 4096 /path/to/repos/db/revs/58/58335
24435 9896 httpd R 4096 /path/to/repos/db/revs/58/58335
24435 9896 httpd R 4096 /path/to/repos/db/revs/58/58301
24435 9896 httpd R 143 /path/to/repos/db/revprops/58/58335
24435 9896 httpd R 64 /path/to/repos/db/revs/58/58301
24435 9896 httpd R 276 /path/to/repos/db/revs/58/58301
24435 9896 httpd R 276 /path/to/repos/db/revs/58/58301
24435 9896 httpd R 4096 /path/to/repos/db/revs/58/58258
24435 9896 httpd R 131 /path/to/repos/db/revprops/58/58301
24435 9896 httpd R 64 /path/to/repos/db/revs/58/58258
24435 9896 httpd R 275 /path/to/repos/db/revs/58/58258
...
--------

I guess that "svn log <path>" needs to read the relevant revs as well, just to determine which was the preceding revision that should be read next (information that's not present in the revprop files). Note that I didn't use "-v", so I didn't ask for the paths that were affected by the revisions (in that case, I could certainly understand the need to read the rev files).

Anyway, I've been meaning to discuss this, because I think there is a lot of room for improvement here, but now I just wanted to know if anyone has seen "real-world" improvement by packing. Has anyone ever compared timings of log and/or annotate pre- and post-packing? That would be really interesting ...

Johan

------------------------------------------------------
http://subversion.tigris.org/ds/viewMessage.do?dsForumId=1065&dsMessageId=2363252

To unsubscribe from this discussion, e-mail: [users-unsubscribe_at_subversion.tigris.org].
Received on 2009-06-18 18:09:57 CEST