yoav x <yoav112003@yahoo.com> writes:
> I've applied the following parameters to postgres.conf:
> max_connections = 500
> shared_buffers = 3000
> work_mem = 100000
> effective_cache_size = 3000000000
Please see my earlier reply --- you ignored at least
checkpoint_segments, which is critical, and perhaps other things.
Don't forget also that testing mysql/myisam against fsync = on
is inherently unfair.
regards, tom lane