On Monday 29 April 2002 15:11, Neil Harris wrote:
For read performance, they are comparable, with mySQL
performing about
50% better.
In the 10% write case, however, Postgres kept going beyond the
client-concurrency load where MySQL falls over.
I suspect that's the problem then. Sometimes every page comes up fast (except
a few specials like "find all pages such that no pages link to them"), then
suddenly, for many minutes, I get nothing but timeouts. I suspect that lots
of people are writing, which makes MySQL fall over. Particularly annoying
when I'm trying to edit an article and I get repeated timeouts - then find
that one of them went through and I get an edit conflict.
phma