Re: Oracle vs PostgreSQL in real life

Okay,

To answer many replies (thanks!), I'll try to put more details:

* DELL server
P3 600 MHZ
256 M ram
RAID 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 is very 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