Thread: max_fsm_relations and max_fsm_pages problem

max_fsm_relations and max_fsm_pages problem

From

"Gauthier, Dave"

Date:

18 March 2009, 15:13:52

Hi:

I have max_fsm_relations set to 1200 and max_fsm_pages set to 200000 in postgres.conf (well over 16x max_fsm_relations) but still get...

FATAL: max_fsm_pages must exceed nax_fsm_relations * 16

What’s up ?

(v8.3 on Linux)

Re: max_fsm_relations and max_fsm_pages problem

From

"Gauthier, Dave"

Date:

18 March 2009, 15:18:22

Nevermind (wrong postgres.conf, in wrong dir) Sorry.

-dave

From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Gauthier, Dave
Sent: Wednesday, March 18, 2009 11:13 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] max_fsm_relations and max_fsm_pages problem

Hi:

I have max_fsm_relations set to 1200 and max_fsm_pages set to 200000 in postgres.conf (well over 16x max_fsm_relations) but still get...

FATAL: max_fsm_pages must exceed nax_fsm_relations * 16

What’s up ?

(v8.3 on Linux)

Re: max_fsm_relations and max_fsm_pages problem

From

Date:

18 March 2009, 15:19:53

Question How many database objects or relations do you have?

Thanks

Deepak

On Wed, Mar 18, 2009 at 8:12 AM, Gauthier, Dave <dave.gauthier@intel.com> wrote:

Hi:

I have max_fsm_relations set to 1200 and max_fsm_pages set to 200000 in postgres.conf (well over 16x max_fsm_relations) but still get...

FATAL: max_fsm_pages must exceed nax_fsm_relations * 16

What’s up ?

(v8.3 on Linux)