yoav x <yoav112003@xxxxxxxxx> 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
