On Wed, May 06, 2009 at 02:49:23PM +0200, Dimitri wrote: > The story is simple: for the launching of MySQL 5.4 I've done a > testing comparing available on that time variations of InnoDB engines, > and at the end by curiosity started the same test with PostgreSQL > 8.3.7 to see if MySQL performance level is more close to PostgreSQL > now (PG was a strong true winner before). For my big surprise MySQL > 5.4 outpassed 8.3.7... > However, analyzing the PostgreSQL processing I got a feeling something > goes wrong on PG side.. So, now I've installed both 8.3.7 and 8.4beta1 > to see more in depth what's going on. Currently 8.4 performs much > better than 8.3.7, but there is still a room for improvement if such a > small query may go faster :-) > > Rgds, > -Dimitri > > On 5/6/09, Albe Laurenz <laurenz.albe@xxxxxxxxxx> wrote: > > Dimitri wrote: > >> I've run several tests before and now going in depth to understand if > >> there is nothing wrong. Due such a single query time difference InnoDB > >> is doing 2-3 times better TPS level comparing to PostgreSQL.. > > > > Why don't you use MySQL then? > > Or tune PostgreSQL? > > > > Yours, > > Laurenz Albe > > Another thought, have you tuned PostgreSQL for an in memory database? Those tuning options may be what is needed to improve the plan chosen by PostgreSQL. Cheers, Ken -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
