Re: Catching up Production from Warm Standbyaftermaintenance - Please help

On Dienstag 07 Juli 2009 Scott Whitney wrote:
> max_fsm_pages = 1500000                 # min max_fsm_relations*16, 6
> bytes each
> max_fsm_relations = 70000               # min 100, ~70 bytes each
>
> It's quite possible that those settings are too low, but I've
> honestly no idea how to estimate these other than trial and error.
> I've not had the time to really brush up on that level of tuning.

Isn't
# VACUUM ANALYZE VERBOSE ;
showing that info in the end? Or are those only for the current db, not
for the server overall?

INFO:  free space map contains 32526 pages in 68 relations
DETAIL:  A total of 31648 page slots are in use (including overhead).
31648 page slots are required to track all free space.
Current limits are:  150000 page slots, 1000 relations, using 984 kB.

mfg zmi
--
// Michael Monnerie, Ing.BSc    -----      http://it-management.at
// Tel: 0660 / 415 65 31                      .network.your.ideas.
// PGP Key:         "curl -s http://zmi.at/zmi.asc | gpg --import"
// Fingerprint: AC19 F9D5 36ED CD8A EF38  500E CE14 91F7 1C12 09B4
// Keyserver: wwwkeys.eu.pgp.net                  Key-ID: 1C1209B4