Re: Database quota

Jochem van Dieten <jochemd(at)oli(dot)tudelft(dot)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