Re: time sensitve: comparing performance to MySQL
От | Ryan Mahoney |
---|---|
Тема | Re: time sensitve: comparing performance to MySQL |
Дата | |
Msg-id | 1065193859.1216.47.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | time sensitve: comparing performance to MySQL (Mark Stosberg <mark@summersault.com>) |
Список | pgsql-advocacy |
On Thu, 2003-10-02 at 12:17, Mark Stosberg wrote: > I understand that Postgres has been closing the speed gap with MySQL, > but I'm having trouble finding hard data on this. The "speed gap" you speek of is a myth, try to find some hard data on that! The cases where mysql can really fly are not generally the application scenarios you encounter in the real world unless you are working with a read-high/write-low cases. Unfortunately, without porting your app to both dbs you can not verify this experientially. You could easily create an app to stress test both dbs (creating a php script with a few queries from your app) and hit it with apache bench to simulate your load. We have been using postgres since 2000 for some relatively complex e-commerce and order management projects. We used mysql for about a week because we weren't familiar with postgres and we bought into the mysql hype. But coming from Oracle and MSSQL, mysql was a total joke and didn't have the features to support our application so we had to disqualify it before we could even bench it. Postgres is a pleasure, especially if you are coming from an Oracle environment. -r
В списке pgsql-advocacy по дате отправления: