Have vacuum emit a warning when it runs out of maintenance_work_mem

From: Jim Nasby <decibel(at)decibel(dot)org>
To: pgsql-patches(at)postgresql(dot)org
Subject: Have vacuum emit a warning when it runs out of maintenance_work_mem
Date: 2007-05-09 18:01:18
Message-ID: 47F95E95-8D2B-4322-ACCD-769EA2675FDE@decibel.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Any time this happens it's generally a nasty surprise for users. It
would be nice to throw them an explicit warning that it's occurring.

decibel=# vacuum i;
WARNING: exceeded maintenance_work_mem while vacuuming relation
"public.i"
HINT: Consider increasing maintenance_work_mem
VACUUM
decibel=#

Attached passes regression tests...

Attachment Content-Type Size
patch application/octet-stream 2.1 KB

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2007-05-09 18:27:57 Re: Have vacuum emit a warning when it runs out of maintenance_work_mem
Previous Message Gregory Stark 2007-05-09 17:28:58 Doc and comment patch for packed varlena