Re: PostgreSQL is much faster than MySQL, only when...

And ofcourse, you ran ANALYZE before doing any timings, right?

On Tue, Nov 25, 2003 at 01:08:55PM +0100, Marek Lewczuk wrote:
> Hello,
> I have changed DB from MySQL to PostgreSQL. When I have run my
> application on PostgreSQL it was disaster - it was much slower than
> MySQL...
>
> I have tried to change PG configuration file etc.. no luck. After many
> long days of thinking what is wrong I have made several tests with
> "EXPLAIN" statement, and to my amusement there was many SeqScan - MySQL
> didn't show that things. I have made some changes in PG db structure
> (new indexes etc) and then I have made another test: PostgreSQL time -
> 10ms, MySQL time - 1 sec. I've tried to change the structure in MySQL
> but it didn't change the results.
>
> So my advise for all users which think that MySQL is faster than PG -
> re-check your DB structure, check all your querys using EXPLAIN... maybe
> new indexes should be added etc.
>
>
> Regards,
> Marek
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>      subscribe-nomail command to majordomo@postgresql.org so that your
>      message can get through to the mailing list cleanly

--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> "All that is needed for the forces of evil to triumph is for enough good
> men to do nothing." - Edmond Burke
> "The penalty good people pay for not being interested in politics is to be
> governed by people worse than themselves." - Plato