Re: [mv] MySQL vs PostgreSQL

[Brian Wright <bdw@aturna.com>]

******    message to minivend-users from Brian Wright <bdw@aturna.com>     ******


On 12-Jul-2000 Mark Stosberg wrote:
> That sounds good as far as picking the best of easy database package,
> but the idea of maintaining two databases for a single project sounds
> like a big headache to me. You'd have to know the particularities of
> each to handle crashes and backups, etc.

And let's not forget the memory consumption that will occur if you have both
MySQL and PostgreSQL daemons running at the same time. :)

> 
> I use Postgres for dozens of projects of varying sizes, and have always
> been happy with the performance. I think when MySQL really pulls ahead
> on performance in a noticeable way is when you have a huge amount of
> hits, maybe 100,000 hits a day (I'm saying that without having tested
> it). 
> I think in a lot of cases Postgres provides great performance in
> addition to it's nice additional features.

Since Postgres is now at 7.0.2, I do plan to use it with my shops since it has
the transaction logging.  Though, MySql does appear to have more apps written
for it.

--Brian

_________________________________________________________________________
Brian Wright                                   Aturna Communications Inc.
bdw@aturna.com                                          Internet Services
AIM: BigBY2K ICQ: 21221328                      WWW http://www.aturna.net
_________________________________________________________________________
-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list