Re: PostgreSQL and sql-bench

Hi

I am not comparing Postgres to MyISAM (obviously it is not a very fair comparison) and we do need
ACID, so all comparison are made against InnoDB (which now supports MVCC as well). I will try
again with the suggestions posted here.

Thanks.

--- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> yoav x <yoav112003(at)yahoo(dot)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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com