Message-ID: <44298721.5050400@alteeve.com>
Date: Tue, 28 Mar 2006 13:57:37 -0500
From: Madison Kelly <linux@alteeve.com>
User-Agent: Thunderbird 1.5 (X11/20051201)
MIME-Version: 1.0
To: Marcos <mjs_ops@gmx.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: Decide between Postgresql and Mysql (help of comunity)
References: <1143559902.1241.16.camel@servidor>
In-Reply-To: <1143559902.1241.16.camel@servidor>
Content-Type: text/plain; charset=ISO-2022-JP
Content-Transfer-Encoding: 7bit

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)
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-