> I'm a Postgresql's user and I think that it's very very good and
> 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
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
Madison Kelly (Digimer)
In response to
pgsql-performance by date
|Next:||From: Scott Marlowe||Date: 2006-03-28 18:59:52|
|Subject: Re: Decide between Postgresql and Mysql (help of|
|Previous:||From: Simon Riggs||Date: 2006-03-28 18:17:49|
|Subject: Re: simple join uses indexes, very slow|