Обсуждение: [OT?]*_fsm_* parameters in postgresql.conf: which versions supports them?

Поиск
Список
Период
Сортировка

[OT?]*_fsm_* parameters in postgresql.conf: which versions supports them?

От
Marco Vezzoli
Дата:
Hi,
hope this is not too off topic: I run postgresql 7.1.3 on Solaris 8;
I've read on  http://cbbrowne.com/info/postgresql.html that 'You will
only get effective nonblocking VACUUM queries if the dead tuples can be
listed in the Free Space Map': this could be done '[increasing], in
postgresql.conf, the value of max_fsm_pages and max_fsm_relations'.
I didn't found any of these parameter in my postgresql.conf so I suppose
that my version of postgresql is too old.
Which versions supports these parameters?
TIAMarco
-- 
Marco Vezzoli       tel. +39 039 603 6852
STMicroelectronics fax. +39 039 603 5055


Re: [OT?]*_fsm_* parameters in postgresql.conf: which versions supports them?

От
Bruno Wolff III
Дата:
On Wed, Aug 27, 2003 at 13:47:08 +0200, Marco Vezzoli <marco.vezzoli@st.com> wrote:
> Hi,
> hope this is not too off topic: I run postgresql 7.1.3 on Solaris 8;
> I've read on  http://cbbrowne.com/info/postgresql.html that 'You will
> only get effective nonblocking VACUUM queries if the dead tuples can be
> listed in the Free Space Map': this could be done '[increasing], in
> postgresql.conf, the value of max_fsm_pages and max_fsm_relations'.
> I didn't found any of these parameter in my postgresql.conf so I suppose
> that my version of postgresql is too old.

Yes, your version is too old.

> Which versions supports these parameters?

You probably want to upgrade to 7.3.4.