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@sss.pgh.pa.us> wrote:
> 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
>
> ---------------------------(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