Okay,
To answer many replies (thanks!), I'll try to put more details:
* DELL serverP3 600 MHZ 256 M ramRAID 5
* kernel
Linux int2412 2.4.9-21SGI_XFS_1.0.2 #1 Thu Feb 7 16:50:37 CET 2002 i686 unknown
with aacraid-cox because aacraid had poor perfs with this server (at 1st we
tought about raid5 problems)
* postgresql.conf : here are _all_ uncomented parameters:
tcpip_socket = true
max_connections = 16
port = 5432
shared_buffers = 19000 # 2*max_connections, min 16
max_fsm_relations = 200 # min 10, fsm is free space map
max_fsm_pages = 12000 # min 1000, fsm is free space map
max_locks_per_transaction = 256 # min 10
wal_buffers = 24 # min 4
sort_mem = 8192 # min 32
vacuum_mem = 8192 # min 1024
wal_debug = 0 # range 0-16
fsync = true
silent_mode = true
log_connections = false
log_timestamp = false
log_pid = false
debug_level = 0 # range 0-16
debug_print_query = false
debug_print_parse = false
debug_print_rewritten = false
debug_print_plan = false
debug_pretty_print = false
show_parser_stats = false
show_planner_stats = false
show_executor_stats = false
show_query_stats = false
transform_null_equals = true
* /proc parameters:
proc/sys/kernel/shmall => 184217728 (more than 130M)
proc/sys/kernel/shmall => 184217728
* we made a bunch of vmstat logs too, we made graphics to understand, all in a postscript file, with gun graph ... this
isvery interesting, but as I dont
know if attachments are autorized here, please tell me if I can post it too. It
shows swap in/out, memory, I/O, etc..
Thanks for your support!
--
Jean-Paul ARGUDO
