Postgres Pro
Downloads
Home   >   mailing lists

Have vacuum emit a warning when it runs out of maintenance_work_mem - Mailing list pgsql-patches

From Jim Nasby
Subject Have vacuum emit a warning when it runs out of maintenance_work_mem
Date
Msg-id 47F95E95-8D2B-4322-ACCD-769EA2675FDE@decibel.org
Whole thread Raw
Responses Re: Have vacuum emit a warning when it runs out of maintenance_work_mem  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
Tree view 
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...
--
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)
Attachment

pgsql-patches by date:

Previous
From: Gregory Stark
Date:
Subject: Doc and comment patch for packed varlena
Next
From: Tom Lane
Date:
Subject: Re: Have vacuum emit a warning when it runs out of maintenance_work_mem