Re: How to avoid transaction ID wrap

"Joshua D. Drake" <jd@commandprompt.com> writes:
> I was recently involved in a project where we had to decrease the 
> checkpoint_timeout . The problem was, that the database was performing 
> so many transactions that if we waiting for 5 minutes, checkpoint would 
> take entirely too long.

Seems like the correct fix for that is to make the bgwriter more
aggressive.  Narrowing the checkpoint spacing is a pretty horrid answer
because of the resulting increase in full-page-image WAL traffic.
        regards, tom lane