Skip site navigation (1) Skip section navigation (2)

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

From: Randolf Richardson <rr(at)8x(dot)ca>
To: "pgsql-advocacy(at)postgresql(dot)org(dot)pgsql-general"(at)postgresql(dot)org
Subject: Re: PostgreSQL is much faster than MySQL, only when...
Date: 2003-11-25 18:08:53
Message-ID: Xns943E652C14D9Crr8xca@200.46.204.72 (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-general
    	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.

In response to

pgsql-advocacy by date

Next:From: Bruce MomjianDate: 2003-11-25 18:36:50
Subject: Re: [HACKERS] Commercial binary support?
Previous:From: Marc G. FournierDate: 2003-11-25 18:07:41
Subject: Re: Gforge

pgsql-general by date

Next:From: Randolf RichardsonDate: 2003-11-25 18:18:28
Subject: Re: [OT... But couldn't resist!] Master/Slave
Previous:From: Randolf RichardsonDate: 2003-11-25 18:04:02
Subject: Re: duplicate primary key entries?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group