Re: does VACUUM ANALYZE complete with this error?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Susan Russo <russo(at)morgan(dot)harvard(dot)edu>
Cc: harvsys(at)morgan(dot)harvard(dot)edu, pgsql-performance(at)postgresql(dot)org
Subject: Re: does VACUUM ANALYZE complete with this error?
Date: 2007-05-23 18:31:01
Message-ID: 22911.1179945061@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Susan Russo <russo(at)morgan(dot)harvard(dot)edu> writes:
>> What PG version is that? I recall we fixed a problem recently that
>> caused the requested max_fsm_pages to increase some more when you'd
>> increased it to what the message said.

> 8.1.4

OK, I checked the CVS history and found this:

2006-09-21 16:31 tgl

* contrib/pg_freespacemap/README.pg_freespacemap,
contrib/pg_freespacemap/pg_freespacemap.c,
contrib/pg_freespacemap/pg_freespacemap.sql.in,
src/backend/access/gin/ginvacuum.c,
src/backend/access/gist/gistvacuum.c,
src/backend/access/nbtree/nbtree.c, src/backend/commands/vacuum.c,
src/backend/commands/vacuumlazy.c,
src/backend/storage/freespace/freespace.c,
src/include/storage/freespace.h: Fix free space map to correctly
track the total amount of FSM space needed even when a single
relation requires more than max_fsm_pages pages. Also, make VACUUM
emit a warning in this case, since it likely means that VACUUM FULL
or other drastic corrective measure is needed. Per reports from
Jeff Frost and others of unexpected changes in the claimed
max_fsm_pages need.

This is in 8.2, but we didn't back-patch because it made incompatible
changes in the contrib/pg_freespacemap views.

As the commit message says, the behavior of having the requested
max_fsm_pages value move up after you increase the setting is triggered
by having individual tables that need more than max_fsm_pages. So you
definitely have got a problem of needing more vacuuming...

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Y Sidhu 2007-05-23 18:58:06 Simulate database fragmentation
Previous Message Susan Russo 2007-05-23 18:18:41 Re: does VACUUM ANALYZE complete with this error?