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 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)
max_connections = 32
superuser_reser ved_connections = 2
shared_buffers = 30000
max_fsm_relatio ns = 10000
max_fsm_pages = 100000
max_locks_per_t ransaction = 128
wal_buffers = 32
sort_mem = 1024
vacuum_mem = 8192
checkpoint_segm ents = 16 # in logfile segments, min 1, 16MB each
fsync = false
open_datasync
effective_cache _size = 20000 # typically 8KB each
The total database size on disk is ~6GB.
Some tables get changed *very* frequently. A nightly "vacuum full
analyze" frees about 250,000 rows on each of three tables.
And yes I will change to 7.4 this week.
TIA
Ulrich
--
------------------------------------------------------------
Relevant Traffic AB, Riddargatan 10, 11435 Stockholm, Sweden
Tel. +46-8-6789750 http://www.relevanttraffic.se
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postg resql.org so that your
message can get through to the mailing list cleanly