Re: Oracle vs PostgreSQL in real life

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