From: | Michael Monnerie <michael(dot)monnerie(at)is(dot)it-management(dot)at> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Catching up Production from Warm Standbyaftermaintenance - Please help |
Date: | 2009-07-13 06:40:47 |
Message-ID: | 200907130840.53105@zmi.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Ibrahim Shaame | 2009-07-13 12:56:36 | Re: Cannot compile pgadmin3-1.10.0-beta3 |
Previous Message | Iñigo Martinez Lasala | 2009-07-11 14:05:30 | Re: Setting Shared-Buffers |