Joe Brenner <[EMAIL PROTECTED]> wrote:
> "Greg Wright" <[EMAIL PROTECTED]> wrote:
>
> > On 5/07/00 at 17:49 Ivan Jager wrote:
> >
> > >What are the main differences between MySQL and postgresql? I would like
> > >to keep squid's logs in a database to be able to make some queries and
> > >all that. :)
> > >
> > >I was going to use postgres, but now that MySQL is Free it makes me
> > >wonder...
> > >
> > >What are the advantages/disadvantages of current versions of postgres
> > >and MySQL?
> > >
> >
> > PostgreSQL is more of a full featured database, MySQL is fast and light
> > because its a "cut down" SQL server if you like
> >
> > For logging, MySQL would be more than sufficient in my limited database
> > opinion
A really amazingly good article has just gone up on PHPBuilder.com
on this subject: "MySQL and PostgreSQL Compared":
http://www.phpbuilder.com/columns/tim20000705.php3?page=1
This guy doesn't pull any punches, he does a good job of
laying out the quirks of both pieces of software, and
actually took the trouble to work up a detailed "real world"
example to test them.
One of the interesting points he makes is that while MySQL
can indeed serve up a page faster than postgresql, it also
bogs down much faster under multiple connections, so the two
are more or less matched as far as handling heavy load database
backed websites.
He concludes:
These tests pretty much confirmed what I already knew - both databases
serve quite well for the vast majority of web sites out there. Both
are actually extremely fast when compared to desktop databases like
FileMaker and MS Access. Both are now free and supported by an active
developer community.
_______________________________________________
Redhat-devel-list mailing list
[EMAIL PROTECTED]
https://listman.redhat.com/mailman/listinfo/redhat-devel-list
