Re: fsm allocation

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: fsm allocation
Дата
Msg-id 20051118211159.GD29354@phlogiston.dyndns.org
обсуждение исходный текст
Ответ на fsm allocation  (Colton A Smith <smith@cs.utk.edu>)
Ответы Re: fsm allocation
Список pgsql-admin
On Thu, Nov 17, 2005 at 08:20:12AM -0500, Colton A Smith wrote:
>   By the way, what exactly is the 'free map space' anyway?  And why does
> it need so much space?

There's a useful description in the docs, section 17.4.2 (for 8.1).
I'd look at that.

Your usage might not be stable right now because your FSM was wrong
to begin with.  My bet is that you need to do either a VACUUM FULL or
a dump and reload before twiddling these settings much more.  You
also maybe want either autovacuum, or to increase the frequency of
your vacuums.  Given the database size you discussed, I can't believe
you really need that much space.

A

--
Andrew Sullivan  | ajs@crankycanuck.ca
In the future this spectacle of the middle classes shocking the avant-
garde will probably become the textbook definition of Postmodernism.
                --Brad Holland

В списке pgsql-admin по дате отправления:

Предыдущее
От: Joel Stevenson
Дата:
Сообщение: Re: Suggested HW for postgres ?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: fsm allocation