Re: PostgreSQL and sql-bench

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