| From: | Jim Nasby <jim(at)nasby(dot)net> |
|---|---|
| To: | "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com> |
| Cc: | Merlin Moncure <mmoncure(at)gmail(dot)com>, Bill Moran <wmoran(at)potentialtech(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: DB files, sizes and cleanup |
| Date: | 2010-12-19 18:07:25 |
| Message-ID: | 1B027613-F5FE-46BA-9F95-8BB442980D96@nasby.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 very end 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(at)nasby(dot)net
512.569.9461 (cell) http://jim.nasby.net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Raimon Fernandez | 2010-12-19 18:58:46 | Re: Getting number of affected rows after DELETE FROM |
| Previous Message | Jim Nasby | 2010-12-19 18:05:04 | Re: Table both does not and does exist! wth? |