Re: postgresql meltdown on PlanetMath.org

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: postgresql meltdown on PlanetMath.org
Дата
Msg-id 7699.1047929160@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: postgresql meltdown on PlanetMath.org  (Chris Sutton <chris@smoothcorp.com>)
Ответы Re: postgresql meltdown on PlanetMath.org  (Andrew Sullivan <andrew@libertyrms.info>)
Список pgsql-performance
Chris Sutton <chris@smoothcorp.com> writes:
> On Mon, 17 Mar 2003, Tom Lane wrote:
>> In CVS tip, a whole-database VACUUM VERBOSE gives info about the free
>> space map occupancy, eg
>> INFO:  Free space map: 224 relations, 450 pages stored; 3776 total pages needed.
>> Allocated FSM size: 1000 relations + 20000 pages = 178 KB shared mem.

> How do you get this information?

Before CVS tip, you don't.

[ thinks...]  Perhaps we could back-port the FSM changes into 7.3 ...
it would be a larger change than I'd usually consider reasonable for a
stable branch, though.  Particularly considering that it would be hard
to call it a bug fix.  By any sane definition this is a new feature,
and we have a policy against putting new features in stable branches.

            regards, tom lane

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

Предыдущее
От: "Neil Conway"
Дата:
Сообщение: Re: postgresql meltdown on PlanetMath.org
Следующее
От: Andrew Sullivan
Дата:
Сообщение: Re: postgresql meltdown on PlanetMath.org