X-Original-To: pgsql-performance@postgresql.org Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id E02DC475F39 for ; Mon, 17 Mar 2003 21:51:50 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.8/8.12.8) with ESMTP id h2I2pnub015805; Mon, 17 Mar 2003 21:51:50 -0500 (EST) To: Logan Bowers Cc: Neil Conway , sean@chittenden.org, pgsql-performance@postgresql.org Subject: Re: postgresql meltdown on PlanetMath.org In-reply-to: References: <20030316060125.GD19570@vt.edu> <3E741B93.1090203@joeconway.com> <20030316075206.GE19570@vt.edu> <20030317061011.GH23355@perrin.int.nxad.com> <33137.130.15.224.150.1047881939.squirrel@mailbox.samurai.com> <495.1047882860@sss.pgh.pa.us> Comments: In-reply-to Logan Bowers message dated "Mon, 17 Mar 2003 21:41:07 -0500" Date: Mon, 17 Mar 2003 21:51:49 -0500 Message-ID: <15804.1047955909@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200303/132 X-Sequence-Number: 1430 Logan Bowers writes: > I've attached a VACUUM VERBOSE and my conf file (which is pretty vanilla, > I haven't tweaked it since updating). You definitely need to increase the fsm shared memory parameters. The default max_fsm_relations is just plain too small (try 1000) and the default_max_fsm_pages is really only enough for perhaps a 100Mb database. I'd try bumping it to 100,000. Note you need a postmaster restart to make these changes take effect. regards, tom lane