pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
[OT?]*_fsm_* parameters in postgresql.conf: which versions supports them?
2+ messages / 2 participants
[nested] [flat]

* [OT?]*_fsm_* parameters in postgresql.conf: which versions supports them?
@ 2003-08-27 11:47 Marco Vezzoli <marco.vezzoli@st.com>
  2003-08-28 03:19 ` Re: [OT?]*_fsm_* parameters in postgresql.conf: which versions supports them? Bruno Wolff III <bruno@wolff.to>
  0 siblings, 1 reply; 2+ messages in thread

From: Marco Vezzoli @ 2003-08-27 11:47 UTC (permalink / raw)
  To: pgsql-sql

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?
TIA
	Marco
-- 
Marco Vezzoli	   tel. +39 039 603 6852
STMicroelectronics fax. +39 039 603 5055



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: [OT?]*_fsm_* parameters in postgresql.conf: which versions supports them?
  2003-08-27 11:47 [OT?]*_fsm_* parameters in postgresql.conf: which versions supports them? Marco Vezzoli <marco.vezzoli@st.com>
@ 2003-08-28 03:19 ` Bruno Wolff III <bruno@wolff.to>
  0 siblings, 0 replies; 2+ messages in thread

From: Bruno Wolff III @ 2003-08-28 03:19 UTC (permalink / raw)
  To: Marco Vezzoli <marco.vezzoli@st.com>; +Cc: pgsql-sql

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.



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2003-08-28 03:19 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-08-27 11:47 [OT?]*_fsm_* parameters in postgresql.conf: which versions supports them? Marco Vezzoli <marco.vezzoli@st.com>
2003-08-28 03:19 ` Bruno Wolff III <bruno@wolff.to>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox