Re: Any better plan for this query?..

From: "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "Dimitri *EXTERN*" <dimitrik(dot)fr(at)gmail(dot)com>, "Richard Huxton" <dev(at)archonet(dot)com>
Cc: "Chris" <dmagick(at)gmail(dot)com>, "Craig Ringer" <craig(at)postnewspapers(dot)com(dot)au>, "PostgreSQL Performance" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Any better plan for this query?..
Date: 2009-05-06 11:57:32
Message-ID: D960CB61B694CF459DCFB4B0128514C202FF65A9@exadv11.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Dimitri 2009-05-06 12:33:13 Re: Any better plan for this query?..
Previous Message Merlin Moncure 2009-05-06 11:47:22 Re: Any better plan for this query?..