On 2/19/07, Tzahi Fadida <[EMAIL PROTECTED]> wrote:
On Monday 19 February 2007 11:58, Israel Shikler wrote:
> Hi ,
>
> I see your post here concerning PostgresQL.
> We are using RedHat & Mysql.
> Is there any advantages using PostgresQL over Mysql?
There are advantages both ways.
You will need PostgreSQL when:
1) You need a database that can handle a very large load of queries per a
small unit of time (secs,minutes).
2) You need a database that can handle transactions in an efficient manner,
plus, you require a transactional system that has many features like save
points in a middle of a transaction and you can role back to a savepoint
instead of the whole transaction.
3) You need a very wide and extendable syntax and operations.
4) You need an RDBMS that can handle itself in catastrophies such as point in
time recovery. i.e. using the transactions log to reconstract the last
queries, etc...
All of the above requires investment of resources which are wasted if you
don't need those advantages. MySQL will serve you better for a small load of
queries. It has a less extensive tranactional support. It's syntax is suited
for smaller applications. Finally, PostgreSQL exists in various forms for 20
year so it is a beast of a thing that is very mature. MySQL has only matured
in features in the last years. This race to features left much to be desired.
There is no reason to use PostgreSQL for small apps or small load apps, in
fact perhaps even MySQL is an overkill and there are even more efficient
databases.
>
> Regards,
>
> Israel Shikler
> Softkol Ltd
>
--
Regards,
Tzahi.
--
Tzahi Fadida
Blog: http://tzahi.blogsite.org | Home Site: http://tzahi.webhop.info
WARNING TO SPAMMERS: see at
http://members.lycos.co.uk/my2nis/spamwarning.html
What about redundancy. I need an active-active cluster for databases
to get the 5*'9's up time euphoria. Is there an open source database
that can do that? Planing to? Tried to?
--
Cheers,
Maxim Veksler
"Free as in Freedom" - Do u GNU ?
=================================================================
To unsubscribe, send mail to [EMAIL PROTECTED] with
the word "unsubscribe" in the message body, e.g., run the command
echo unsubscribe | mail [EMAIL PROTECTED]
