Re: Turn on git pack bitmaps?

On 2015-02-21 13:34:06 -0500, Tom Lane wrote:
> Magnus Hagander <magnus@hagander.net> writes:
> > On Thu, Feb 19, 2015 at 5:01 PM, Andres Freund <andres@2ndquadrant.com>
> > wrote:
> >> It'll stay enabled/in effect for the future. But it'd be a good idea to
> >> regularly schedule a repack independent of bitmaps - or enable automatic
> >> gc's on push (not sure which version made that available). Right now
> >> git.pg.o's postgresql.git is ~40MB bigger than my local one...
> 
> > Well, it does them now and then, IIRC? We haven't set up a cronjob for it,
> > but I'm fairly certain I've gotten stuck with it doing GC during a commit
> > someitme...

Those don't have the same effect as a full repack though, as they only
pack recently created objects into a new pack file and occasionally
collapse pack files. Doing a full repack, with more aggressive settings,
can considerably shrink the repository.

> Yeah, I got one just a couple of minutes ago.
> 
> There was a noticeable delay after the "auto packing" message.

That's gone in a newer git btw, it moves that automatically into the
background.

> mind this happening once in awhile, but I don't see a need to do it
> on every commit; please let's not have auto-gc-on-commit.

Yea, doing it on every commit wouldn't make any sense.

Greetings,

Andres Freund

-- Andres Freund                       http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services