Re: [GENERAL] stone-age maintenance procedures ;-)

2004-08-26 Thread Tom Lane
Ulrich Wisser <[EMAIL PROTECTED]> writes: > max_fsm_relations = 1 > max_fsm_pages = 10 > The total database size on disk is ~6GB. Most likely, you need larger max_fsm_pages. 6GB would work out to about 750K pages (of 8K each). With max_fsm_pages of 100K you are saying that you don't exp

Re: [GENERAL] stone-age maintenance procedures ;-)

2004-08-26 Thread Christopher Browne
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Ulrich Wisser) wrote: > select version(); > > PostgreSQL 7.3.4 on i386-redhat-linux-gnu, compiled by GCC > i386-redhat-linux-gcc (GCC) 3.2.2 20030222 (Red Hat Linux 3.2.2-5) > (1 row) Happily, that's not _scary_ obsolete. There's st

[GENERAL] stone-age maintenance procedures ;-)

2004-08-26 Thread Ulrich Wisser
Hi, lately I've been acused of "stone-age maintenance procedures". Hopefully I will find some help to develop from stone-age to roman empire. ;-) To optimize the performance and to minimize the maintainance needs I would like to ask you guys about some values in my postgresql.conf. select versi