Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 23FC8650160
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Tue,  8 Jul 2008 16:14:05 -0300 (ADT)
Received: from postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 97031-04-6
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Tue,  8 Jul 2008 16:13:56 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from wf-out-1314.google.com (wf-out-1314.google.com
 [209.85.200.169])
	by postgresql.org (Postfix) with ESMTP id D4F21650310
	for <pgsql-performance@postgresql.org>;
	Tue,  8 Jul 2008 16:13:40 -0300 (ADT)
Received: by wf-out-1314.google.com with SMTP id 25so2610529wfc.28
	for <pgsql-performance@postgresql.org>;
	Tue, 08 Jul 2008 12:13:39 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to
	:subject:mime-version:content-type:content-transfer-encoding
	:content-disposition;
	bh=AmLakzl7bLacL0q33w8dcSnQVrwSkAKtoPw7zupvCIY=;
	b=qx4gyTP/lZcGifz6SG1JBrmN6Kn/H/NSga3FmfApQ5B+MB0Ud0A/wVdkj1jA1+5e49
	gtng7I1q/4jOE8plxPhzPNjIOyUcxIC1D8P4K0Oqw8G387pLyrz00GqCKWZk03trpynU
	2ORCx5fRQ4IjlgKoJ0ySxCe9tumWFu6FBaCkY=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:mime-version:content-type
	:content-transfer-encoding:content-disposition;
	b=Kh5BpyWUk8+O4JpwG69XsriY5PEoMQl2yFpVwmH+wgCZ2zZiibetRbBV6od6uTyRCw
	W0e+/xInCf0Y2h96D8nOXlffgmg4pPpMnNIXDh8nponosCqhgX08/tgb41LYrj+SVzva
	Pqkd8ayolYT7IHeTZspl+P7lOBVyqT4IDB8dA=
Received: by 10.142.223.4 with SMTP id v4mr1934511wfg.107.1215544419460;
	Tue, 08 Jul 2008 12:13:39 -0700 (PDT)
Received: by 10.143.196.4 with HTTP; Tue, 8 Jul 2008 12:13:39 -0700 (PDT)
Message-ID: <fe27bfd40807081213q4a8bba99yeda5dd748ea235ca@mail.gmail.com>
Date: Tue, 8 Jul 2008 15:13:39 -0400
From: "Radhika S" <radhika.sambamurti@gmail.com>
To: pgsql-performance@postgresql.org
Subject: max fsm pages question
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.95 tagged_above=0 required=5 tests=AWL=0.950
X-Spam-Level: 
X-Archive-Number: 200807/73
X-Sequence-Number: 30673

Hi,

when i issued the vaccuum cmd, I recieved this message:

echo "VACUUM --full -d ARSys" | psql -d dbname

WARNING:  relation "public.tradetbl" contains more than
"max_fsm_pages" pages with useful free space
HINT:  Consider compacting this relation or increasing the
configuration parameter "max_fsm_pages".
NOTICE:  number of page slots needed (309616) exceeds max_fsm_pages (153600)
HINT:  Consider increasing the configuration parameter "max_fsm_pages"
to a value over 309616.
VACUUM

What does the warning indicate? How will it adversely affect the system.

Thanks.
-rs


-- 
It is all a matter of perspective. You choose your view by choosing
where to stand. --Larry Wall