Rick Gigger <rick@alpinenetworking.com> writes:
> I don't know if 2K could have passed since the last checkpoint.
> ...
> now that I think about it I was getting about 400 pages requests /
> minute and each of those would have have been doing at least 2
> transactions so yes, I guess that is very likely.
Good, 'cause if you didn't have a couple thousand transactions between
checkpoints then we need another theory ;-)
>> You realize of course that that's pretty old ...
> Yes. I will be upgrading immediately.
You'll want to include this patch:
http://archives.postgresql.org/pgsql-committers/2006-01/msg00289.php
(or see adjacent messages if you plan to move to something newer than
7.3.*). We probably will not put out another set of releases until
next month, unless something really big comes along. This one doesn't
qualify as really big IMHO, because it's not a PANIC-grade failure in
the later branches. But having been burnt once, I'm sure you'll want
a patched copy ...
regards, tom lane