|
Home > Archive > PostgreSQL Performance > March 2006 > Decide between Postgresql and Mysql (help of comunity)
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Decide between Postgresql and Mysql (help of comunity)
|
|
| Marcos 2006-03-28, 1:32 pm |
| 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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
| |
| Madison Kelly 2006-03-28, 1:32 pm |
| 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)
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
| |
| Vivek Khera 2006-03-29, 11:31 am |
|
On Mar 28, 2006, at 1:57 PM, Madison Kelly wrote:
> From what I understand, PostgreSQL is designed with stability and
> reliability as key tenants. MySQL favors performance and ease of
> use. An
From my point of view, mysql favors single-user performance over all
else. Get into multiple updaters and you are competing for table
locks all the time. Postgres works much better with multiple clients
writing to it.
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
|
|
|
|
|