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

Cross-posted to "comp.databases.postgresql.advocacy" because
PostgreSQL could be very helpful to MySQL DBAs who wish to optimize their
databases -- just convert it to PostgreSQL on a test system and use EXPLAIN
and ANALYZE to identify the weaknesses.

Even if these MySQL DBAs don't use PostgreSQL for anything else, at
the very least it will increase awareness of the product. =)

> 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.

--
Randolf Richardson - rr(at)8x(dot)ca
Vancouver, British Columbia, Canada

Please do not eMail me directly when responding
to my postings in the newsgroups.