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

Re: Decide between Postgresql and Mysql (help of comunity)

From: Madison Kelly <linux(at)alteeve(dot)com>
To: Marcos <mjs_ops(at)gmx(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Decide between Postgresql and Mysql (help of comunity)
Date: 2006-03-28 18:57:37
Message-ID: 44298721.5050400@alteeve.com (view raw or flat)
Thread:
Lists: pgsql-performance
Marcos wrote:
> Hi,
> 
> I'm a Postgresql's user and I think that it's very very good and
> robust. 
> 
> In my work we're confuse between where database is the best choose:
> Postgresql or Mysql. The Mysql have the reputation that is very fast
> working in the web but in our application we are estimating many access
> simultaneous, then I think that the Postgresql is the best choice. 
> 
> Am I right?
> 
> Our server have 1 GB of RAM, how many users can it support at the same
> time with this memory?
> 
> Thanks in advanced
> 
> Marcos

  The RAM/users question depends largely on what the database is used
for and what each user is doing in the database.

  From what I understand, PostgreSQL is designed with stability and
reliability as key tenants. MySQL favors performance and ease of use. An
example is that, last I checked, MySQL doesn't have an equivalent to
PostgreSQL's 'fsync' which helps insure that data is actually written to
 the disk. This costs performance but increases reliability and crash
recovery.

HTH

Madison

-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
          Madison Kelly (Digimer)
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

In response to

Responses

pgsql-performance by date

Next:From: Scott MarloweDate: 2006-03-28 18:59:52
Subject: Re: Decide between Postgresql and Mysql (help of
Previous:From: Simon RiggsDate: 2006-03-28 18:17:49
Subject: Re: simple join uses indexes, very slow

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