Ya, most of it's system stuff. OK, I see where the 1000 comes from. I bumped it up to 1200 in postgresql.conf. Is there a way I can spin that in without rebooting the DB (and kicking my user off)?
-dave -----Original Message----- From: Bill Moran [mailto:wmo...@potentialtech.com] Sent: Friday, February 27, 2009 4:00 PM To: Gauthier, Dave Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] max_fsm_relations In response to "Gauthier, Dave" <dave.gauth...@intel.com>: > There is no way I have 1000 tables/indexes. But maybe it's counting > table/index file extensions in the mix? What's the metadata query to see > these 1000 relations? Are you counting tables, indexes, sequences, pg_toast tables, system tables? SELECT relname,reltype from pg_class; Make sure you do that query for every database and add them up. -- Bill Moran http://www.potentialtech.com http://people.collaborativefusion.com/~wmoran/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
