Re: does VACUUM ANALYZE complete with this error?

On May 23, 2007, at 9:26 AM, Susan Russo wrote:

> I've played 'catch up' wrt adjusting max_fsm_pages (seems to be a
> regular event),
> however am wondering if the vacuum analyze which reports the error was
> actually completed?

Yes, it completed. However not all pages with open space in them are
accounted for, so you will probably end up allocating more pages than
you otherwise would have. I take it as a sign of not running vacuum
often enough so that the pages with available space get filled up
sooner.

I'd bump fsm pages up to perhaps double or triple what you've got
now, and try running vacuum a bit more often on your hottest tables
(or even consider changing your table structure to limit the
"hotness" of that table). For example, if the table has a lot of
columns, but only one is updated often, split that column out into
its own table so that you have all the changes clustered into the
same set of pages while leaving the rest of the columns in place.