From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Jochem van Dieten <jochemd(at)oli(dot)tudelft(dot)nl> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Database quota |
Date: | 2002-03-15 23:20:38 |
Message-ID: | 6251.1016234438@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Sabino Mullane | 2002-03-15 23:37:08 | Re: Random Numbers/Letters |
Previous Message | Dmitry Tkach | 2002-03-15 23:09:07 | Re: Btree index extension question |