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@xxxxxxxxxxxxx> wrote: > 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 > > ---------------------------(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
