Jochem van Dieten <jochemd@oli.tudelft.nl> writes:
> Unless you make a typo in the where clause of a function and update half
> a million rows 1200 times instead of 1200 rows out of half a million :(
> It was one tranaction so the WAL grew to 312 segments before the
> postmaster died due to a full /var/.
You need to update to 7.1.3 or later --- that WAL growth problem is
long gone.
> The good news, and shining example of the stability of PostgreSQL, was
> that after a little space was freed PostgreSQL just restarted and
> recycled all the WAL segments. Even dying is done gracefully by PostgreSQL.
We have users who let us know when it doesn't ;-)
regards, tom lane