The only other database is template0, which gives a value of 30 for the
query; the OS is linux 2.4.5, postgresql is version 7.2.
What MAX_FSM_* settings do you recommend?
Philip Warner heeft op woensdag, 18 dec 2002 om 13:14
(Europe/Amsterdam) het volgende geschreven:
At 01:00 PM 18/12/2002 +0100, Roel Rozendaal - IC&S wrote:
it got me a value of 38; the system has default config of
max_fsm_relations (100) so that shouldn't be the problem either.
Be careful with this. You need to do this for each database (except
template0). Try '\l' in psql to get a lict of databases, then connect
to each and run the query - the max_fsm_relations should be the sum of
them all. 38 is very unlikely to be right. But 100 could still be OK
if dbmail is the only other DB.
Once you have a value for max_fsm_relations (it's cheap, and the
future default will be nearer 1000), you need to set max_fsm_pages (I
*know* the default is too low for your requirments) and the VACUUM
frequency.
If you continue to experience VACUUM killing the server, then you may
need to set MAX_FSM_PAGES very high.
Which OS and version of PG are you running?
----------------------------------------------------------------
Philip Warner | __---_____
Albatross Consulting Pty. Ltd. |----/ - \
(A.B.N. 75 008 659 498) | /(@) ______---_
Tel: (+61) 0500 83 82 81 | _________ \
Fax: (+61) 03 5330 3172 | ___________ |
Http://www.rhyme.com.au | / \|
| --________--
PGP key available upon request, | /
and from pgp5.ai.mit.edu:11371 |/
_______________________________________________
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
