Postgres Pro
Downloads
Home   >   mailing lists

Re: DB files, sizes and cleanup - Mailing list pgsql-general

From Jim Nasby
Subject Re: DB files, sizes and cleanup
Date
Msg-id 1B027613-F5FE-46BA-9F95-8BB442980D96@nasby.net
Whole thread Raw
In response to Re: DB files, sizes and cleanup  ("Gauthier, Dave" <dave.gauthier@intel.com>)
List pgsql-general
Tree view 
On Dec 17, 2010, at 4:22 PM, Gauthier, Dave wrote:
> max_fsm_pages = 200000

Don't know that this is related, but that count is pretty low. If you run a vacuumdb -av and capture the output, the
veryend will tell you how many FSM pages you actually need; it's very possible 200,000 isn't enough. 
--
Jim C. Nasby, Database Architect                   jim@nasby.net
512.569.9461 (cell)                         http://jim.nasby.net

pgsql-general by date:

Previous
From: Jim Nasby
Date:
Subject: Re: Table both does not and does exist! wth?
Next
From: Raimon Fernandez
Date:
Subject: Re: Getting number of affected rows after DELETE FROM